Viewing 15 posts - 16 through 30 (of 102 total)
I think you should look into a DataDriven subscription.
Define the query that returns the email-adresses to send the report to in such way that no rows are returned when there...
November 3, 2010 at 8:10 am
I'm also curious for the reason to convert to char, as the following syntax will work just fine for me:
SELECT DATABASEPROPERTYEX('MyDatabase','collation')
It is very clear what answer should be picked on...
November 3, 2010 at 4:35 am
Nicely worked out solution, I liked some comments in your code a lot :w00t:
October 29, 2010 at 9:19 am
I'm afraid you would have to look at the windows regional setting to make that happen globally without touching the reports.
But changing the format in 40 reports shouldn't be that...
October 29, 2010 at 9:07 am
Can it be that the redirection only works when you make calls to reportmanager (http://server/reports), not when calling directly to the reportserver (http://server/reportserver?
Have you tested that?
From what I saw in...
October 29, 2010 at 8:48 am
Ah! Placeholders was the word I was looking for in my first reply.
Tnx for clarifying they are introduced in SSRS2008, not in R2.
October 29, 2010 at 8:23 am
it's probably not possible out-of-the-box, so you should look into building your own rendering extension for this, or maybe you can find a third-party rendering extension that suits your needs.
If...
October 29, 2010 at 7:41 am
it's been a while since I had to work with the reportbuilder etc, but if i recall correct you should also check some rights on the IIS directories etc. To...
October 29, 2010 at 7:06 am
I'm not quite sure about your approach, but there's a relative simple solution for your problem;
make sure that the sp always returns the same set of columns, returning NULL in...
October 29, 2010 at 6:39 am
From what I found here, I would say all links will be https after activation of ssl.
In a wrox book I found however that after ssl-activation all http requests will...
October 29, 2010 at 6:29 am
Can you create a subscription when you use the Report Manager web-frontend?
If that's not available as well, you might look into a couple of prerequisites for subscriptions:
- Is SQL Agent...
October 29, 2010 at 6:10 am
without experience with dundas, I can only give you how to solve that in SSRS itself.
Simply use SR # ##0.00 as format.
Maybe this works in Dundas as well, or...
October 29, 2010 at 6:03 am
Using the techniques above you could have a fixed-format textbox ("cell") per label, and have other objects (using a list for instance) in that "cell" in which you place the...
October 29, 2010 at 5:51 am
please refrain from hijacking old posts, start a new one instead.
Oh and BTW: please be more specific, see for instance
Forum Etiquette: How to post data/code on a forum to get...
October 29, 2010 at 5:39 am
yes, you can.
My previous answer didn't explicitly state so, since this is the Integration Services forum, but I meant you could do that steps in an SSIS package. Instead of...
October 29, 2010 at 5:26 am
Viewing 15 posts - 16 through 30 (of 102 total)