BWFC (10/4/2016)

---

You're welcome, I'm happy to help. Do you understand what it does?

As a disclaimer, I've only Googled using a CTE in an SSRS dataset rather than actually doing...

BWFC....................

You the man, your script worked great, I then (being a noob to sql), sussed out the statements and replaced the temp tables with my real-ones where you commented and...

Thanks Jasona, that worked as well.

All sorted, thanks again to everyone involved.

Thanks Lowell, that worked.

I didn't need to add the userid or password, I just added the path to the file like u said and scheduled it.

tested and works great.

Thanks...

Already tried using the -U and -P switches (just to try it) and even that doesn't work either

Hi,

As mentioned, don't have Server Agent, using SQL Express

I know how to keep headers on the page, it's the list I'm talking about.

anyone?

Managed to get the width to adjust using this exp:

=(1 + DateDiff("d",Parameters!StartDate.Value, Parameters!EndDate.Value) / 2) & " in"

However I don't like it because the column bars also grow in size...

I tried creating a New Dataset and pasting the query in, same issue.

Its complaining about those fields...

The Query now works in Query Designer, but getting lots of errors in Reporting Services on Design tab when doing report:

Warning1[rsMissingFieldInDataSet] The dataset ‘Logon_Duration_and_Bookings’ contains a definition for the Field...

Managed to get the linked server created and it appears as a linked sever in SSMS.

So can anyone help (using my code) show me how to connect to the linked...

Koen Verbeeck (10/2/2015)

---

The problem is, you can only reference one dataset in an object.

In other words, you can only link a chart or tablix to one single dataset.

The straightforward solution...

J,

Not sure the PMs are working, did you get the code I just sent u?

Hi J,

I work in a new out reach team, there is nobody else that has SQL in the team.

If there was someone, I wouldn't have had the need to post...