December 8, 2008 at 4:16 am
Hi friends,
it might not be complex but i cant figure it out.
i have report which is having 3 parameter. One is type which says weekly, daily and custom. If user select custom then only startdate and enddate parameter should appear. In case of weekly and daily it should run the report of week and day. startdate and enddate should not appear at all in case of weekly and daily selected.
How do i populate startdate and endate only if type = custom?
thanks,
vijay
December 8, 2008 at 9:06 am
you'd have to create your own gui component for collecting those parameters. if you just use SSRS' automatically generated entry panel, all parameters will be displayed.
December 8, 2008 at 10:18 pm
dva2007 (12/8/2008)
Hi friends,it might not be complex but i cant figure it out.
i have report which is having 3 parameter. One is type which says weekly, daily and custom. If user select custom then only startdate and enddate parameter should appear. In case of weekly and daily it should run the report of week and day. startdate and enddate should not appear at all in case of weekly and daily selected.
How do i populate startdate and endate only if type = custom?
thanks,
vijay
You might be able to write a query to default dates based on the selected values of the dropdown so that when the dropdown changes you reset the dates and always have the report work from those dates. They would always be able to edit the dates.
December 8, 2008 at 10:50 pm
You cant achieve this using only ssrs
December 9, 2008 at 2:16 am
Yes, i can write something so that it will appear with default dates if they select weekly or monthly. But if they select weekly then stored procedure will return the data of one week because the type was weekly. Now if they change the dates then it will still return the week of data as the SP will return week data. The user will get confused.
If it is the case that i need to write own GUI then it is not worth to spent lot of time. I would go for default setting and custom will return just empty dates so that every one can enter the dates.
How to create own GUI component with SSRS? is there any guidance or help i can get from any where?
thanks for your help.
vijay
December 9, 2008 at 5:41 am
dva2007 (12/9/2008)
Yes, i can write something so that it will appear with default dates if they select weekly or monthly. But if they select weekly then stored procedure will return the data of one week because the type was weekly. Now if they change the dates then it will still return the week of data as the SP will return week data. The user will get confused.If it is the case that i need to write own GUI then it is not worth to spent lot of time. I would go for default setting and custom will return just empty dates so that every one can enter the dates.
How to create own GUI component with SSRS? is there any guidance or help i can get from any where?
thanks for your help.
vijay
The only way I know how would be to create your own screen (or UI wrapper) about the Report Viewer and pass them in as parameters refreshing the report basically duplicating what the prompt area already does but out side of the Report Viewer control.
December 10, 2008 at 6:58 am
Another option is if they choose daily or weekly, then cascade to the DateFrom and DateTo and have a stored procedure calculate and populate the defaults for these fields. The fields will still appear but it would allow them the ability to not have to type them in.
It's not the most elegant but you're pretty limited when working with the default SSRS parameters.
December 10, 2008 at 9:51 pm
It seems to me that you'd create an asp page that when you put in the first option, based on code it'll populate and display the secondary options (with drop-down boxes).
It also seems to me that this would then execute a stored proc to generate the appropriate results which the (RS) report would then report on or maybe populate a recordset that can be picked up by RS.
If you have many users then the output of the sp would be in the form of a permanent table for that user.
Have to say that I'm particularly new at this RRS stuff but from what I've seen I'm either missing the point entirely or RRS is quite a complex sub-system.
December 11, 2008 at 4:31 am
Thanks all for your kind help.
It is true that SSRS is limited when it comes to use parameters and specially default parameter. If we use the setting provided by SSRS then we need to be limited at certain points but if we can create bit of own work on asp and play with GUI then it can increase the functionality. I would avoid to work on that as it takes long time to do that and it is not worth to spend lot of time in that.
By thta time, we have 2008 and i hope it should have this facility to handle more complexity with SSRS.
thanks,
vijay
December 11, 2008 at 4:39 am
It is true that SSRS is limited when it comes to use parameters and specially default parameter. If we use the setting provided by SSRS then we need to be limited at certain points but if we can create bit of own work on asp and play with GUI then it can increase the functionality. I would avoid to work on that as it takes long time to do that and it is not worth to spend lot of time in that.
Yes exaclty .. rather learning .net and implement that in ssrs it is better to go with sql 2008. Since it will have those facilities.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply