How can I create a counter (line#) by group were it resets = 1 whenever a new group starts.
Customer Line#
A 1
A 2
A 3
B 1
C 1
C 2
Hello,
Try putting this in your detail row:
=RowNumber("GROUPNAME")
Get the GROUPNAME by right-clicking on your group header row and select "Edit Group...". Copy the Name and place it in the RowNumber function.
Hope this helps.
Jarret
|||This works as specified but it does not solve my real problem.
I have a query - customer master joined to ship-to's.
I am trying to use the RowNumber expression with a Parameter "Show Ship-To's" - Y/N
If Show = N and RowNumber <> 1 then I do not want lines 2 - X to show.
This works. However, it treats the display as if all the lines are there. Page 1 might show only 3 accounts, Page2 might show
10 accounts, Page 3 shows 5 accounts, etc, etc
Using a Parameter how can I tell it to include all the lines or just the 1st line of each group of customer#'s. If Ship-To = N
then each page should have 50 Master accounts with no ship-to data.
Account Ship-to
A
B
C
D
E
F
...
or
A 1
2
3
B 1
2
C 1
It's almost as if I need to condition the query to get the data from Customer Master or Customer Master joined to Ship-To
based on the Parameter "Ship-To" (value = Y/N). That way, the correct data is there before it ever trys to format the report.
Detailed explinations/examples needed as I have no knowledge of VB and Reporting Services other than what I can get out of a book.
