Why we need to create two dummy parameters, in place of creating dummy parameters whatever we done to defaultstartdate and defaultenddate can be done to the startdate and enddate parameters right? please correct me if im wrong. Im new to SSRS and I have one doubt, please clarify me. It will automatically refresh based on the selected values. You can give the same expression in both Available Values and Default values property of Parameter by 'Specify values' or 'Get Values from Query'. Can u please provide a solution for this?. If I hide those parameters then the newly selected paramter value is not being reflected in the Paramters. But I have an issue where I wish not to show the Defalut Parameters that have been generated. The solution that U hv provided works fine. I have similar requirement where I need to allow the user to select at any time for 1 year worth of data and restrict the user to select start and end dates within the year selected in year parameter? I don't want to show the default parameters to the users. I applied this solution but the issue is that this mechanism stops working when I hide or make the default parameters as internal.
Please refer to the images in Step 8 as a point of reference. Therefore, the parameters need to be visible. With the solution shown here, if you hide the date parameters the solution does not work. I dont want these fields visible in the UI, Can you please help me in this. If i am changing the "Select parameter visibility" property under general for "Default Start Date" and "Default End Date" to Hidden or Internal, My Start and End Date is not geting refreshed again on changing the month. For this to work the "default parameters" must remain visible, something that is mostly undesirable. I must say this is a neat solution but unfortunately not very practical for the vast majority of cases. Simply remove the Label values from the 'Available Values' option on these parameters. The required refresh capability can be obtained on the Default Start Date and Default End Date parameters themselves. In fact no need to even create these parameters. No need to use the Start and End Date params and no need to worry about making them internal/hidden :)įirst thanks to Ghanesh for providing this solution.įurther to his solution, no need to worry about making the Start and End Date parameters hidden/internal. You will see the correct date values being refreshed in these fields itself when the Year and Month param values are changed. Thanks Ghanesh for an excellent solution.įurther to his solution, the problem can be resolved by simply removing the Label values within the 'Available Values' option on the Default Start Date and Default End Date parameters themselves.
0 kommentar(er)
