@Andrew wow. After all the hours spent on how to set my date parameters default to the max date or entity list to show correct list you have done it. Thank you for posting, Much appreciated!
All this many years, you're still posting these helpful videos. Thank goodness. I've been watching these off and on for years. One question that I'm sure you've covered somewhere. How can I set the multivalue parameter to default to "Select All"? In other words, I want all the values selected when the report is initially opened. Thanks in advance.
Hi there! You can use the same dataset which you used to populate the available values for the parameter. So, for the Movies database for example, if you'd created a parameter to select a Country and populated the available values with a dataset which selects CountryID and Country, you can set the default values with the same dataset using the CountryID field. I hope that helps!
@@foxybark That's OK, it's not really necessary to have an ID field to populate or set the default values of the drop down list. You can just use the same dataset that you used to set the Available Values (or type in the same list of values if you didn't use a dataset!)
Thanks for the earlier reply!. Awesome!. Is there a way to make the Select All to be selected in the Parameters. The query pulls all the values but I like it to show the it to be the Default. It shows but the user have to select it.
Love these videos. Wondering if you have ran into the problem I'm currently having. If I want to use the wildcard character % as a default to select All, I have to use the "LIKE" query command in the dataset query or filters (As you explained in this video). If I want to select multiple values from the parameter I have to use the "IN" query command and make sure to remove the [0] from =Parameters!parameterName.Value[0] (As you explained in another video). I'm unable to display all rows by default but then choose to display multiple of the same parameter. Thanks in advance
Sorry but I believe I found a solution. I cannot use the % wildcard symbol as I am using the "IN" command, but I can use your solution in video 11.3 at the 14 minute mark and ad this new dataset as my default values in my parameter(from query). Hope this helps someone else.
Hi Ravi, we do have some C# videos already which you can see in this playlist th-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html We don't have any plans to add any more at the moment.
Awesome video, as always. Thank you. I have two date parameters that need to be hidden. When I select a financial month from a drop-down then the start date for that financial month must be populated automatically. When the start date is not hidden then the auto population takes place, but when the start date is hidden then I have to click on "View Report" in order for the next prompted field to be populated. What I am I doing wrong. Where should I start looking?
Hi Pieter! I haven't encountered that situation previously but I'm curious! Just so I understand: Param1 is your financial month drop down list, populated using Available Values; Param2 is your start date, whose Default Value is set with an expression which relies on the value of Param1 and Param2 is the one you want to hide? What's the setup for the third parameter which depends on Param2?
@@WiseOwlTutorials The report start and end date range is determined by what Financial Start Month (par1)and Financial End Month (par3) the users picks from a dropdown list. The 'Start date' (par2 hidden) for report is determined from the start date of the Financial Start Month parameter and the 'End Date' (par4 hidden) is determined from the end date of the Financial End Month parameter. My hidden default values must be the 'Start date' and 'End date'. When the 'Start' and 'End' dates are made visible then they default to the desired dates correctly and the parameter highlight jumps to the next possible parameter. When the 'Start 'and 'End 'dates are hidden, then they do not default or move to the next possible parameter.
Really thank you for these life saving videos. I have one question regarding the default dates, is it possible to make the start date change dynamucally when the user enters a different end date?
Hi Nick! You can do this type of thing, providing that you arrange the parameters in the correct order. For example, you could create a date parameter called End, followed by another date parameter called Start. You can set the default value of the Start parameter to an expression which references the End parameter, for example: =DateAdd(DateInterval.Day, -7, Parameters!End.Value) Providing the End parameter appears before the Start parameter, you can choose an End date and the Start will be set automatically. I hope it helps!
@Andrew wow. After all the hours spent on how to set my date parameters default to the max date or entity list to show correct list you have done it. Thank you for posting, Much appreciated!
Happy to hear that it helped, Joel! Thanks for watching!
All this many years, you're still posting these helpful videos. Thank goodness. I've been watching these off and on for years. One question that I'm sure you've covered somewhere. How can I set the multivalue parameter to default to "Select All"? In other words, I want all the values selected when the report is initially opened. Thanks in advance.
Hi there! You can use the same dataset which you used to populate the available values for the parameter. So, for the Movies database for example, if you'd created a parameter to select a Country and populated the available values with a dataset which selects CountryID and Country, you can set the default values with the same dataset using the CountryID field.
I hope that helps!
@@WiseOwlTutorials I'll give it a shot. I know my dataset doesn't have a unique id like country_id.
@@foxybark That's OK, it's not really necessary to have an ID field to populate or set the default values of the drop down list. You can just use the same dataset that you used to set the Available Values (or type in the same list of values if you didn't use a dataset!)
Thanks for the earlier reply!. Awesome!. Is there a way to make the Select All to be selected in the Parameters. The query pulls all the values but I like it to show the it to be the Default. It shows but the user have to select it.
Hi Phillip, yes you can! This video explains how to do it, I hope it helps th-cam.com/video/g66aMjPuR8U/w-d-xo.html
very useful info. keep it up brother👍
Thanks! Appreciate the support as always!
Love these videos. Wondering if you have ran into the problem I'm currently having. If I want to use the wildcard character % as a default to select All, I have to use the "LIKE" query command in the dataset query or filters (As you explained in this video). If I want to select multiple values from the parameter I have to use the "IN" query command and make sure to remove the [0] from =Parameters!parameterName.Value[0] (As you explained in another video). I'm unable to display all rows by default but then choose to display multiple of the same parameter. Thanks in advance
Sorry but I believe I found a solution. I cannot use the % wildcard symbol as I am using the "IN" command, but I can use your solution in video 11.3 at the 14 minute mark and ad this new dataset as my default values in my parameter(from query). Hope this helps someone else.
@@mikeb8828 Hi Mike, you beat me to it! Glad you found the solution!
Hi. Thank you for amazing videos. Is there a plan to show C# videos?
Hi Ravi, we do have some C# videos already which you can see in this playlist th-cam.com/play/PLNIs-AWhQzckxhclAO-4SsUWoHDxKKiFj.html
We don't have any plans to add any more at the moment.
@@WiseOwlTutorials Thank you. I learned VBA by watching your videos. C# is next in line.
@@tejamarneni I think you'll enjoy it! Our videos only cover the very basics to get you started but I hope you find them useful anyway!
Awesome video, as always. Thank you. I have two date parameters that need to be hidden. When I select a financial month from a drop-down then the start date for that financial month must be populated automatically. When the start date is not hidden then the auto population takes place, but when the start date is hidden then I have to click on "View Report" in order for the next prompted field to be populated. What I am I doing wrong. Where should I start looking?
Hi Pieter! I haven't encountered that situation previously but I'm curious! Just so I understand: Param1 is your financial month drop down list, populated using Available Values; Param2 is your start date, whose Default Value is set with an expression which relies on the value of Param1 and Param2 is the one you want to hide? What's the setup for the third parameter which depends on Param2?
@@WiseOwlTutorials The report start and end date range is determined by what Financial Start Month (par1)and Financial End Month (par3) the users picks from a dropdown list. The 'Start date' (par2 hidden) for report is determined from the start date of the Financial Start Month parameter and the 'End Date' (par4 hidden) is determined from the end date of the Financial End Month parameter. My hidden default values must be the 'Start date' and 'End date'. When the 'Start' and 'End' dates are made visible then they default to the desired dates correctly and the parameter highlight jumps to the next possible parameter. When the 'Start 'and 'End 'dates are hidden, then they do not default or move to the next possible parameter.
Really thank you for these life saving videos. I have one question regarding the default dates, is it possible to make the start date change dynamucally when the user enters a different end date?
Hi Nick!
You can do this type of thing, providing that you arrange the parameters in the correct order.
For example, you could create a date parameter called End, followed by another date parameter called Start. You can set the default value of the Start parameter to an expression which references the End parameter, for example:
=DateAdd(DateInterval.Day, -7, Parameters!End.Value)
Providing the End parameter appears before the Start parameter, you can choose an End date and the Start will be set automatically.
I hope it helps!
@@WiseOwlTutorials Thank you, after trying this it really works.
Hello, how parameters interact with each other?
You mean like this? th-cam.com/video/mM9Ki4YSxBo/w-d-xo.html