Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Total Row count in RDL Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 4:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:02 AM
Points: 29, Visits: 107
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
Post #1419978
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse