tmz

When I try to preview my report I am prompted to log into the datasource and then no results are returned. The preview is completely blank.

Re: Crystal Reports for Visual Studio Report Preview is blank

Joe Beam

hmmm...

Well this could be a number of things.

Are you sure the login is correct
Selection criteria
Table links




Re: Crystal Reports for Visual Studio Report Preview is blank

tmz

The login is set to sa and is correct; The report runs when I run it throught the program (microsoft dynamics great plains) so I know the links and the parameters are correct. I am also certain that the criteria is correct.

Someone here thinks that there is something on the program side that is needed to run this report in preview, but it seems to me that if the criteria is SOP number and customer number, and I enter those in the preview, that it wouldn't care about the program as it will pull directly from the database right





Re: Crystal Reports for Visual Studio Report Preview is blank

Joe Beam

Is this Desktop or Web app

If it's a web app, which page event are you setting the report source




Re: Crystal Reports for Visual Studio Report Preview is blank

tmz

Its a desktop app. I am not sure what you mean by 'page event'.



Re: Crystal Reports for Visual Studio Report Preview is blank

Flinky

are you loading your crystal reports correctly onto your win form I had a similar issue of the report preview being blank, and i found out that it was because I typed the Form1_Load method from scratch when I should have double clicked on the form first to get the method, then write ConfigureCrystalReports(); in it.





Re: Crystal Reports for Visual Studio Report Preview is blank

Joe Beam

How are you setting the report source

Handle the CrystalReportViewer's OnError event to get more information.




Re: Crystal Reports for Visual Studio Report Preview is blank

tmz

I am going into set datasource location, and then selecting my odbc connection. I am not familiar with the OnError event. I looked in the helpfiles but did not see any reference to an OnError event. I am working in Crystal 10.



Re: Crystal Reports for Visual Studio Report Preview is blank

Joe Beam

ohhhhh...

So the report runs in the winforms application but you can't get it to run in the Crystal Report Designer






Re: Crystal Reports for Visual Studio Report Preview is blank

tmz

Exactly! I even have a few subreports that will print the design, but no data if I run them individually from the designer. But no data is returned.

The reports work great when I run them through the application.





Re: Crystal Reports for Visual Studio Report Preview is blank

Joe Beam

Then it's most likely the selection criteria or joins that are filtering out all the data. Is it possible you are entering the parameters incorrectly

Try this...

Make sure you have the same report as the win-forms application.

Comment out the record selection criteria.

Test your SQL to make sure it's returning rows. You can go to Database -> Show SQL query... Then run that against your database (you might have to change the syntax a little).