October 24, 2018 at 8:29 am
hi,
I have a report where i am creating a report and when we save report to excel , it saves the data to different tabs based on a column "category" values.
Example : category: Fruits , veggies , canned fruit .....something like this.
Fruits will be saved to sheet1 , cannedfruit to sheet 2. etc....( this might not be good example but just for understanding my issue).
So report consists of different columns A,B,C,D,E, Category. I am showing Columns A-E based on category . But my situation is ,
for category Fruits ( sheet1) , they want to show only A,B,C, E and not D.
I have written a expression on column visibility property (D) not to show if category='Fruits. But the issue is it is not showing that column on any of the tabs:(
( this expression is on column visibilty on Column D)
=IIF(Fields!Category.Value="Fruits",FALSE,TRUE)
How can i solve this ?
November 2, 2018 at 10:04 am
My guess is that somehow you are looking at all values for Category on each "sheet". Thus you would always have a single Category value of "Fruits". A quick way of determining this would be to filter out all instances of "Fruits" and then see if the visibility expression works. What you may need to do is create a column group or a specific filter group and then apply visibility expression.
I hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply