Eirikur Eiriksson (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you...

Two options:

1. Use a footer with conditional visibiltiy

2. Just put the textbox after your tablix. It should print at the end of the report.

I regularly pass many parameters to Stored Procedures in Execute SQL tasks or OLE tasks in the Data Flow. Adding two is just as easy as adding one

I think you'd be better off to either design the job in BIDS (SSDT in 2012) or build a Sql Agent job with the steps you want. You could...

I was able to get the desired output by adding a row to the sample data when the end date is outside the range in the sample data, like this:

;with...

Try your query on some test data rather than live data. Experiment with various lengths of input. It smells like and even/odd problem, but without real data to...

You don't have any constraints on the CustomerName column, so SQL doesn't know where to look specifically so it has to look everywhere.

Also, this is really fake partitioning. Have...

miles_lesperance (4/9/2014)

---

I am trying to modify an existing report to show 2 decimal places for a percentage, no matter what the value is. For example, if the calculation in the...

jeffhibbert (4/9/2014)

---

I have a problem for which I'm not sure there is a solution. I have a matrix with a group that has 3 possible values--call them type1, type2...

One thing you could do is define two datasets that share the same datasource -- one for "34" and one for "35". Then it's no problem adding the totals...

Well, if you run the report interactively and save it in Excel format, you're prompted for a location and filename. You can put in anything valid.

mcfarlandparkway (4/9/2014)

---

Hello,

I have an SSRS report where I am grouping the table with system Name

when I click on ALL in...

What formatting have you specified for the TextBox under the Number tab?

SSRS designer caches query results by default. So, if it has cached results, it won't rerun the query at all

mcfarlandparkway (4/8/2014)

---

Hello,

Here is my stored procedure;I am trying to use ReimbursementTypeID column in top select statement but its showing error...