I'm using SSRS Visual Studio 2005. This seems like it should be fairly simple, but I'm hung up and need some help.
The data in my SQL query is ungrouped because it's performing some calculations by detail row. Each customer could have several detail rows associated with them. When I output the results, I am grouping at the detail level and only displaying the customer name once and want to simply number the customer names sequentially.
I've tried using the detail level group name like:
=CountRows("table1_Details_Group") but that just outputs the number of rows associated with each customer.
Is there a simple way to just number the detail rows sequentially? Or perhaps I need to use some Code then call to it in the expression. I've hit a wall here and would very much appreciate any suggestions.
The data in my SQL query is ungrouped because it's performing some calculations by detail row. Each customer could have several detail rows associated with them. When I output the results, I am grouping at the detail level and only displaying the customer name once and want to simply number the customer names sequentially.
I've tried using the detail level group name like:
=CountRows("table1_Details_Group") but that just outputs the number of rows associated with each customer.
Is there a simple way to just number the detail rows sequentially? Or perhaps I need to use some Code then call to it in the expression. I've hit a wall here and would very much appreciate any suggestions.