Viewing 15 posts - 1 through 15 (of 34 total)
I have answered my own question by using a SQLCMD variable and setting it appropriately in publish scripts.
March 21, 2013 at 5:18 am
I think I was wrong to say that just having a connection manager referencing a server that was down would throw an error. It seems that that is only...
October 27, 2011 at 6:56 am
I had that property set to 0 which is supposed to mean 'unlimited', I changed it to a really high number but same result.
October 26, 2011 at 9:42 am
Still I would need a connection manager with which to query the database state and if that server is down the connection manager will throw an error which will fail...
October 26, 2011 at 8:32 am
That's a good idea but I am connecting to multiple servers (and SSAS DBs).
Also, if I queried the sys.databases when the server was down then I would still get the...
October 26, 2011 at 8:02 am
Hi
Are you using data driven subscriptions to send the reports out? If so it is just a matter of applying a bit more logic to the query that produces...
June 16, 2011 at 1:55 am
If you want to see the parameter caption on the report (as opposed to its value) use =Parameter!State.Label.
August 6, 2010 at 1:52 am
This approach doesn't solve the specific problem that my function was written to address. When you have a parameter based on an SSAS dimension hierarchy the label usually contains...
March 31, 2010 at 3:53 am
You can actually take a string and turn it into a field reference like this:
=Fields("FieldName").Value
So you could use the value of a parameter like:
=Fields(Parameters!MyParameter.Value).Value
Ben
October 27, 2009 at 7:49 am
If the results are sorted properly when you run the MDX query in SSMS the issue must be in the report. It sounds like the values are being sorted...
September 4, 2009 at 3:19 am
Bob (2/4/2009)
As far as we've seen, the subscription parameters have to be hard coded. Expressions don't work there....
That is only regular subscriptions. With data driven subscriptions you can...
February 5, 2009 at 1:30 am
You don't need 2 reports you can have the parameter default values set for manual execution and then have the monthly subscription use different values which would be returned by...
February 4, 2009 at 3:22 pm
Your idea with the default dates seems perfectly acceptable to me but if you don't want to do it like that you could set up a data driven subscription.
You would...
February 4, 2009 at 2:51 am
Sure I appreciate that and I would be interested to hear from others who have faced this situation and their approach to it.
First thing to clarify is that in my...
February 3, 2009 at 5:59 am
Heh... on that note, I'm glad I do all this stuff in T-SQL. 😛
I agree in general that TSQL should be used to do all the work but in this...
February 3, 2009 at 2:47 am
Viewing 15 posts - 1 through 15 (of 34 total)