Forum Replies Created

Viewing 15 posts - 16 through 30 (of 103 total)

  • RE: Stopping a subscription

    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

  • RE: COLLATION

    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

  • RE: Handling delimted rows

    Nicely worked out solution, I liked some comments in your code a lot :w00t:

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Currency Formatting

    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

  • RE: Does SSL activation in Reporting Services 2005 exclude the use of http in favor of https

    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

  • RE: How to format Strings in cells

    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

  • RE: Can I export to Excel and force my headers into page headers in Excel?

    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

  • RE: Report builder button not visible to user SSRS2005 SE

    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

  • RE: Reporting against variable DataSet

    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

  • RE: Does SSL activation in Reporting Services 2005 exclude the use of http in favor of https

    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

  • RE: Unable to create a subscription

    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

  • RE: Currency Formatting

    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

  • RE: How to format Strings in cells

    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

  • RE: ERROR TRANSFERING DATA FROM SQL DATABASE TO EXCEL FILE

    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

  • RE: Handling delimted rows

    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

Viewing 15 posts - 16 through 30 (of 103 total)