HI, Thanks for your replies.

There shouldn't be any Null values.

At the bottom of this post - it shows two result sets - one using the code to generate you data...

Sorry - It won't let me do this -

To create the table -

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[co_audit_trail2](

[user_name] [varchar](60) NULL,

[date_of_change] [datetime] NULL,

[time_of_change] [varchar](16) NULL,

[bi] [varchar](8000)...

Worked a treat -

Ended up with the following code -

selectp.Item AS 'PlaceReferance'

,PL.address##1 AS 'AddressLine1'

,PL.address##2 AS 'AddressLine2'

,CASE WHEN bi.ItemNumber = '5' THEN 'LocationType'

WHEN...

You beauty - this will work a treat - off to play now 🙂

Totally appreciate that guys - so frustrating that a massive company still manage to write useless databases.

Hi Guys,

All sorts of shit in that column - grrrrr.

Examples - 1700, 8-00 ,9.30AM

No change of converting all of that.

The issue looks to be the with dia.entry_time column.

In the database that I'm working on - it's set to varchar instead of a time. I can't change it at database...

If I use TEST1 I get the error in my original post.

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

Msg 242, Level...

Perfect. Worked a treat

But how do I include that in the expression below?

,CASE WHEN com.completion_date IS NOT NULL AND dim.DayName <> 'Saturday'

THEN DATEDIFF(d, com.current_task_target_date,com.completion_date) - non1.NoWorkDays

WHEN com.completion_date IS NOT NULL AND dim.DayName...

Cheers everyone.

Hi,

Ok so an update.

I've managed to do this using extra datasets.

So I have a Summary report and a Detailed report.

On the detailed report I have created a parameter...

I already tried that and it still doesn't work?

Really bugging me.

How would you get the stored procedure to look at the dataset in SSRS though?

I don't want to get in the habit of creating a dataset in SSRS but then create a separate view/s.procedure that I attach to Excel, as that's two places I...