Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Sub-Report does not display data 1

Status
Not open for further replies.

majordog

Programmer
Jul 8, 2002
222
CA
Hi All,

I have a linked sub-report. My main report Test_Results, has a field 'Vehicle ID'. The sub-report, based on this table:

'Vehicle Coefficient'
ID
Vehicle ID
Dyno
Temperature
A
B
C

The subreport link is based on the Vehicle Coefficients table based on the Test_Results.VehicleID and the Vehicle Coefficients.ID. I can run the sub report independently, provide the parameter value and I get data in the report. But if I run it from the Master Report, I get no data...Does anyone have any ideas what may be going wrong here?
S
 
I'm guessing that what you want to link on is:

Test_Results.VehicleID = VehicleCoefficient.VehicleID

not the Vehicle Coefficients.ID.

If that's not it, check the record selection criteria in the subreport.

-k kai@informeddatadecisions.com
 
Thanks for your comment - actually, that was a typo. I have set what you recommended. In actuality, I have solved the problem. I looked into the parameter code and there was criteria there that should not have been there.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top