How can i make this groups

[deangelis]

Hi,
Is it possible to insert four groups based on different fields in the same report???
I don't want a hierarchical grouping but four independent groups.
I thought the solution could be the subreport, but the problem is that I'm already in a subreport and I know that I can't make a subreport in another subreport!!! sigh:

The layout should be this:

GH1 table.status_id
table.value
GF1 --------

GH2 table.blabla_id
table.value
GF2 --------

GH3 table.boh_id
table.value
GF3 ---------

GH4 table.another_id
table.value
GF4 -------

DETAILS other data

The problem is also that I have other fields in the detail section that they aren't linked to the different groups.


Ciao da
N@poleone

 

[deangelis]

Sorry, I forgotted the technic characteristics:
CR 8.5
VB 6
Ms Access 97

Ciao da
N@poleone

 

[Madawc]

You can group on a formula field, whose value can be based on several different fields. Does this help?

Alterntively, repeat the existing subreport as three more subreports off of the main report. From within a subreport, you can Save Subeport As, and then reimport. Each could then be changed.

Madawc Williams
East Anglia, Great Britain

 

[deangelis]

I would prefer the first solution, but I don't understand how base a formula on several fields!
I have to return an array??? but it isn't possible!! I can't imagine other way to return the data of interest.
Can you give me a start point, a suggestion to make the formula, then I could go ahead alone

Ciao da
N@poleone

 

[chelseatech]

I can see what you are trying to do.. Just do "Insert Group" four times, once for each field?

Or use a Crosstab as a summary object for each of your summary fields.



Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Madawc]

To use several fields, you create a formula field with somethign like

if isnull ({fieldA}) or {fieldA} = 1
    then {fieldB}
else if {fieldA} = 2 then {fieldC} else {fieldA}

You can also make a selection by parameter, allowing a single report to do several types of grouping.

But if you need to group the same detail lines more than once, you'll have to use subreports.

Madawc Williams
East Anglia, Great Britain

 

[deangelis]

I think that the only solution is to make four subreports.
I wonder why a so powerful software like CR isn't able to group not hierarchically on different fields!!!
Perhaps this problem is solved in newer version than mine??? (8.5)

Ciao da
N@poleone