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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing more than one value to a subreport

Status
Not open for further replies.

McFly77

IS-IT--Management
Jun 20, 2012
8
US
Hi All!

I'm struggling with an Invoice that has a Sub Report linked to the Job number in the Main report.

My problem is that I have a situation where I have 3 jobs on the same Invoice, and the Sub Report is only picking up one of them.

The Job Numbers are on the detail lines in the Main Report. Is there a way to pass all three to the Sub?

Thanks!
Marty

 
Marty,

I think you have to have your Subreport located in the same group-level as the field upon which it is linked. Is your Subreport in the details section of the main report?

If not, please provide clarification about the placement of the Subreport, as well as any groups which exist on the report.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
 
Hi Mike,

Actually it is not in the same section. I have the Sub Report in a Group Footer below the details section.

That makes total sense now that you say that.

The Invoice lines are grouped and summarized by sales class, ie: "Product Sales", "Shipping", etc. but I only seem to be passing one of the three Job Numbers from the Footer.

Thanks,
Marty

 
Marty,

The solution is to restructure the report - I am nearly certain your subreport is likely displaying the last Invoice of the group?

The solution is: (1) either the Subreport should be in the details level of the main report, OR (2) it is perhaps possible to link the Subreport on other fields and have all the Invoice-level details in the Subreport (leaving the subreport in the group footer). If you decide the latter, the linked field will be your Group field; Sales Class.

My apologies if you realized this from my prior post - I wasn't sure from your reply. [smile] I have always thought of Subreports as an "extra linked table" of sorts and treat them much like an extra table join. No doubt not the best of analogies, but has helped me with Subreports from time to time.

Please advise should you have any further questions or troubles getting the results you seek.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
 
Thanks Mike!

I was thinking # 1 is what I probably have to do, but I was hoping it was just a rookie overlook on my part and I could easily pass all three Job ID's into the Sub and summarize it there.

Marty
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top