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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-10-29 : 13:02:59
|
| Hi,User wants a way to be able to clear all parameter entries to start from scratch. Is that possible. Interestingly, if you select a few parms and press F5 or Refresh button before running report it clears all fields. But of course it will not do that once report is ran.Thanks<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-29 : 14:57:36
|
| We do that by having a "Start Over" button that does a Jump To URL equal to the report that is already running. We have a 1 record table in test and production that has the "http://Reports2/Test_ReportServer?/" and "http://Reports1/ReportServer?/" respectively returned. We concat that with the global parm or report name.Cludgy but it works.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-10-29 : 15:28:13
|
| i love it ! clugy yet practical. but we have standard edition report server. so how do you add a button on the report.<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-29 : 20:25:27
|
| Not really a button but a text box with blocky type font. Then on properties, navigation create the HTTP link with combo or a data set returning data set with only one record. Create the parameter with the default from query. Then in the navigation concatenate the static piece from parm with Global report name.Updated 10/30 after getting to work...Insert an embedded image of any graphic you like for a button. Right click, Properties, Navigation, Jump To URL available.JohnIt's a small world (but I wouldn't want to paint it). |
|
|
|
|
|
|
Clearing all parms