views:

23

answers:

1

hi,

am doing a report for showing catogory-sub-category wise sales report.

i made to group headers with category and sub-category

What i want to do is.. Hide subcategory(Group-Header) --> if user didn't specify or select any subcategory.

..??

+2  A: 

To do this, you need to conditionally suppress your group header based on the value of the parameter. To do this:

  1. Select the Section Expert... option from the Report menu.
  2. Select the subcategory Group Header section in the Section Exprt dialog.
  3. Click on the formula button for the Suppress (No Drill-Down) option.
  4. Enter the formula IsNull ({?subcategory}) and click Save and close.
  5. Click OK at the bottom of the Section Expert dialog.
Mark Bannister