multiple details sectons

[KidFix]

This one has completely stumped me:

I need to have two details sections in my report. The report sections need to be layed out like this:

Report Header
group 1 header (grouped by field x)
details a
group 1 footer
group 2 header (grouped by field y)
details b
group 2 footer

that is I need two independent sections to be repeated for different groups, rather than both groups acting on one section. Is this possible?

 

[kenhamady]

If you group by two fields, one group will be within the other.

That means that you won't get to Group Footer 1 until GH2 and GF2 are printed.

It might make more sense if you give a more concrete example of what you are trying to do. I will guess that you are trying to mix 2 different data sets and might need a subreport. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[KidFix]

yeah, so normally when you group twice you get:

group 1 header
group 2 header
details
group 2 footer
group 1 footer

but i need something like:

group 1 header
details a
group 1 footer
group 2 header
details b
group 2 footer

this is the senario:

I need one single section of the report followed by another section detailing building info, this section needs to be repeated for as many building as there are for the specified uid then I need another single section followed by another section detailing 'noteworthy provisions' which has to be repeated for each noteworthy provision there is for that record. Make sense? Sorry, but I don't really know how to explain it any better

thanks

 

[KidFix]

Okay so I'm going with the subreport idea (first time I've tried this) and its working well except...

I'm passing in a where clause on calling the report (sf={uid}=blah blah) but this where clause is not effecting my subreport so where my main report returns just the one record, by subreport returns every record. How can I get the subreport to return just the record the main report is returning?

I've searched around and found something called UFLSTORE which is a secion of memory that is shared between the main report and any subreports within but I can't seem to get it working. I'm using version 8.5, what version of crystal supports ULFSTORE? And is there any better way for my subreport to select just the record of my main report?

 

[KidFix]

s'okay people I figured it out