Show a minimun number of rows

[Jon]

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, 

[Hinata]

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.