T2000 (6/5/2014)

---

had the same issue for our DEV team required extra Agent job access. This is how i got around it.

1 ActDir group. Hold all user accounts that need such...

Another wrinkle to this: It appears that the SQL Agent permissions allows the user to modify jobs owned by them, but not by others. In my situation, the...

It sounds like you need a column group.

Take a look at: http://msdn.microsoft.com/en-us/library/dd255263.aspx

HTH,

Rob

One idea: You could create a version of the report that contains both reports/tablixes and then the subscription would send out the combined report.

One downside is you now have an...

Mike Austin-398977 (3/3/2014)

---

All,

I have developed a cube that tracks the timeliness of certain steps in a business process. Steps are on time if the number of days between 2...

fhanlon (6/10/2005)

---

I have 2 odd user procs installed in the master database in 2 of my servers:

dbo.smDEX_Build_Locks

and dbo.smDEX_Max_Char

Anyone know what they are? My guess is they are left...

From BIDs (or SSDT if you're using 2012), go to File, Open, Analysis Services Database. This will open up a dialog box. Put in the server and OLAP...

Try putting that expression in the Visibility for that group. You want the IIF() to evaluate as either True or False (for visible or not).

HTH,

Rob

sharonsql2013 (2/26/2014)

---

I only want to see all the values in the column which are greater than 0. I don't want to put it in the where clause(Query) because there is...

+1 Agree 100%

Rob

RamSteve (2/11/2014)

---

Hi I have a Dataset In SSRS Report and I added Filters with my condiation as = @Variable .

I am getting the results as expected for my...

Is the performance issue in the report or the query? I'm guessing if you just pull the query out and run it in SSMS you'll see the majority of...

Is it always Shops 1 - 9? Could you use to tablixs on the report and limit the first to 1-6 and the second query to pull the last...

See if this helps: http://www.sql-server-helper.com/error-messages/msg-141.aspx

HTH,

Rob

Are you conditionally setting the cells background color? Something like:

=IIF(Fields!Amount.Value < 0, "Red", "Green")

You could use the same type of expression to set the value of your column 4.

HTH,

Rob