It's version 11.

Here's some additional info I've found:

- I run into this problem logged in as anyone (even administrator) while I'm on the browser on the actual SQL Server.

- I...

I did look at the ExecutionLog3 view and it shows a Status of rsSuccess, along with stats for TimeProcessing, TimeRendering, etc. (I've never used this view before, so I'm just...

Thank you so much.

I went back into the Select statement and cast the Tripdate value as smalldatetime and refreshed the fields in the Dataset. That finally did the trick.

Thank...

Anyone out there with any suggestions about this? Am really needing an answer to the issue and haven't gotten any alternatives that suffice. Getting rather desperate.

Are there any security...

Those are indeed the names of the columns. Why would it be trying to convert it to an INT? (It can't be an INT since it has the...

Thank you, cnporteous!

Good idea on the Execution Log table. I might try that out. Data Driven subscriptions are somewhat of a mystery to me, despite having identified a...

Hey thanks for all the replies. Everyone's been very helpful.

On the CTEs, I apparently hadn't done enough homework. The semi at the start is how I've always seen them....

I think I got it! (at least I'm cautiously optimistic)

Does this look about right to you?

CREATE TABLE #Schedules_RC(

[Route] VARCHAR(15),

Start_Time VARCHAR(10),

End_Time VARCHAR(10)

)

INSERT INTO #Schedules_RC VALUES ('600','0410','2330')

INSERT INTO #Schedules_RC VALUES ('801R','0815','1825')

INSERT INTO...

You made the pivot into another cte and then did a select * to get the details and added the aggregates to the original dataset with a union. Last...

A quick and easy way to get grand totals of the columns is to dump all of the pivot results into a temp table and just sum each column to...

I can see value in getting both the sum per route and sum for each 15 min period. So it would be adding a grand total row (summing total...

Let's see.

For one thing, I've been trying to see how to modify the code to get a second dataset that totals (sums) each one of the time-increment columns and each...

...very cool....

I have plenty to read up on now. 😀 I'll absorb and may come back with more....

Stay tuned.

Well I'm more than happy to gush in copious amounts about how everyone has been so incredibly helpful and knowledgeable. This has gone way above and beyond my expectations....

I think so. It's taking the varchars and converting them to smalldatetime. Although, I'm not clear on why its converting the route# to .1?