CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    4

    Parameter to Hide/show Details?

    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

  2. #2
    Join Date
    Dec 2007
    Posts
    13

    Re: Parameter to Hide/show Details?

    In the report design, right click the details section in the left column and chose Hide ( Drill-Down OK ) .

  3. #3
    Join Date
    Mar 2008
    Posts
    3

    Re: Parameter to Hide/show Details?

    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

  4. #4
    Join Date
    Nov 2007
    Posts
    4

    Re: Parameter to Hide/show Details?

    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
    [email protected]

  5. #5
    Join Date
    May 2006
    Posts
    324

    Re: Parameter to Hide/show Details?

    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})

  6. #6
    Join Date
    Nov 2007
    Posts
    4

    Re: Parameter to Hide/show Details?

    Jagan- it worked perfectly. Thanks for the tip!

    jake

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured