If you want some really good help, try providing some sample data that we can use and required output.

People will soon jump in to help.

How to post code problems

It sounds to me like your email may have an html body, in which case, replace the char(13), char(10) combination with a '< br / >' (remove the spaces) tag,...

I would probably have two reports, one for each dataset, then a master report which displays one or other of the reports as sub-reports, maybe...

Or have two detail lines whose...

briancampbellmcad (10/8/2013)

---

Actually this is a a SQL Server query embedded in a datasource on an asp.net page... not MySQL.... I removed the second WHERE and an error showed up:

Incorrect syntax...

That is to prevent errors in compilation if a table does not exist.

the report item containing the formula must exist within a section off the report that is bound / linked to a dataset

It is looking up the value in the SK column from the bound dataset to the "DS_StCount" dataset and if it does not return a value, it uses zero.

The lookup...

The only thing I would say now is, to tidy it up a bit, use a cross apply and some integer division to break up the buckets...

something like this:

select

...

I would grab the minutes since midnight instead of the "time as a string" myself.

DATEDIFF(minute,CAST(my_datetime_column as DATE),my_datetime_column)

Then it is simple integer division by 240 to get each 4 hour bucket

ok, if you are on 2008 R2, you can use the RenderFormat function to determine whether the subreport is visible be default, so if exporting to pdf for example, you...

Also, what version of SSRS specifically? This is in the 2008 section, but do you have R2?

Can you give some idea of the layout of the report and sub-report?

Love your forum name 🙂

That is one hell of a mess to be blunt!

I would start by getting rid of all those subqueries, and replace them with joins or even...

My advice would be not to use a trigger for this.

Change your stored procedure or your application to perform both inserts.

Here is some dynamic sql to generate some more dynamic sql to generate the required sql...:crazy:

select

'

select stuff(cast(list as varchar(max)),1,2,''select '') + '' from '+tablename+'''

from (

'+select1+'...