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

Group formatting/printing dilemma

Status
Not open for further replies.

jdemmi

MIS
Jun 6, 2001
1,106
US
Tough one to explain. But here goes....

CR11 btw....

I have a report which contains 4 subreports.

The main report contains 1 group which is also used to link to each of the 4 subs.

I want the report, when printed, to behave in a way I am not sure is possible.

Here's where the explanation gets hard.

Instead of the report printing in normal fashion
GH1
GH2
DETAILS
GF2
GF1
etc....

I want the following.

Main Report Group 1 Header Data (printed until the last record in the main report is reached)

THEN

Sub Report 1 Data (printed until the last record in sub 1 is reached)

THEN

Sub Report 2 Data (printed until the last record in sub 2 is reached)

THEN

Sub Report 3 Data (printed until the last record in sub 3 is reached)

THEN

Sub Report 4 Data (printed until the last record in sub 4 is reached)

In essence I guess I want to group my subreports?! I THINK.

Any ideas??

-- Jason
"It's Just Ones and Zeros
 
Add 3 report footers and put a subreport in each one in the order you want them to print.
 
tried that but the records in the subs are based on an ID field from the records in the main (group)

-- Jason
"It's Just Ones and Zeros
 
You can put subreports in group headers or footers. Does that help?

Also take a look at Crosstabs, they can group the same data in different ways. You can have more than one in a report.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
I've tried various GH, GF configs but it doesn't get me what I need since the data in the sections is then interleaved.

GH1A
GH1B
DETAIL
GF1A
GF1B

GH1A
GH1B
DETAIL
GF1A
GF1B

I need

GH1A
GH1A
GH1A

GH1B
GH1B
GH1B


etc...


I haven't tried cross-tabs


-- Jason
"It's Just Ones and Zeros
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top