• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 73 views
  • Users 0 members are here
Related

Default Parameter values in SSRS Utility

Jeff Gallo
$organization

Hi All,

I've been working on a project to help our marketing team send communications to patrons based upon those patrons demonstrated interests in performances. The method works based upon interest weight, adding up the total weight of all the keywords on future performances for each individual and then sorting the individuals into affinity groups for each future performance. So that the Marketing team would be able to easily make use of this I've built a utility where they can specify parameters of between two and six performances to compare. Then the utility runs and fills tables based upon the patrons greatest affinity among those performances. 

It all WORKS just fine so far. But there's a little hiccup in the experience. When any of the optional performance parameters are left blank the utility doesn't pass the default value of 0 and instead we are presented with feilds for each of the parameters and zeros must be filled in manually. Once those zeros are filled in and we click View report, it works as expected. SO its usable, but any idea how I am losing those default parameters?

Thanks in advance.

Jeff

  • $organization
    I think the trouble here is that the default value for a parameter configured in report setup is NOT the same as the null state of a parameter. The default value only ever shows up the first time a user runs a report--any subsequent runs will default to the previous parameter values.

    I can't think of a situation where I would have a performance selection parameter that also gave me the ability to manually enter a zero, so there may be something else going on here. If you want to provide your report setup XML maybe we can help figure it out.
    NICK REILINGH | Database and Systems Manager
    RICHARD B. FISHER CENTER FOR THE PERFORMING ARTS AT BARD COLLEGE
    PO Box 5000 | 60 Manor Avenue | Annandale-on-Hudson, NY 12504
    Office: 845-758-7948 | fishercenter.bard.edu
  • $organization

    Perhaps you could you update the stored procedure the report relies on to set the parameter to zero if the parameter passed when running the report is null?

    Martin



    [edited by: Martin Keen at 6:54 PM (GMT -6) on 24 Aug 2017]
  • $organization

    Also remember the parameters are being passed in by Tessitura, so it depends what they pass in for a field that hasn't been entered.

    They may be passing Null through but from the SSRS point of view that is a value they see being passed in so wont use the defauly value, which it would probably do if the field wasn't passed in at all.

    The way I would set this up is to allow nulls on the fields in SSRS and then set the default values in your stored procedure to be 0.

    Mark

  • $organization in reply to Mark Ridley

    Thank you, Mark. 

    Allowing Null in the Report Definition is what I was looking for. Works like a charm now.