need help with group please!

[ron9999]

We use VFP7 CR8.5 and I try my first report. I hope any of you can give me a help with my group problem.

My report should looks like

//(Tp-field group)
Title# pos# txtfield price //normal-item1
Title# pos# txtfield price //normal-item2
Title# pos# txtfield price //normal-item3
//(alternative group)
Title# pos# txtfield price //alternative1-item1
Title# pos# txtfield price //alternative1-item2
Title# pos# txtfield price //alternative1-item3
//(alternative end)
Title# pos# txtfield price //normal-item4
Title# pos# txtfield price //normal-item5
//(alternative group)
Title# pos# txtfield price //alternative2-item1
Title# pos# txtfield price //alternative2-item2
Title# pos# txtfield price //alternative2-item3
//(alternative end)
Title# pos# txtfield price //normal-item6
Title# pos# txtfield price //normal-item7
.....


Fields in a free fox2x table:
tp-field n(5) 1 to the end of table 1.2.3.4….

title# c(10)
pos# c(10)
txtfield c(50)
price long(20,2)
alter bool(.f.) flag
eventual bool(.F.) flag

I thought
sort report on Tp-field than group Tp-field
GH 1 = Tp-field
group the (alter=bool(.t.)flag)and eventual=bool(.t.)flag)
GH 2 = alter
D tp-field title# pos# txtfield price
GF 2
GF 1

But in the preview, EVERY RECORD in (alternative group) evaluates to GH and GF
I hope I could explain my problem clear enough due to my English.
Any help will be appreciated

Thank you in advance
ron

 

[IanWaterman]

What you are trying to do is impossible in Crystal by using Grouping in one report.

By Implication in Crystal Group 2 must be a subset of Group 1, if I have understood your requirement that is not the case with your report.

If you want to break the data up as you have indicated you will probably need to use 1 main report and 4 subreports, each with there own selection criteria set as you require.

Your Tp-field data will form your main report details, then split the report footer into 4 sections and then insert each subreport into there own section.

Ian Waterman
UK Crystal Reports Consultant

 

[ron9999]

thank you Ian,
I have to check out how to split the footer and how to make a subreport. Thank you for pointing me in the right direction.
Ronald Weinrich