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

Multple pages with the same details

Status
Not open for further replies.

ColinGregory

Technical User
Feb 16, 2001
39
US
Hi everyone

I would be v grateful if someone could get me started on this.

What I want to do is to create a multi page report (actually more of a form than a report) which will have the same details repeated over more than one page

eg

Page 1

Details
sample number 1
sample number 2
sample number 3

Page 2

sample number 1
sample number 2
sample number 3

Page 3
sample number 1
sample number 2
sample number 3

Each page will have different formatting applied (text objects, lines, boxes etc). I've tried messing about with subreports but had trouble passing the all required sample numbers to the subreport.

Any ideas?
Thanks in advance for any help.
 
Which version of Crystal? In Crystal 8.5, you can't repeat the same set of detail lines more than once, as you wish to.

I'd try making the main report a dummy, doing nothing except pick up parameters. Then have several subreports, which select the data using these parameters (passed on the with [Subreport Links] under [Edit].

Madawc Williams
East Anglia, Great Britain
 
I think you could use the main report detail section for the first page, and then create two subreports (or import one three times and then apply the differential formatting) and place each in its own report footer section. You could use the section expert to format eacg report footer section with "New page before".

If you want to have the user determine the samples to be included in each subreport, then create a parameter in the main report which you reference in the main report selection formula and then also create the parameter in the subreports and use it in the subreport selection formulas also. Then in the main report, go to edit subreport links and choose the parameter from the main report and then in the dropdown on the bottom left, scroll down to pick up the subreport parameter (NOT the ?PM-?parameter). Repeat for the second subreport.

-LB
 
LB and Madawc, Thanks very much for taking the time out to reply - much appreciated.

Here comes the dreaded follow up question with further details...

The initial set of sample numbers will be sent in from an external application (LabWare LIMS)so I don't need any user selection parameters. All I really want to do is pass a list of whatevers in the details section of the main report onto a subreport(s). I would have thought that if I link the {sample number) field in the details section of the subreport to the {sample number} field in the details section of the main report then the two would be identical. Am I being a muppet?

CR v8 by the way.
 
In that case, I think you need to use unlinked subreports, with each subreport using the same datasource as the main report. I think the rest of my suggestions still apply.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top