[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 543
  • Last Modified:

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


0
joe1976
Asked:
joe1976
  • 2
  • 2
1 Solution
 
SpykairCommented:
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
0
 
joe1976Author Commented:
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
0
 
SpykairCommented:
Try:
If Paymothed = 'Withdrawal'
then false
else true

Spykair
0
 
joe1976Author Commented:
Hi

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

Joe
0
 
frodomanCommented:
I don't think you can do it directly but there may be a workaround that will work.  Instead of doing the conditional grouping on your main report, I would suggest using On Demand subreports to handle the detail displays.

Your main report would continue to show the top level summary by payment types.  I assume each payment type is already a group so you can add an On Demand subreport to your group header (or footer) that will display the detail information.  Set up your subreport to conditionally suppress the top level grouping (initiated / completed) similar to how Spykair suggested.

I believe that when the type isn't withdrawal, it should still work because you aren't actually drilling down but are instead doing an on demand report.  I haven't actually verified this, but in theory it'll work.

frodoman
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now