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

Posted on 2013-10-28
Last Modified: 2013-10-28
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
Question by:Mikeyman_01
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 101

Accepted Solution

mlmcc earned 500 total points
ID: 39605895
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
Shared NumberVar MyValue;

Open in new window

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

Open in new window

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

Open in new window

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

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

Open in new window


Author Comment

ID: 39607080
So I cant do this on an entire section??  I have to do it field by field
LVL 101

Expert Comment

ID: 39607614
What do you mean an entire section?

Does the subreport use the same data source?


Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question