COUNT OF ROWS

Question

Hi ,

I want to find count of rows of a particular data set in a table expression. How to do that? Can you please help me out.

Thanks

susheel

---

sush

Answer 1

http://technet.microsoft.com/en-us/library/ms156330(v=sql.100).aspx

Answer 2

Hi Murali,

Thanks for the reply. Tried it. But its not working.

---

sush

Answer 3

=Count(1,"ScopeName") or =Count(1)

This is a generic representation. What you count is unimportant. The scope in which you count is everything. The formula you use determines how you use it. Since the first one sets the scope for the count, it can be used pretty much anywhere. The second one is context-driven. Whatever the scope of the containing control determines the scope of the expression. For instance, if I use it in a cell that is under a group for Category, it will show the count of records in each category.

In the first, for a count of records in the dataset, substitute the dataset name for "ScopeName" (need quotes around the dataset name). You can do the same for any valid scope, such as a group name.

---

"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.

Answer 4

If you want the total count/number of rows in a dataset, use CountRows("Dataset1").

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 5

CountRows("Datasetname")

will give your count of rows in dataset (total rows)

If you want count of values in a particulat field in dataset use

COUNT(Fields!FieldName.value,"dataset")

this wil give you count of values in the field after ignoring null values

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 6

Hi Visakh,

I used countrows. If the dataset set contains 12 rows I am getting the o/p as shown below. I just need one row. Can please help me out.

Thanks

---

sush

Answer 7

Hi Dimant,

I used countrows. If the dataset set contains 12 rows I am getting the o/p as shown below. I just need one row. Can please help me out.

Thanks

---

sush

Answer 8

So you are not using text box? I tried and I'm getting same result if using tabular.. 

Answer 9

susheel.. I found it :) In the row group delete the details grouping.. or default grouping.. then you can achieve what you wanted.