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