Viewing 15 posts - 16 through 30 (of 103 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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
November 3, 2010 at 4:35 am
Nicely worked out solution, I liked some comments in your code a lot :w00t:
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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.
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
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...
Peter Rijs
BI Consultant, The Netherlands
October 29, 2010 at 5:26 am
Viewing 15 posts - 16 through 30 (of 103 total)