Grouping & Totalling by a variable

[Legend1]

Hi all,

I have a report that I need to create a subtotal by a field in a diferent database in a subreport, which I am bringing back to the main report as a variable. Some of the fields in the subreport return nothing which I would want grouped by "Blank" and everything else grouped by whatever the field returns.

I cannot see it in the insert group drop down list but i think it has to do with the point in time it is evaluated.

Has anyone got any input.

Grant

 

[Legend1]

Please, anyone who can point me in the right direction please do so. This one is very urgent.

Thanks in advance.

 

[Madawc]

First, grouping only works with things that are directly based on individual records. Data from a subreport can only be used by the next section of the main report.

What you could do is create a set of running totals for the different values that the subreport might return. I suspect you'd have to do this via a formula field in a section below the section you are totalling.

Alternatively, try re-thinking the basic design. If you need to group by the subreport's data, maybe it should be the main report. It all depends on the overall process.

It helps to give your Crystal version, since newer versions have extra solutions, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia)