March 25, 2011 at 11:21 pm
I have a simple SSRS report that lists items using a main query that I filter using one parameter.
Can someone show me how to add a record count at the end of the report?
I can't seem to find a simple example. I tried the expression =Count(Fields!MyField.Value) but that gives me an error.
The data is displayed in a tablix.
Thanks.
March 28, 2011 at 9:22 am
What was the error?
March 28, 2011 at 6:54 pm
I'm not in front of my computer right now but the entire report did not want to render. I got a message saying along the lines that the report could not open. The entire report. Light gray text at the top of the page.
Anyways, I think I figured one thing out. The textbox that displays the record count has to be part of the tablix, which is what I misunderstood. I thought I could simply drag a textbox and enter an expression. But when I entered the record count expression on the last line of the tablix, it worked. But I'm windering if that's the only way to get a record count.
I guess I have a lot to learn still about SSRS. I'm new to it.
I come from MS Access report development.
March 29, 2011 at 7:10 am
If you do not want it in the tablix, you probably have to add a scope to the expression.
=COUNT(FieldtoCount, "scope") where scope would probably be either the tablix name or the dataset name.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply