Link to home
Start Free TrialLog in
Avatar of debschultz
debschultzFlag for United States of America

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?
Avatar of PortletPaul
PortletPaul
Flag of Australia image

To achieve what you are after will require use of SQL as I don't believe you will achieve it just through SSRS alone.

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.
ASKER CERTIFIED SOLUTION
Avatar of PortletPaul
PortletPaul
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial