sql reporting services

• craig 84462

  Say Hey Kid

  Points: 669

  More actions

  April 28, 2010 at 4:04 pm

  #220091

  hi there,

  I want to design 1 report containing the 3 below queries with 2 columns, do I need to do them as separate reports to start with?

  1) select 'x' as tablename, count(0) from table1

  2) select 'y' as tablename, count(0) from table2

  3)select 'z' as tablename, count(0) from table3

  Do i need an append query here?

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  April 28, 2010 at 11:50 pm

  #1159435

  You can do it one report

  Create three dataset and map that with respective Tables on Report Page or map that with sub report

  [font="Verdana"]--www.sqlvillage.com[/size][/font]