Select data in subreport based on field not showing fields

[ginaburg]

I'm using verison 8.5 linking to sql tables
I have a main report with a start and end date parameter field that I want to link to the date field of the subreport.
When I go into the subreport link and select the start date parameter field and insert it, the Select data in subreport based on field dropdown only shows the following:
Report Fields:

Group #1A23101.PAPROJNUMBER

Database Fields:
PA23101

The date field that I have on my subreport does not show up in the dropdown box.

What am I missing?

Thanks
Gina

 

[GMcNamara]

Crystal will only allow you to link fields of the same type. Check the data type of each field.

 

[ginaburg]

They are both date fields.

 

[kutoose]

Gina,
Last week there was a report developer who approached me with the same problem. When I checked the subreport, the procedure was passing the parameter as data type varchar (even though it was date - It was converted to date in the procedure) When he changed the data type to date, the report worked. So I agree with GMcNamara's view.


kutoose@yahoo.com

 

[GMcNamara]

I apologize that my answer was not clear. When you select a parameter in the subreport linking, only fields with an identical data type to your parameter will appear in the drop down box. So, make sure that the field that you want to appear in the box is of an identical data type to the parameter.