Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtrapat1
Starting Member
43 Posts |
 Posted - 2008-09-19 : 16:01:15
|
| I have a problem with the parameters for my report.I am using three stored procedures as my datasets in SQL ;Basically, my parameter screen accepts a start and end date for the date range parameters, a clientid for the dropdown selection, and an eventid for the final drop down selection.The problem is in the refresh of the data.After the start and end date are entered, the clientid drop down is populated, and after this clientid is selected, the eventid dropdown is populated.My end users would like to have the ability to repeatedly select clientid BUT NOT have to change the values in the start and end date ranges.Currently when the user changes the clientid, the start and end dates do not change, and therefore do not update the stored procedures that depend on them for the drop downs below - eventid and clientid.I am using SSRS 2005 so it is probably not supported for this type of report;but I am willing to rewrite or redesign the report to satisfy the user.Is there any way that I could redo this report to get my desired interface?I thought if I could rewrite my three stored procedures as a sub select, that this may fix the problem.What are my options?Could I do this with temporary tables?Or, could I possibly disable the start and end date text fields and add a reset button to retain the original entered dates?Or, my option for the subquery?Thats all I can think of for the moment.Thanks In Advance.John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 01:58:07
|
| Ok. i guess your problem is you're passing startdate,enddate as paramters to dataset that populates clientid dropdown. this will make clientid parameter dependent on date params. try removing them and then amend code for clientid to return all clientid regadless of date params. this should solve your problem i guess.let me know how you got on. |
 |
|
|
jtrapat1
Starting Member
43 Posts |
Posted - 2008-09-22 : 13:49:03
|
| visakh16,thanks for the post-I really need these star and end date params to filter the client list;Is there anything I could do as a workaround?Maybe build an intermediate page with the two parameters?Or, use some Custom Code to initialize the date range?Reply when you can.ThanksJohn |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 13:54:54
|
quote:
Originally posted by jtrapat1
visakh16,thanks for the post-I really need these star and end date params to filter the client list;Is there anything I could do as a workaround?Maybe build an intermediate page with the two parameters?Or, use some Custom Code to initialize the date range?Reply when you can.ThanksJohn
then obviously it will refresh as each change of date value requires dropdown to be populated with only clients for that date range.The other alternatively is to prepopulate all clinet ids into dropdown and there by making it independent of dates. so that for all dates all clintids will be available. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 13:56:48
|
| for initializing date range, you could create two datesets which will provide you with initialised values of dates and map it to default value property of both params. |
|
|
|
|
|
|
|
|
Options on handling stored procedure parameter ref