Visual Basic MS Report Builder - How can we set Min(Date) as the default value for a parameter
I am connected a power bi dataset to the MS Report Builder and I need to find a way to set the min date of my date column as default value in my parameter. I setup the a from and to date as date range to filter my data.
I tried
First(Fields!Date.Value, "DataSet1")
but I get this error
A 'Value' expression used for the report parameter 'FromDate' refers to a field. Fields cannot be used in report parameter expressions.
What's the right way of writing this expression?
Solution
Create a new Dataset that returns the min date and use that.
- Save open workbook on a looped five minute timer infinitely
- Delete multiple columns in multiple sheets across multiple workbooks
- Automatically shows date and time in VBA on multiple columns
- Excel macro to identify 0 crossing of the value
- Excel VBA : How to scrap a single value from yahoo finance webpage
- Create/Show Rows based on the value in cell
- Excel drop down list to convert full name & enter Abbreviations
- Remove blank rows in table
- Formating an Excel cell for its value and data type
- Convert Variable Array to String
- VB6 referencing the class name of a form instead of an object variable?
- Can a destination table be unprotected and then protected with the new data entered in it?
- Why is this excel macro failing to run non-interactively via task scheduler since a windows update
- Permission sometimes denied to kill/delete file
- How to pass information from a form to a sub
- For Next Loop to add cell value to previous result
- Could not set the RowSource Property. Invalid Property Value
- VBA: Delete all slides (in PPT) except for specific ones
- Distribute a number across a range so the numbers in the range are as equal as possible to each other
- Append an existing text file to one just created in VBA Excel
- Create button with code, to run working code
- How to keep entered value when its not found in list box
- XMLHTTPRequest always returns "Page not found"
- Run VBA on smartphone
- Create a graph that includes all columns until the last column
- VBA in Word causes infinite loop without message box
- pdf page number font color using addwatermarkfromtext
- Format for Excel VBA addWatermarkFromText
- PowerPoint is Showing Error "Upload Blocked" After Completing Macro via Excel
- Copy and Paste Special (Transpose) multiple times