Solved

InRepeatedGroupHeader

Posted on 2006-07-20
10
1,893 Views
Last Modified: 2012-06-27
I have multiple groups in my Crystal Report.  I suppressed them so that you can only see them if you drill down into them.  I want to be able to see the page headers in the additional suppressed groups.  I found the topic InRepeatedGroupHeader but couldn't figure out how to do it.  So for example:


First Page
                                                              Total Units Sold                            Total Revenue
Accessories                                                    25                                              6000



When you drill down you see

Clock                                                             15                                                3000
Picture                                                           10                                                3000

The problem is that on the drill down you can't see the headers from the first page.

Thanks
0
Comment
Question by:skielark
[X]
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
  • 4
  • 3
  • 3
10 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 17150736
Can't you just move the Headings into the PAGE HEADER...  it appears that they are in the GROUP HEADER???

MikeV
0
 

Author Comment

by:skielark
ID: 17150747
They are the the page header as I stated above but they do not repeat in the drill down pages.
0
 
LVL 17

Expert Comment

by:MIKE
ID: 17150813
INREPEATGROUPHEADER is used to repeat the group header when the GROUP is continued on the next page. Not the page header

0
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

 
LVL 17

Expert Comment

by:MIKE
ID: 17150825
So just to clarify..you want the PAGE HEADER...to repeat?

Not the REPORT HEADER...and not the GROUP HEADER, correct?

What do you have in the page header that is displaying please?

MikeV
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 17150845
Under the File menu, click on Report Options.
Set the property "Show All Headers on Drill Down"
0
 

Author Comment

by:skielark
ID: 17150980
Total Units Sold                            Total Revenue

I want to see the field headers that are displayed on the first page of my report.  When I drill down into the group summary sections I can't see the field headers.  I don't want to add field headers in the group summary because it lists them mutiple times within the summary.  I simply want the Page Headers to repeat on the drilled down summary pages.  Example below:


                     Total Units Sold        Total Revenue
4578                       56                      78
                     Total Units Sold        Total Revenue
4579                       79                     108  

Here is what I want to see:

                     Total Units Sold        Total Revenue
4578                       56                      78
4579                       79                     108  
0
 
LVL 28

Expert Comment

by:bdreed35
ID: 17150987
Try setting the property I posted in my previous post.
0
 

Author Comment

by:skielark
ID: 17150999
If you are referring to INREPEATGROUPHEADER, that is not what I want to use because I am not using group headers because I don't want to see this:

                     Total Units Sold        Total Revenue
4578                       56                      78
                     Total Units Sold        Total Revenue
4579                       79                     108  

Is there any way that I can display the group header only once and not for every record?
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 500 total points
ID: 17151015
2 different people have posted replies for you, so please only look at mine for a minute and try this:  

Under the File menu, click on Report Options.
Set the property "Show All Headers on Drill Down"
0
 

Author Comment

by:skielark
ID: 17151028
Ok bdreed35 that is exactly what I needed.  Thanks so much for you help.  I spent an hour trying to figure it out.  
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

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 …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
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