debschultz
asked on
SQL 2008 Reporting Services
I have a report that is grouped by a vendor code. I then have the trailer number in the header for grouping and a couple of totals. One of them shows a time in and because it is located in the group header it shows only the first time in, I wanted this to happen for each trailer number. In the details I have a formula where I take the time out and subtract it from the first(time in) and that works for the first grouping. I want it to pick up the time in for the next group instead it is using the first one of the whole table in stead by each group. How can I set that up?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
this seems related to Q_28175022 and I still recommend use of row_number() to assist in this; see ID: 39298948
The very best way to move this (and the other Q) forward quickly and accurately would be to provide the table definitions and some sample data from each. Also provide expected results and if you have an existing query also supply that.
although this may sound like wanting too much - truly, quality answers are most quickly provided by sample data and expected results.