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

Posted on 2013-10-28
Medium Priority
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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month11 days, 22 hours left to enroll

752 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