Report View

[rajasan77]

I have a report that needs to be displayed in 3 different ways based on the parameter.

I have a parameter called Report view, that will have
1. Summary
2.Summary with details
3.Summary with Drill Down.

If I Choose Summary, it should display on the groupings and the detail section should be supressed.

If I choose Summary with detail, nothing is suppressed and both groups and details should be displayed.

If I Choose Summary with Drill Down, It should display the grouping, when I click the grouping the corresponding detail should be displayed(like hide drill down ok).

I know the first two options can be done just by supressing details section when "Report View = "Summary".

Can anyone tell me how to achieve the 3rd option?

Thanks.

 

[lbass]

You can use the drilldowngrouplevel function in the section suppression area.

{?Report Level} = "Summary" or
(
{?Report Level} = "Summary with Drilldown" and
drilldowngrouplevel = 0
)

-LB

 

[rajasan77]

Hi LB,

This is not working as I expected. If I have your formula in suppress area of detail, it is still showing the detail section when i choose "Summary with drill down" option.

When I choose "Summary with Drill Down" option, then I should only see the groupings in the preview, Only If I click then the details should be shown.

If I check the Hide(Drill down OK) check box, then the summary is always hided even for "summary with details" option.

Can you please be more detailed?

Thanks,

 

[lbass]

Make sure you spell it in the pick list the same way you spell it in the formula--make sure the case matches, also. In my formula, I wrote drilldown as one word--and you didn't.

-LB

 

[rajasan77]

There you go...It worked now.

I have another question though ,

How would i get the page headers that has the header information for the details while i do the drill down.("Summary with drill Down")

 

[lbass]

Go to file->report options and make sure "show group headers on drilldown" is checked--This will actually show all headers, not just group headers.

-LB

 

[rajasan77]

Thank you so much LB