asked on

Conditional Group in Crystal Reports

Hi

I'm trying to design a payments report. What I would like to have is the user to be able to do the following...

when the report is run, initially he/she will see a summary for payment types for each day.

clicking on a payment method, will list the individual payments on that day forthat payment method, however if they choose Withdrawals I would like to show them a summary of INITIATED and COMPLETED and then drilling down a list of individual withdrawals.

What I want to know is how you add a conditional extra group such as the one I described above.

Joe

Spykair

Joe,

You can insert the group and do a conditional suppress on it -> Right click on the group header -> Section Expert -> Click on the "X+2" next to SUPPRESS -> Enter a formula like: Paymethod <> 'Withdrawals'

Hth,
Spykair

joe1976

ASKER

Hi

Thanks for the quick reply

I just tried inserting the group and in the section expert added GroupName (paymethod) <> 'Withdrawl' under Supress (No Drill down)

but when i run the report and I drill down on any other paymethod e.g Credit Card, Paypal..it doesnt let me drill into the details section. It works fine on Withdrawals I can drill down to the details section.

anyone know of a way around this?

Joe

Spykair

Try:
If Paymothed = 'Withdrawal'
then false
else true

Spykair

joe1976

ASKER

Hi

I tried that but it didnt work. Any other ideas? I'm starting to think that it mightnt be possible. :-(

Joe

ASKER CERTIFIED SOLUTION

frodoman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial