First, Merry Christmas to everyone who reads this!
I am trying to create a SSRS 2012 Reportbuilder 3.0 sales reports with drill down
My Rows are
When I first open my report I would like to see just customers and then be able to drill down to invoices and then partnumbers for a selected invoice. This is simple and works fine
The twist is that when I drill down in a customer I only want to show invoices from the latest fiscal year.
I have a HIDDEN visibility expression for the invoices group (sort year is a parameter to pick out the year to show)
=Fields!FiscYr.Value <> Parameters!SortYear1.Value
The problem is that when I first run the report I see the customer row AND the invoices for the selected year and when I click on the customer drill down I then see invoices for all years..
I have experimented with various permutations in the visibility settings but nothing seems to work
Does anyone have any insight into this?