Solved

Conditional Group in Crystal Reports

Posted on 2006-07-12
5
509 Views
Last Modified: 2012-05-05
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
Comment
Question by:joe1976
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

by:Spykair
ID: 17089152
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
 

Author Comment

by:joe1976
ID: 17089308
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
 
LVL 10

Expert Comment

by:Spykair
ID: 17089375
Try:
If Paymothed = 'Withdrawal'
then false
else true

Spykair
0
 

Author Comment

by:joe1976
ID: 17089539
Hi

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

Joe
0
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 17093687
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now