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
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

At what point does this error appear? I use default of TODAY() or TODAY()-1 in lots of our reports and it works fine although usually I wrap it in CDATE() to strip off the time portion. 

 

Does the report work if you pick a different date? If not this would suggest that the issue is with the parameter in your query, not with the default value.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    d_gosbell 

     

    Here is what i did. 

    My query generated is below  based on my dataset.

     

    EVALUATE SUMMARIZECOLUMNS('OrderHeader'[Customer PO],
    'OrderHeader'[Order Number],
    'OrderHeader'[Order Date],
    RSCustomDaxFilter(@OrderHeaderOrderDate,EqualToCondition,[OrderHeader].[Order Date],DateTime))

     

    I tried to add the Default value in Report Parameter 

    Selected - Specify Values. Clicked on expression and keyed in =cdate(today())

    But the value was showing blank. Is that the way it should behave? or did i mess up something. When i go in to Run View no defaults are shown.