is there a way to do this?

[buck149]

Crystal XI, Oracle 10g database

I have to convert a mainframe report to Crystal. The mainframe report look like the follows:

agency count promoted count departed count
AC 1 YES 3 DEC. 11 167
CD 15 YES 3 OCT. 09 5
YES 14 NOV. 10 11
JAN. 11 15
FEB. 28 5

My question is, without using subreports or stored procedure, is there a way to do it?

Each column is made of an independent query with a group by clause.

 

[Madawc]

What you can do in Crystal is to group, suppress details and show a mix of counts and details in the group footer. Try it and see.

If you have a specific problem, please explain it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10