Drew:

I think I have most of the problem solved especially the end period - I just need to change from Hour 3 to Hour 2 with 59 minutes....

Drew:

Thanks for the reply. This will be a report run daily and needs to include the Week To Date tons for the period from Sunday 3AM to the...

I tried your expression but it did not work. I was able to discover a Format_Code field and added that column to the report along with the expression of: =IIF(Fields!Format_Code.Value...

I have the report now sorting the accounts in the correct order that the users want. Now my problem is getting SSRS to be able to incorporate the correct financial...

Randy:

This is great! This is about 90% of what I need.

I have 2 questions.

Your code generated the following:

DateReleasedTotalCarsByDatesosb_SP_DescriptionTotal_NetTons

12/20/2013 12 ...

Randy:

This is close but not quite. I need to show total cars/loads by day per location and then total cars/loads per location. See bold items below.

Example:

Location...

One table showing details and the counts/sums/subtotals would be fine.

We add html coding to the SQL script so the script output (report) can be displayed in a web browser....

Randy:

For my purposes now I just need to generate the results in the standard MS 2005 Management Studio grid. I just need to show the detail data and then the...

Yes, I am still interested in solving this problem.