Post reply

Row visibility conundrum

  • December 17, 2013 at 8:05 am

    #286170

    Hi

    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

    Region

    Customer

    Invoice

    PartNum

    Columns are

    FiscalYear

    Aggregates are

    SalesDollars

    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?

    Thank you

    Tom D

  • December 18, 2013 at 1:11 am

    #1674302

    So you have a Table instead a Matrix. It's Right? can you attach a Desgin view of your Report?

  • December 18, 2013 at 7:22 am

    #1674422

    rather than use the Hidden property, you could pass the fiscal year to the subreport and filter your data there instead.

  • December 18, 2013 at 11:24 am

    #1674538

    Hi

    It is a matrix

    I guess to re-phrase the issue ... when I click on customer to drill down and see the invoices I would only like to display invoices from a single fiscal year (column) ... and have just blanks in the other 5 or 6 fiscal years (columns) which may be visible

    My rationale is that for a sales report the relevant invoices to look at are in the current fiscal year and not the previous years

    Does this make sense?

    Thanks for looking

    Tom

  • December 19, 2013 at 2:45 am

    #1674744

    Look at my attachment. It's a zip with a sql script and a Report Project.

    It's not a Virus 🙂

    In Report1 you can find something like what you need.

    Let me Know if it works.

  • December 20, 2013 at 8:51 am

    #1675185

    Thank you VERY VERY much!!! I will take study it this weekend!

    I hope that you have a wonderful Christmas!

    Tom D

  • December 20, 2013 at 9:31 am

    #1675207

    Hope that it' works.

    Merry Christmas to you 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply