SSRS: How to make two tables have the same number of row

• enestijr

  Grasshopper

  Points: 21

  More actions

  March 12, 2013 at 11:28 pm

  #275174

  hi experts

  I have the following

  dataset1(MDX) (always has more rows than dataset2)

  dataset2(MDX)

  tablix1(source is dataset1)

  tablix2(source is dataset2)

  what i need to accomplish is to have same number of rows for both tablix1 and tablix2

  for example: if the dataset1 gives 27 rows and dataset2 gives 14 rows, i wanted to have 27 rows for tablix1 and also 27 rows for tablix2(having 14 rows filled with the result set of dataset2 and 13 empty rows).

  is therer any way to add empty rows to a table ? ( I use SSRS 2008 )

  Thank you in advance.

  Nestor

• SatishChandra_SQL

  Old Hand

  Points: 316

  More actions

  March 14, 2013 at 2:01 am

  #1596863

  Hi Nestor,

  I am not sure of the actual requirement and costraints around your tables, but i think you can try .....

  Take the differnece of Table rows with help of a variable/function.

  Create a stored procedure and loop the empty insert ('') command as many times as variable.. where variable > 0.

  I think then you can have the equal number or rows in both the tables...

  Thanks

  - Satish