Show a minimun number of rows

2 posts, 0 answers
  1. Jon
    Jon avatar
    4 posts
    Member since:
    Mar 2013

    Posted 08 Oct 2014 Link to this post

    Hi, 

    I have a subreport where I need to draw 6 records in the detail section. Always 6 records, not more, not less. If there are no records, I need to draw  6 empty spaces. Or if I have 4 record, I need to draw 4 records and 2 empty spaces.

    I limit the maximun number of row to six by setting SELECT TOP 6...

    Is there any propperty or method in order to draw in the detail the minimun number of rows needed?

    Thanks in advance. Best regards, 
  2. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 13 Oct 2014 in reply to Jon Link to this post

    Hi Jon,

    The report is data-driven. This means the engine will create a instances of the detail section according to the number of rows in the data source. When there are less than 6 records, you will have to add empty records programmatically, so that you always have 6 records in total.
Back to Top