Copy a Group Header in Master Report to Report Header in Sub Report

Data is from  different databases...I have several groups in the Main Report.. The subreport is residing in the Group Footer of the Main Report...

I need this "copied Group Header" to only show where there is data on the SubReport in its Report Header

Hopefully this makes sense
Michael KatzAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You can pass all the information used to create the group header to the subreport the show it in the subreport report header or a group header

TO share data with the subreport create 3 formulas

In the main report add a formula to the report header
WhilePrintingRecords;
Shared NumberVar MyValue;
""

Open in new window


IN the main report group header
WhilePrintingRecords;
Shared NumberVar MyValue;
MyValue := {SomeDatabase Field};
""

Open in new window


In the subreport where you want to display the value
WhilePrintingRecords;
Shared NumberVar MyValue;
MyValue 

Open in new window


Similarly for all values.  In the main report you can declare and set values to multiple variables

WhilePrintingRecords;
Shared NumberVar MyValue;
Shared DateTimeVar MyDateTime;
MyValue  := {SomeDatabase Field};
MyDateTime := {A DateTIme Field};
""

Open in new window


mlmcc
0
 
Michael KatzAuthor Commented:
So I cant do this on an entire section??  I have to do it field by field
0
 
mlmccCommented:
What do you mean an entire section?

Does the subreport use the same data source?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.