Group on a Formula

[ThomasBrown]

Hi,

I need to group on a formula,

basically my columns look like:

EvtID FuncID Seq Lvl ParentID Desc
1234 110 1 1 0 Space & Charges
1234 120 1 1 0 Friday 2005\01\05
1234 122 3 1 0 Saturday 2005\01\06
1234 130 2 2 120 Catering
1234 160 4 3 130 Lunch Menu

etc etc ... if you need more details I'll put some more in.

Now, what I am trying to do is do a Grouping where the ParentID = 0 but not on Space and Charges. But after I have done this grouping I still need to access the Items on Lvl 1 or that have ParentId's. What I have tried doing now, which works to a point is do a Group on Parent ID, then choose Specified, and then Make a group on ParentID where it is equal to 0 and then discard all other items, but then After this I cannot get it to display the Catering or Lunch Menu items as they where discarded above. The other thing I thought of doing is putting this into a Sub-report, but i can't do that either as information following this, needs to go in a subreport and i can't have a subreport within a subreport.

Many Thanks
Thomas

 

[rosemaryl]

Dear Thomas,

What database, what version of Crystal and what does the report need to look like?

I cannot determine the logic behind your stated criteria ...

Regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Madawc]

Create a formula field that assigns each record to Group 1, Group 2 etc. on the basis of your rule. Display it in the detail line, to confirm that it is doing what you want. Then remove it from the detail line and use it to group instead.

Madawc Williams (East Anglia, UK)