Report returns no results at runtime

[obscuregirl]

Hi

I have a report which works fine in the preview window but returns no results at Runtime.

The only difference I can think of between this report and other ones I have done that work is that the one that doesn't work uses a view that casts a string into a datetime and extracts the year part of the date. Then in the Record Selection part of the report I then have to convert that year back to a string to compare it to a parameter.

Can anyone think of any reason why this might be a problem or if there's any other reason for the report not returning any results at runtime?

Thanks

[shukla]

check the connection to that report at run time.
may be connection is not valid,

[obscuregirl]

Do you mean the code in my front end application? I've got a generic screen that contains a report viewer to show all the reports I'm creating. For each report, I pass in a path to find the report and the database connection information (which is the same for all the reports). Most of my reports work fine, it's just this one that doesn't.

Is there anything else I should check?

[hairball]

Have you changed your database design after making this report? Maybe you need to use Verify Database.

[shakti5385]

Hi

I have a report which works fine in the preview window but returns no results at Runtime.

Thanks

You did not show that which report you are using ....
I think you are using the crystal report
see the option save data with report in the menu if it is checked then remove it first.

for more detail of crystal report you can click on the crystal report tutorial link is at my siganature

[obscuregirl]

Thanks for all your replies. I figured out that a formula I'd put in the Record Selection section was causing problems. Once I'd sorted that out, it worked fine!

[shakti5385]

Thanks for all your replies. I figured out that a formula I'd put in the Record Selection section was causing problems. Once I'd sorted that out, it worked fine!

Your Welcome
That’s good, if you got the solution of your problem then go to the thread tool menu and resolved this thread.