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

show group header labels on continous page...

Status
Not open for further replies.

mission2java

Programmer
Jul 3, 2001
129
US
I got a subreport and within that subreport right before the details section I have a group headere #1f. In there I have just some heading labels:
Position Quantity Description

Right underneath that there is a details section which lists components...A lot of times the components fall on the next page because there are so many. But the problem is it does not show Position Quantity Description on the next page..it just shows the rows without the headings. I would like it so that if the details section goes on to another page to show those headings. Is it possible?

Thanks,
Jon
 
You can change move the column headings into the main report. You can have the Group Header report on every page so that it show them on every page.

~Brian
 
That second sentence should have read that you can have the Group Header repeat on every page so that it shows the headings on every page.

~Brian
 
o i cant have it on my main report because this heading is shown after a TON of information from my sub report...
meaning my report might look like this:

Customer

[Subreport]
Function: blah blah blah

Description: blah blah blah

[HEADING I WANT] [HEADING I WANT] [HEADING I WANT]
1 2 blah
2 4 blah...
....

those headings should be in the sub report and only displayed after the function and description which I have correctly done. The only thing I need is for the heading to show up on another page ONLY if it is the same record it refers to when the components have exceeded the initial page.
 
Within the subreport, go to report->change group expert->select the group->options and check "Repeat group header on each page."

-LB

 
Yeah, I misread your post, sorry. I believe that lbass's post will work for you.

~Brian
 
The problem is the header of the entire group is NOT what i want repeated. See what I did was I added a section beneath by selecting Insert Section below. And in there I created those three labels. I just want those three labels to show up. I dont want the entire group to show up that is the problem.

It is so difficult explaining issues in crystal because there is just WAY too much stuff!!!

jon
 
Use my earlier suggestions and then in the subreport, go into format->section->group header_a->suppress->X+2 and enter:

InRepeatedGroupHeader

That should suppress the group header section you don't want repeated.

-LB
 
ok so do what you said from earlier about group by...

but i tried the second part i went to the format at the top menu but there is no section to select? where is this format-> section ???

Cluttered Crystal!
 
Section is an option under Format in 8.0 --you didn't mention what version you are using. You can also right click on the gray area to the left of the report canvas and choose format section. Then you have to highlight (click on)the section you want to format, in your case, I think it is Group Header_a and then continue as above.

-LB
 
Also on mine when i go into the subreport in the section expert it shows:

Report Header
report header a
report header b
Group Header #1: Transports.TPos - A
Group Header #1a: Transports.Tpos - A
Group Header #1b: Transports.Tpos - A
Group Header #1c: Transports.Tpos - A
Group Header #1d: Transports.Tpos - A
Group Header #1e: Transports.Tpos - A
Group Header #1f: Transports.Tpos - A
Details
Group Footer #1: Transports.TPos - A
Report Footer
Report footer a
Report footer b


So which one of these am I changing with the x+2???




 
Hi lbass I already have a formula in there from an earlier problem. Can I add two formulas at once?
Count({Transports.Tpos}) < 1 is what i have right now for the (Suppress No Drill Down) X+2 thingy :)

I want to add what you said...but cant.

Jon
 
You should be able to add to it. Try this on section Group Header #1a: Transports.Tpos - A and test before repeating for the rest.
Code:
Count({Transports.Tpos}) < 1
OR
InRepeatedGroupHeader


~Brian
 
It worked...

How will I ever learn all of this stuff!!!!
I mean seriously!!! I would have never though of what lbass pointed out.

Now if only i can get my other issue resolved ill be done on the report that i spent awhoole day on :|
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top