I am using crystal xi and have a main report with a subreport. Both reports have a 'datetime' field that I need to link on and create a parameter field.

 

For end user ease I have changed the 'datetime' fields to 'date' and linked the subreport using that formula, and all works well.

 

I set up a parameter field for a Date Range and set the {@date} field from Select Expert = parameter field and now the information has changed.

 

I have manually checked the information returning and can't see any obvious problem.

 

Any theories??

 

Thanks very much in advance.

 

I think you are right when you say 'not looking at both the min and max value, but just one of them.' The information returning from the subreport is for one date only and there is data in the subreport for more than one date within the range.

 

How do I 'look at both the min and max value'?

 

I am really stuck on this and am grateful for your help.