Click to See Complete Forum and Search --> : Parameter to Hide/show Details?
jake78kasjdflksdjfkl
February 27th, 2008, 12:09 PM
How can I make it so my user has the option to show details?
Can I do this with a parameter?
I have a standard report that hides the details and just shows the totals. My user wants to see the details sometimes.
I am using 8.5 and also have 11 if needed.
Thanks everyone
jake
Crystal Fire
March 3rd, 2008, 12:55 PM
In the report design, right click the details section in the left column and chose Hide ( Drill-Down OK ) .
caffinefree
March 4th, 2008, 12:10 PM
If I understand your question... you are looking for a way that a user (not famlier with Crystal) can select show details / show summary as one of the parameters, before they run or update/refresh the report.
If so...
This is how we handle 6 report types
Open a new parameter, give it a title (ie presentation)
Create a list of values and descriptions
G Grouping Totals
E Equipment Totals (w/equipment detail & group summary)
C Company Totals
R Report Totals
M Monthly Details
blank (for no grouping) --- (blank is used when the user wants to sort by department, or one of the other 7 sort types - another parameter field)
Set up your prompt text that tells the user what to do
ie. Prompt text: Selection for amount of detail to be displayed: (M)onthly details, (E)quipment Totals, (G)rouping Totals, (C)ompany Totals, (R)eport Totals
I set the "E" report as default - as 80% of the time that's the report they want
I leave discrete values = True, the other options leave as false
Then in the Section Expert
Select Details click the formula editor for suppress (no drill down) and we enter the 'fomula' {?Presentation} IN ['R','C','G','E'] the result is details show for the "M" and for "blank"
In the other sections we modify the 'formula' so footer 4 = {?Presentation} IN ['R','C','G'] this section shows for 'M', 'E', 'blank'
Same with header 4 = {?Presentation} IN ['R','C','G','E']
We also use a different report/group headers for each 'presentation' type - Group Headers/Footer 1 = {?Presentation} IN ['R']
GH/F 2 = 'C' etc.
Make sure you enter matching header/footer 'formula'
If I read your question correctly, hope that helps
jake78kasjdflksdjfkl
March 4th, 2008, 05:41 PM
Yes, Cafinefree, you are on to what I want to have happen.
I consider myself an average user when it comes to Crystal and am not sure what you mean by
"Make sure you enter matching header/footer 'formula'"
I am really only looking to have one of two options in my Presentation parameter. Show and dont show.
Thanks
jake
jbarritt@cmgmortgage.com
JaganEllis
March 4th, 2008, 09:53 PM
Create a boolean parameter, e.g. called Show.
In the section expert for the detail section, enter a condition in the Suppress formula (click the 'x-2' button alongside the Suppress option). Enter a condition such as
Not({?Show})
jake78kasjdflksdjfkl
March 13th, 2008, 05:26 PM
Jagan- it worked perfectly. Thanks for the tip!
jake
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.