sql server reporting services: Counting Group fields -- sql server reporting services

You're in the

sql server reporting services

group:

Counting Group fields

Re: Counting Group fields

Thomo
5/8/2006 8:26:56 AM

sql server reporting services:

I think you can specify a scope for the count method ie
=count(Fields!UserID.Value, "GroupName")

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_9bp0.asp

Counting Group fields

Jackson
5/8/2006 10:38:52 AM

Is there a way I can count the number of grouped items in a textbox in a
report?

When I try to use =count(Fields!UserID.Value), the report gives me the
amount of records in the query.

I also tried using count distinct but that returned the same results.

Is there anyway I can just count the grouped listings? Or maybe count the
number of table rows?

TIA,

Jackson

Re: Counting Group fields

dba56
5/8/2006 12:15:25 PM

Those sound like legit group names. You can find group names by right
clicking on the beginning of a group row and selecting edit group from
the context menu. The name will be on the top portion of the general
tab of the Grouping and Sorting Properties window. The names work fine
as the scope argument for the count statement, making sure that the
group name is in double quotes since it needs to be a string argument.
You didn't say what kind of error you're getting, but maybe its the
placement of your aggregate field. Try putting it in the group footer,
for example, and see if it works.

Re: Counting Group fields

Jackson
5/8/2006 2:27:14 PM

Thanks Thomo,

Where would I be able to find the group name? The only group names I've
found is called table1_UserID and table1_details_group but they don't seem
to work.

Thanks again for the help,

Jackson

[quoted text, click to view]

Re: Counting Group fields

Jackson
5/8/2006 3:59:45 PM

Putting it into the group footer worked. I was trying it in the Page
footer. But the problem is that when I do a count it counts all of the
records.
I just want to include a count of how many Users are included in the report.

In my report I have UserID's grouped and within the group is the details of
their previous transactions. And for some reason it's counting the records
instead of just the groups.

Any suggestions?

Thanks again,

Jackson

[quoted text, click to view]

Re: Counting Group fields

Jackson
5/8/2006 4:05:56 PM

doh, nevermind. I took a look at the link that Thomo had sent and I tried
using countdistinct again in the footer and it worked.

I could have sworn I tried countdistinct and it came out different.

Oh well thanks for all of the help.

Jackson
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn