Post reply

Making the fixed table layout with multiple data rows supplied

  • July 4, 2016 at 8:25 pm

    #400353

    Hi,

    I would like to get some ideas and work-arounds for particular designing issue in SSRS.

    My problem is that I want to add in empty row/s below the tablix to make it have the same tablix layout in every page.

    I have a group and two totals(subtotal and grand total) inside the tablix. (So, there are 3 data rows: 1st is the data for item, 2nd the subtotal and 3rd the grand total.

    For an instance, the tablix can accommodate 8 rows per page, but the data rows are only 6 rows, and so I want to add 2 empty rows below to fill up.

    How can I achieve it?

    P.S I can only do it in report level.

    Thanks,

  • July 5, 2016 at 3:06 am

    #1888395

    Can you share prototype for this report layout?

  • July 5, 2016 at 3:13 am

    #1888397

  • July 5, 2016 at 9:48 am

    #1888500

    What happens if your data has more than 8 rows, is that ok?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 5, 2016 at 10:01 am

    #1888504

    What kind of grouping have you got? Are you splitting the groups (if any) onto separate pages?

    Depending on how your report is configured, this might work...Add 8 blank rows outside your group - for the first blank row, in its properties, go to 'visibility'. In the expression, type:

    =IIF(COUNTROWS < 1,TRUE,FALSE)

    The next, =IIF(COUNTROWS < 2,TRUE,FALSE)

    And so on until you have one testing for countrows < 8.

    This expression will count the number of rows, and only show the blank row if the count is below a certain number. So if you only have 6 rows in your data, the seventh and eigth expressions will equal "true", and display blank rows.

    Hope that makes sense...end of a long day 🙂

    LinkedIn

  • July 6, 2016 at 8:05 pm

    #1888832

    Hello tindong,

    Thanks for your response, but I am getting error when running,

    COUNTROWS is not declared . It may be due to its protection level.

    By the way can I clarify two things?

    Are you suggesting me to use Custom coding? Or else you are just referring =IIF(COUNTRIES <1,TRUE,FALSE) to put in row visibility setting?

    For the former one, TBH, I am not sure about writing custom code. For the latter one, are you trying to refer =IIF(COUNTROWS( )<1,TRUE,FALSE) indeed? What I understand is for that one is, the bracket () referring the grouping, and it is referring the outer group in that case. But I have more than one grouping, in my case. And moreover I have subtotal and grand total row. So, in designer view, I am having three data rows( the data for the item, the subtotal and grand total) . That is why I can’t really achieve through this.

    For further reference:http://stackoverflow.com/questions/36642141/ssrs-fixed-tablix-add-blank-rows-below"> http://stackoverflow.com/questions/36642141/ssrs-fixed-tablix-add-blank-rows-below

  • July 6, 2016 at 8:16 pm

    #1888834

    * sorry I mean embedded coding( custom coding)

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

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