Conditional Grouping in CR9 1

[mholbert]

I am building a report uses data returned from a stored procedure on a sql server db. The data returned contains monetary values for Payments, Adjustments, and Charges for a Doctors office. Additionally, each row of data is defined as being inside of a particular department.

I want to report the Payments and Adjustments without grouping by department, but report the charges grouped by department.

Is there a way to create a report that groups conditionally?

 

[lbass]

Let's say you have a group on PatientID. Instead of inserting a group on department, you could insert a crosstab in the patient group header or footer that uses department as the row and charges as the summary. If you want to, you can eliminate the grid by going to the customize style tab within the crosstab expert->format grid lines->uncheck "show grid".

Insert summaries on payments and adjustments to get those results per patient.

-LB

 

[mholbert]

I don't that would work because I don't need the kind of summary across rows that a crosstab provides. It would be much easier if there were a way to group the data conditionally. Something like 'if type = 'a' or 'b', then don't group, if type = 'c' group.

Thoughts?

MH

 

[synapsevampire]

You pretty much wrote it, create a formula to use as ythe group field of:

If {table.field} in ["a", "b"] then
""
else
{table.department}

Now those that re not A or B will br grouped by department, the a/b will be within theor own grouping.

-k