i dont think this is possible as the number of transaction i have per line will vary depending on the number of transactions an individual will have in the period...

You can do this in your core SQL by add a new field to your Sql

Case when Payment_To ="CSL" THEN PayAm END AS Payment_To_Value_CSL

Then just sum the field on your...

Thanks naresh.talla,

i created a seperate Maintenance Plan task to just Clean up the History and this seems to work.

Don't know why the other one does not work as it was...

Both the Job History and Maintenance Plan History is reporting success with no errors

Thanks for the response i found an icon on the toolbar that allows me to turn it off.

Yes it is 'the worst' feature as some of us who use computers...

Fiona,

Apologies i should have replied to this when i found the answer. Here is some more detail on what you have found. The following example covers on Clicking on...

Thanks for the repsonse.

The Access database is password protected and i can't seem to create a linked Server for it

(i can create a linked server no problems for an...

I found this article from Microsoft

http://msdn.microsoft.com/en-us/library/ms159219.aspx

which suggests that this is not possible.

Your Sql changes to

SELECT DISTINCT TERM_TYPE, TERM_TYPE as Terminal

FROM TankerPacific_Final_Reporting_View

UNION

SELECT NULL AS TERM_TYPE, 'All Terminal Types' as Terminal

Union

SELECT 'No Value' AS TERM_TYPE, 'No Value' as Terminal

and

SELECT TankerPacific_Final_Reporting_View.*

FROM TankerPacific_Final_Reporting_View

WHERE (ISNULL(TERM_TYPE,...

You will have to convert the Nulls to something else

ISNULL(TBL.FIELD.VALUE,'No Value')

Eg

where ((@Department_id is null) or (ISNULL(Department_id, 'No Value') = @Department_id))

Please note the difference between setting ...

i have achieved this on many different Servers. Below is an example of a Data Driven Subscription to a FileShare. (Note the syntax)

It is a bit fiddly, but...

You will need to create a Data driven subscription that checks whether your event has occurred. If you read up on this it should show you how to achieve this

As far as i am aware, this is not possible if there is no data for any of your rows for a one of your column groups

There are two options

Option...

You will need to use the UNC Path to the folder you are trying to write to with the appropriate permissions.

Eg if they are writing to a fileshare on a...

This warning message simple means that you have two controls on your report which overlap and that if you export the report to say PDF all the data does not...