I have a date filter, and I default it to first day this month and last day this month under relative date, when I run it it givis me error:
The Value expression for the report parameter ‘FromDate’ contains an error: [BC30456] 'Date' is not a member of 'Integer'. (rsCompilerErrorInExpression)
Can anyone fix this problem?
But it works for Today or (n)months ago.
Thanks.
Post your expressions and indicate what the data types are for the referenced field(s).|||OK, I narrow down what cause this, my date Fields are standard date type. I have 2 dates From Date and To Date, and I put those in filter with default values:
From Date : first day this month, To Date: last day this month
I also have a Textbox with value: =parameters!FromDate.Value
Because I need to display what is being filter on the output, but that is what cause the error, if I use Today or (n) months ago as default, it works.
|||So are you saying this gives the error?
=parameters!FromDate.Value
I doubt that is causing the problem unless you maybe have a number format string for the textbox?
|||If I remove the Textbox with value: =parameters!FromDate.Value, then it works fine with the From Date : first day this month, To Date: last day this month. But if I add the Textbox back with those value it gives me the above error?
|||And then if you put a new text box on the report and set the Expression to =Parameters!FromDate.Value and leave all other settings for the text box alone, what happens?
No comments:
Post a Comment