Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Parameter default issue in Report Builder

New to paginated reporting.    I am trying to connect to an existing dataset with calendar table. I have used the Date field( date data type)from calendar as a filter and trying to use the  paramet...
Report
Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
5 years ago

Hi 

  If you set available values for your parameter which is coming from another dataset then default value should be part of available values otherwise it will not show anything. 

Example  - If you have list of date for available values like 1/1/2020, 1/2/2020...... Then if you are using Today() then today's date should be part of available dataset result.

 

Thanks

Hari

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hariharan_R 

     

    I want the report to display today's data once the user clicks on the report link. Is that possible with Paginated report. 

    I want the users be allowed to pick a parameter and execute for any other date.  

    • d_gosbell's avatar
      d_gosbell
      Icon for Super User rankSuper User
      5 years ago
      Anonymous wrote:

      Hariharan_R 

       

      I want the report to display today's data once the user clicks on the report link. Is that possible with Paginated report. 

      I want the users be allowed to pick a parameter and execute for any other date.  

      It's definitely possible and I can't see why it's not working this way now. As Hariharan_R suggested, have you checked the available values setting. I often leave this blank for datetime parameters. But if it was using a dataset that returned text values instead of datetime values you would get an error like you first reported. And if it was returning a set of dates that did not include today's date the parameter would be blank when you run the report as the default was not one of the allowed values