dynamic rows count for the sql server report

Question

1.00/5 (2 votes)

See more:

i create a report in sql server reporting services in a tabular format .i set two parameters like to date and from date.if the values(parameter) changes number of rows in the report table will change.i want to display the row count in the report table .suggest me some solution.please

Posted 28-Jul-13 22:01pm

kalisiddayya

Updated 28-Jul-13 23:05pm

v2

Add a Solution

Comments

berrymaria 29-Jul-13 4:20am

Can you show some code? Or where are you stuck.

kalisiddayya 29-Jul-13 4:43am

i create a report.how to display the report rows count ?

kalisiddayya 29-Jul-13 4:47am

if parameter change my report will change.if the change occur then i want to count the number of rows in the report and display

Maciej Los 29-Jul-13 6:12am

What is SQL report?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Code-Hunt · Answer 1 · 2013-07-28T23:49:00

Solution 1

get-row-count-for-tables-quickly-in-sql-server/[^]

how-to-fetch-the-row-count-for-all-tables-in-a-sql-server-database[^]

group-number-in-group-footer[^]

1[^]

Check it's helpful or not...

Posted 28-Jul-13 23:49pm

Code-Hunt

Updated 28-Jul-13 23:51pm

v2

Comments

kalisiddayya 29-Jul-13 5:56am

sql report row count not the table count.

kalisiddayya · Answer 2 · 2013-07-29T01:09:00

Solution 2

i created a data set ,define some parameter and filter based on the parameter.CountRow will give the count of the records

Posted 29-Jul-13 1:09am

kalisiddayya