Hi All

Just thought I would update you with a development. Whether its significant or not remains to be seen, but I went back to my class project and changed...

Wow that was a speedy response.

The 2 directories I'm deploying it to are

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

and

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

Is this correct, and is there anything else I...

Hi Adam

This is a fantastic article and just what I'm looking for to reduce the workload in creating many reports while ensuring a consistent look and feel. I've worked...

It was suggested on another forum that I do this in the select statement of the innermost query and it works perfect.

CAST(

CASE WHEN ISDATE(SUBSTRING(params, PATINDEX('%[ImportDate=%', params)+13, 19) ) = 1

THEN...

Hi

I've gone through and checked the dates and all are between 2007-06-30 and 2007-10-10 and appear to be in the correct format

THanks for the suggestion

Best regards

thats what I wondered, but when I do a select * from view where ISDATE(importdate) <> 1, it comes back with no records. Should this not catch anything outwith...

Here is an example of the source data

id,user_id, project_id, customer_id, company_id, action, params, notes,

32352, NULL, 12345, 23456, 1, Insert,

[ImportDate=Jun 30 2007 12:00AM][GroupID=1][AccountNo=ABC123][Amount=100.00], NULL,

Sorry, yes I've tried this and get the same message.

Susan

yes, I use cast in the innermost query then use datepart in the outer part to get the year and month. If I try to filter by the date,...