topic Re: Date Parameter default issue in Report Builder in Report Server

Date Parameter default issue in Report Builder

Anonymous — Sat, 29 May 2021 20:47:53 GMT

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 parameter.

I tried to default the date to today's date in the report parameter by using TODAY(). That generated error as datatype mismatch.

How can i set the date with default as today's date in paramter?

Re: Date Parameter default issue in Report Builder

d_gosbell — Mon, 31 May 2021 00:32:52 GMT

In the "General" tab for the parameter did you make sure to set the data type of the parameter to datetime ?

Re: Date Parameter default issue in Report Builder

Anonymous — Mon, 31 May 2021 14:52:28 GMT

d_gosbell

Yes. Data type is set to datetime. My date field in calendar is set as the date as the dataset is used in many other reports and i cannot change that.

My requirement is

1. Allow the selection of any date - I am able to do that

2. Default is to be set to today - Having trouble in setting Today() in default expression as error says type mismatch. I tried setting as text, but did not get default value

Re: Date Parameter default issue in Report Builder

d_gosbell — Mon, 31 May 2021 23:13:34 GMT

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.

Re: Date Parameter default issue in Report Builder

Anonymous — Wed, 02 Jun 2021 21:41:24 GMT

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.

Re: Date Parameter default issue in Report Builder

Hariharan_R — Thu, 03 Jun 2021 13:07:21 GMT

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

Re: Date Parameter default issue in Report Builder

Anonymous — Fri, 04 Jun 2021 01:53:41 GMT

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.

Re: Date Parameter default issue in Report Builder

d_gosbell — Fri, 04 Jun 2021 02:23:36 GMT

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

Re: Date Parameter default issue in Report Builder

ashishg — Fri, 02 Dec 2022 09:23:21 GMT

Hi,

Go to your Dataset Properties

then go to Parameter section

in paramter value write below expression
=Format(Parameters!CalendarDate.Value, "MM/dd/yyyy")
click ok and try to run report it will solved your issue.
Note;- you can change date format as you want.

Hope this will help you.