ssrs 2008 make parameter optional?

  • In an SSRS 2008 report, there are parameters for next school year and another parameter for current school year. The problem is there is no data for the next school year in the database until Feb. 2017. Thus the next school year parameter does not load with data and the popup message for the report says 'please enter a value for the parameter 'Calendar - upcoming year'. The parameter can not be blank'.

    Thus can you tell me if one of the following options would work, how I can accomplish that task using ssrs?

    1. Based upon today's date, can I make the parameter 'Calendar - upcoming year' optional? if so, how would I complete that task?

    2. Should I create another parameter and have it select what calendar to pick (upcoming or current year)?

    If so, how would I complete that task?

    If my suggestions do not work, what would you do to solve my problem and how would be complete your method using ssrs 2008?

  • Try this option: http://bfy.tw/79bE

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply