Linking Fields for Subreport

[ChopinFan]

I'm having problems setting up a report with a sub report. It will not allow me to use the link child/link master fields to syncronize the reports together. When I tried to let the wizard do it instead and I came to the place where I specify the link fields, it told me the two fields were not the same data type, even though they are the same value coming from the same view (used as a subquery in .adp file)! In the field link part of the wizard, it displays the datatype of the field from the main report as varchar, but does not display any datatype for the same field from the sub-report. Help!?

 

[hneal98]

What are the data types and lengths of each field in each query? Perhaps you can post the queries.

 

[ChopinFan]

Breaking news... I found some documentation about this issue. Apparently .adp files don't like to link subreports based on sprocs, so I changed it to a view and it works ok now.

Thanks for your willingness to help anyway!