Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,183 total)

  • RE: Dynamically name report/file export in SSRS

    SQL-Student (3/22/2010)


    What about customer support?

    From what I know, Microsoft will not support you, if you make modifications to the SSRS Catalog manually.

    *grin* Don't tell them

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Dynamically name report/file export in SSRS

    Gaurav.Vinodkumar (3/22/2010)


    nice article...but one question..if we have to do the same thing at run time (means when user export the rport to pdf or excel) from the report viewer..is there...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

    How do you come to the value of 3 for left nodes with a value of 2 passed in? The way I understand it. ID 2 is a left (that’s...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: TSQL parser

    What's the ultimate goal of this task?

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Help with select please

    or remove the case all together...

    SELECT * FROM yourTable WHERE yourField <= @parameter + 1

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Data Driven Subscriptions Updated

    You should find out why the subscription is getting messed up instead of working around the problem. πŸ™‚

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Data Driven Subscriptions Updated

    Kevin,

    When that situation occurs it means that something went wrong during the execution. You will need to delete that subscription and create a new one.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Subscription wont stop running

    One possible hack...

    Look through the SQL jobs on your ReportServer instance named with a GUID. Since you've changed it so it would run in the past, you should be able...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Running Total does not pick up 2010

    Does your MonthYear table have entries for 2010?

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Static Report Parameter Question

    Actually, it's less complicated than that. One (or more) of your parameters "depend" on the user's selection of another parameter. Simply move any paramter the relies on another parameter lower...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: SP_HELP_JOBSTEP throws String or binary data would be truncated Error

    What's on line 95? πŸ™‚

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: How to pass a list of parameters from a table variable?

    Search this site for the SPLIT function...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Simple SQL Grouping Question

    If you have a table like "tblTeamMembers" or "tblTeams" you'll need to LEFT JOIN the tblActivity to it.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Data Driven Subscriptions

    All,

    This is a link to the most recent version. I have not returned to work on this process since it's creation and there may be many ways to improve upon...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • RE: Data Driven Subscriptions Updated

    You'll have to address the security issue. I haven't gone down that path, so good luck ... !!!!

    and if you get it, post your solution here for all to see...

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 15 posts - 421 through 435 (of 1,183 total)