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.

All Forums  Development Tools  Reporting Services Development  Requery Parameter Fields

Author  Topic  Tonic Starting Member 26 Posts Posted - 2006-06-01 : 01:30:56 I have a report that runs on a number of parameter date fields (coverted to string). At present, the report automatically defaults to MAX value of a date. The syntax for that particular element/dataset is SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur FROM tbl_src_date What I am looking to acheive is that if I was to modify the parameter to allow the user to specifiy a date from that particular field (rather than default to MAX), how could I get the subsequent parameter boxes to requery automatically. The code I use for the other 5 parameter fields is; SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur , CONVERT(char(11), dateadd(mm,-1, MAX(src_date))) AS src_date_pre FROM tbl_src_date SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur , CONVERT(char(11), dateadd(mm,-2, MAX(src_date))) AS src_date_pre2 FROM tbl_src_date SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur , CONVERT(char(11), dateadd(mm,-3, MAX(src_date))) AS src_date_pre3 FROM tbl_src_date SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur , CONVERT(char(11), dateadd(mm,-4, MAX(src_date))) AS src_date_pre4 FROM tbl_src_date SELECT CONVERT(char(11), MAX(src_date)) AS src_date_cur , CONVERT(char(11), dateadd(mm,-5, MAX(src_date))) AS src_date_pre5 FROM tbl_src_date If it makes a difference I am using SS-RS 2005. Regards Toni C aka Talisa