| Author |
Topic |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-08-10 : 14:21:05
|
| Do parameters have to be shown in Report Manager? I have quite alot of parameters for my reports, could be over 20. It will take up alot of room and be unsightly. |
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2009-08-10 : 15:49:42
|
| Not necessarily unless you want the user to able to pick those parameters. |
 |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-10 : 16:21:43
|
| I think it's too many parameters to display. I would have liked to display a few, so that the user can easily run a different set of data output, but this is too many,How does one allow the parameters to get their value from an application interface? and then not display the parameter itself? I mean on the area where the parameters are displayed when the report itself is being run? |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-08-13 : 17:09:09
|
| right click on the layout tab and select "Report Parameters". check "Hidden" for each of the parameters you want to hide. |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-14 : 09:21:23
|
| OK the user has to pick the parameters they want to see. In this case, it is the Product category. Often they just want cat. A, not all 15.Now, I am also setting up an interface that will accept these parameters and pass to the REport Manager.But, what Rohit suggests is problematic because I *DO* want to show the parameters on the Report, but only, if there was something entered.Is there a way to suggest to the Report to only show it, if it has a value?If not, do you see the problem??Then, the only way out of this, would be to send a new SQL as it were to the Report, based on the user choices.If that were possible. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-14 : 09:23:29
|
You mean you want to set a default value for the parameters?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-14 : 09:30:52
|
| No, there are about 15 departments. the user can say I want to see *ALL or I want to see only, Department Electronics, Department Furniture.What I can't see is, if I put the 15 departments as 15 parameters then they will be taking up all that space on the top.I guess they must all be hidden.it would be nice then if the user wants to see only Electronics, they run the report. then they say oh let me see furniture, they can then just change the parameters instead of going back to the interface. My issue is, do I assign the parameters to the report or perhaps one could let the interface create a new SQL out of what the user ticked.But if the latter, how would you do this?Could you put the ad hoc SQL into a stored proc on the fly? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-14 : 10:14:42
|
Why don't you make the 15 departments as a drop down list?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-14 : 10:31:45
|
| Peso, I can do the drop down list but how to code the Report? With 15 parameters established there?Without showing them after they have been ticked by the user.My question is, can there be a way to pass the parameters to the SQL of the Report? This way they are not per se part of the Report. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-14 : 10:46:13
|
Yes. There are example in Books Online how to pass parameters as part of the URL to the report.Then you have to make the reports parse the URL string and set the "hidden" parameters accordingly.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-08-14 : 10:46:23
|
| little confused, so are you referring your 15 departments as 15 parameters? or department is one such parameters, there are 14 other fields like department? |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-14 : 11:03:56
|
| there can be 15 separate departments there are also other parameters like if it's a monthly or a weekly. |
|
|
|
|
Paramters hidden?