nick947 (9/6/2013)

---

I have no idea why this worked, but it did. My execution time went from 15 minutes + to 15 seconds. I am not sure why but I am...

And you're positive you don't have any Nulls in those fields? (sorry if I'm asking the obvious)

Rob

Nick, here's a link explaining parameter sniffing and how to work around it:

http://www.databasejournal.com/features/mssql/article.php/3841271/T-SQL-Best-Practices-150-Parameter-Sniffing.htm

It is probably worth trying to change...

jaytuke (9/4/2013)

---

I occasionally develop multiple data sets from my data source in the process of developing reports in SSRS and then settle on the one best suited for my purposes....

Can you change what you're sorting by from a single field to an expression? Perhaps concatenate the region, state, ... and then sort by that expression.

Just a thought,

Rob

Are they really zeros or are they Nulls?

Try adding a check ( [font="Courier New"]IIF()[/font] ) to see if the value is Nothing, if so, explicitly make it zero.

Just a thought,

Rob

Can't you just right click on the textbox and choose textbox properties? Then in the Border area, just change the style to Dotted. Or alternatively, just select the...

Create a Kimball bus matrix to see where the separate star schemas have shared/conformed dimensions. Then the question becomes how is the data going to be used/analyzed? Will...

TomGuide (8/27/2013)

---

Hi Folks,

When i am trying to export my report into xls, i am having some issues as i am unable to save more than 65k rows of data and...

kk1173 (8/26/2013)

---

I have a SSRS data subscription that saves a file to windows share. The report runs monthly.

There is a new requirement now that after the file gets saved to...

manikandan.jv (8/24/2013)

---

Report developed in sql server 2008 . The report published in sql server 2012 report server,

it shows empty report. How i can fix...

Jack Corbett (8/22/2013)

---

I don't think there is anyway to control this within SSRS if you are using the Date control, I believe it is something controlled by the...

This is not a current capability of...

nick947 (8/21/2013)

---

I am having an issue with one of my reports. When I run the report in BIDS 2010 there are no problems, the report runs in a few seconds....

Donny Z (8/21/2013)

---

I know what QUOTENAME's function is.

What I mean is how Jeff apply it in the excel source, cause AFAIK we can't use every T-SQL function when we try...