Details section of table in SSRS should be fixed based on Dataset.

• venkatesh-MSBI

  Mr or Mrs. 500

  Points: 522

  More actions

  September 18, 2010 at 2:00 am

  #227019

  hi

  I have one query in SSRS. i have a report which should be in pdf format. in that i have a table which should have 5 details ( i mean lines).

  Here I have question, suppose if my dataset for the table is returing only 2 rows means, I need the report should be like first two rows should be with data and the remaining rows should be empty.

  As of now this is not happening, because of this my report alignment is changing.

  Ex:

  DataSet

  Eno ename

  1 A

  2 B

  Output should be in Table ( SSRS)

  EmployeeNo EmployeeName

  1 A

  2 B

  - -

  - -

  - -

  Suppose if my dataset is returning :

  0 roww means, remaining 4 rows should be with "-"

  1 row means, remaining 4 rows should be with "-"

  2 row means, remaining 3 rows should be with "-"

  3 row means, remaining 2 rows should be with "-"

  4 row means, remaining 1 rows should be with "-"

  If anyone knows the solution, please advise me.

  Thanks in Advance.

  Regards

  Prakash

• peace.cog

  SSC-Addicted

  Points: 493

  More actions

  September 23, 2010 at 10:02 am

  #1226434

  Hi,

  Is your balnk data "-" depends on any other column in the table? If so we can write some Iff conditions to display blank in that table.

• VinceV

  Right there with Babe

  Points: 791

  More actions

  September 24, 2010 at 12:25 pm

  #1227167

  Would your query always return 5 rows or less? If so, there are some tricks you can implement in the SQL itself that guarantees that 5 rows are always returned. Would it be possible for you to post a snippet of your query? What DBMS are you pulling from?