Donny Z (8/19/2013)

---

Can...

//Ravi (3/23/2012)

---

We are running Google Analytics on our front facing customer website. I am building out some dashboards in the company.

users want to display number of hits on the...

Maggie, I'm not sure whether you want your start date to be today or one...

Thanks to Koen, Pete and Gazareth -- it turns out that it was parameter sniffing causing the problem.

---

As Paul Harvey used to say, here's the rest of the story:

SSRS report...

What does a shared data source have to do with this? This shouldn't limit you from putting the reports in separate...

Ahhh-- I see.

Thanks,

Rob

ChrisM@Work (8/19/2013)

---

robert.gerald.taylor (8/19/2013)

---

You're doing a lot in you If/else, couldn't you do something like:

SET @start = COALESCE(@startdate, DATEADD(yy, -1, @endDate), GETDATE());

SET @end = COALESCE(@enddate, DATEADD(yy, 1, @startdate), DATEADD(yy, 1, GETDATE()));

Seems...

Can't you just right click on the tablix and add the row; and then right click on the row and say add column (to left or right)?

I must be missing...

You're doing a lot in you If/else, couldn't you do something like:

SET @start = COALESCE(@startdate, DATEADD(yy, -1, @endDate), GETDATE());

SET @end = COALESCE(@enddate, DATEADD(yy, 1, @startdate), DATEADD(yy, 1, GETDATE()));

Seems cleaner this...

Can you login as that agent account and then try running the package in BIDs? It may shed some light on what permissions issue it is running up against.

HTH,

Rob

I think you're on the right track. See if the flat file exists; if so, load flat file to a staging table. Verify that what's in the staging...

In my SSMS, I have the SET ARITHABORT checked to on in Tools,Options. I'm not...

Pete,

Thanks for your feedback.

peterzeke (8/14/2013)

---

1) Did you actually modify the query to handle parameter sniffing? From my own experience, I've had situations where parameter sniffing was the problem -- modifying...

jbalbo (8/13/2013)

---

Does anyone know how to deploy a report if I wanted to create another folder (sub folder) on the web interface for users to pick reports?

I have my main...

We ended up changing the SharePoint "Manage Processing Options" setting to allow the report to run an unlimited time. This didn't speed anything up, but it did stop the...