Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show Suppressed detail on drill down

Status
Not open for further replies.
Jul 28, 2011
167
NG
Hi all,
I'm using crystal reports in VS2008.
I grouped the report based on a field (department field). I also want to show two formats of the report. A summarized version (Showing only the group headings and group totals) and a detailed version showing the details as well as the group headers.

I successfully showed the two by putting a boolean parameter (called "Show Detail Drilldown") then in the details section I put the parameter field.

The version where I show both details and groups together works well. However,in the summarized version, I cant drill down to the details.

I hope you all understand my question. Any help is appreciated

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.
 
Let's assume your parameter has three options:

Detail
Summary
Summary with Drilldown

You should not check "suppress" in the section expert for details, but instead use a formula in the x+2 area:

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

-LB
 
Well, after much toil I came up with this solution in the details "Section Expert"


if DrillDownGroupLevel=1 and {?Show Detail drilldown} = true then
false
else
{?Show Detail drilldown}


I hope this helps someone else
 
Thanks Lbass, However you probably did not get my question right. Well, I came up with the solution above

Thanks.
 
I didn't know your actual parameter options, but I believe mine would have worked if you had set it up that way.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top