Total Row count in RDL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Total Row count in RDL

Total Row count in RDL

Rate Topic

Display Mode

Topic Options

Author

Message

jeganbenitto.francis

Posted Thursday, February 14, 2013 4:43 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 25, 2013 8:06 AM
Points: 16, Visits: 53

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 »

Permissions