The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
I am new to building paginated reports and I am struggeling with setting min and max dates as default values in my paginated report values.
I tried these 2 expressions in the Report Parameter Properties / Default Values but I get different error messages.
=First(Fields!TimeGenerated.Value, "DataSet1")
A 'Value' expression used for the report parameter 'FromAPIMTimeGenerated' refers to a field. Fields cannot be used in report parameter expressions.
=Min(Parameters!FromAPIMTimeGenerated.Value)
A 'Value' expression used for the report parameter 'FromAPIMTimeGenerated' includes an aggregate or lookup function. Aggregate and lookup functions cannot be used in report parameter expressions.
How can I set the min date as a default value here?
Thanks
Hi @Anonymous,
Perhaps you can take look at the following links about setting 'default value', 'use parameter in expression' if they helps:
Using Report Parameters in Expressions Explained - Telerik Reporting
In addition, this seem nor related to report builder usages, I'd like to suggest you post at the RS sub forum to get better support.
Regards,
Xiaoxin Sheng