Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hiding detail column Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 4:36 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 5:44 AM
Points: 66, Visits: 437
Hi All,

I am struggling with a seemingly simple reporting issue in 2008, and was wondering if someone can help.

If I have a report with detail items which is either "apples" or "oranges", and a summary group which shows "Total Fruit", but I only want to show "Apples" in the detail section but hide "oranges", how do I go about doing this? I Still want to show the total in the summary group of all fruit..

I have change the visibility options to show or hide based on an expression, but that only apply to when it is Initially run.. I dont want the visibility of oranges to be toggled, I dont want it to be visible at all.

Am I missing something?

Thanks
Post #1516375
Posted Thursday, November 21, 2013 6:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 6,798, Visits: 6,272
Are "apples" and "oranges" rows or columns?
What do you mean by "but that only apply to when it is Initially run"

If they are rows then setting the row visibility expression should work, ie
=Fields!Item.Value="oranges"



Far away is close at hand in the images of elsewhere.

Anon.

Post #1516401
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse