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 |
|
Neharika
Starting Member
4 Posts |
 Posted - 2010-12-05 : 23:27:52
|
| I am facing an issue with setting default value of a parameter.In my report i have a parameter 1 which has list of department codes and parameter 2 which is a hidden parameter and has id of the user. I have hardcoded the default value for parameter 2.I have two datasets for parameter 1, one populates the available departments and the other dataset for fetching the default value.The dataset that is fetching the default value uses parameter 2 in a sql query to fetch the value. i.e. SELECT PU from tbl_Access where Email_Id = @Parameter 2The issue is that i am not able to get any default value for parameter 1 on my report.Thanks. |
|
|
|
|
|
setting default value of parameters