Interesting conumdrum.. question about filters...

Got a dataset coming from a stored procedure.

There is a parameter I must put on the report that filters the dataset.

the choices are "exclude" and "only", based on that I have to filter my dataset like

if they select exclude then I have to filter where "debitType <> 'Intercompany'"

if they select on;y then I have to filter where "debitType = 'Intercompany'"

Is this at all possible in the filter part?

It is easy as pie in Crystal record selector.

Hello,

Try this as your filter:

Expression: =cBool((Fields!debitType.Value <> "Intercompany" AND Parameters!Param1.Value = "Exclude") OR (Fields!debitType.Value = "Intercompany" AND Parameters!Param1.Value = "Only"))

Operator: =

Value: =cBool(True)

Hope this helps.

Jarret

|||

oh, that's good. didn't knwo you could use epxressions like that in the left side of the filter table.

Thanks alot.

Interactive Sort in Matrix

I have a Matrix in a report - created like below. Each row has a different dataset and I need to make each Column to be sortable so they can click on the column header say "Summary of Accounts" and sort them and do that for each column header. So far I havent seen anything that looks promising that can do this. Is there away this can be done?

6 Columns and 14 Rows

--headers

Summary of Accounts No debts origBal AccrInter PaidDate CurrBal

Activity count() Sum() Sum() First() Sum()

phase count() Sum() Sum() First() Sum()

attorney etc etc

collection

not inititated

resolved

interrupted

cancel

closed

revised

letter service

Totals:

The combination of Interactive Sort and Matrix are not good! I managed to get it working but only for row groups.|||I know they are not how about how did you do the row groups? If they can sort by row then fine that is good enough for me then!