Total Row count in RDL

• jeganbenitto.francis

  SSC Eights!

  Points: 956

  More actions

  February 14, 2013 at 4:43 am

  #289456

  Hi All,

  I have a table named tbl which contains 250 rows

  I have a Varaible @CNT = SELECT count(*) from tbl

  Then i have a query as Select top 10 * from tbl

  Now i want to pass @CNT into second query.

  The output of Select top 10 * from tbl will be

  1 val1

  2 val2

  . .

  . .

  . .

  10 val 10

  But i want as

  1 val1 250

  2 val2 250

  . .

  . .

  . .

  10 val 10 250

  250 indicates the value of @CNT.

  Or is there any other way in which i can pass @CNT as a seperate field in SQL Server Reporitng Services RDL

  Thanks in advance