Forum Discussion
URL date parameter for Paginated Reports
Could you set a default value expression of =Today() in the parameter?
I do have a default value expresion that gets set when I manually select a value for another parameter. If I try to add both parameters to the URL, I can only hardcode the date. Will not allow me to add something like "Today()" Here is an URL that works:
https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20&rp:courtcode=NCA%20&rp:courtstartdate=2021-03-16
This one does not work:
https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20
or
https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20&rp:courtstartdate=Today()
Why are you trying to send it in the URL rather then doing it in the report design?
The user must select a courthouse, then up to 20 departments to see the report. This can be anoying for someone that must do this every day. If I show them how to create a link with the parameters preset, they will be more inclined to accept this new concept.
If the majority of the time they are going to want todays date. Then my original idea is still valid. You can 'hard code' the date parameter to be =Today() in the report. Then if they want something different, they add that parameter to the url string. So you are making it easy for the majority of the requests and still have an option for the rest.