Thanks guys, I also got the call on the drive home after a night out 🙂

We recently had a developer write code for a complex report (took a few days...

Thanks Jack I will give that a try.

Phil.

Thanks that worked a treat.

Kind Regards,

Phil.

I was advised by a developer to use:

Public Function getHeaderText(ByVal purchaseOrderId As String) As String

Select Case Left(purchaseOrderId, 3)

...

Can anyone with me a lesson in adding custom code for such a scenario?

Thanks,

Phil.

Thanks Niraj. When executed returns error:

[rsMultiReportItemsInPageSectionExpression] The Value expression for the textbox ‘textbox37’ refers to more than one report item. An expression in a page header or footer can...

I worked out what the issue was. When I scheduled the task it created a job. I was unaware of this and was reviewing sql jobs. I noted 2 jobs...

Steps taken:

--From Principal

ALTER DATABASE DBName SET PARTNER OFF

--Set Recovery Mode for Principal

ALTER DATABASE DBName SET RECOVERY FULL

--Backup the Principal Database + Transaction Log copy over to Mirror Server C:\Mirror

--Then...

OK all is now happy and well.

I ran ALTER DATABASE DBName SET PARTNER OFF on the mirror.

I then ran SET PARTNER

I will do it all again so all is...

Hi. I dropped the mirror database. I then restored the database + log using NORECOVERY.

Now when I try to configure mirroring I receive:

Neither the partner nor the witness server instance...

I seem unable to do anything with the database on the mirror. Can I stop restoring?

Need to get this resolved ASAP......little beads of sweat appearing which is never good!

Thanks,

Phil.

Thanks I will take a look.

Phil.

I created a stored proc with the intention of allowing a user to run a report passing the stored proc the ReportId.

What I hoped was to be able to do...

Perfect, I played about with DATEDIFF.......

Many Thanks,

Phil.

Tried:

SELECT ReportSchedule.ReportID, CONVERT(CHAR(5),ExecutionLog.TimeStart,114) AS 'TimeStart', CONVERT(CHAR(5),ExecutionLog.TimeEnd,114) AS 'TimeEnd',

CONVERT(CHAR(5),TimeStart - TimeEnd,114) AS TimeTaken

FROM ReportSchedule INNER JOIN

...