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 |
|
kcrewjap
Starting Member
3 Posts |
 Posted - 2008-12-03 : 18:31:51
|
I have 2 reports, report 'A' which is the main report and report 'B' which is the detailed report.
i have 2 parameters req1 and req2, both datetime parameters. when the user clicks on the hyperlink on Report A, it takes them to report B.
what im trying to do is have the parameters from report A passed to Report B
my datasource looks like this
SELECT ProjectName, Occurrence, StatusName, AssignedMembers, RequestDate, CompletionDate
FROM tblAddProject
WHERE (RequestDate > @req1) AND (RequestDate < @Req2)
ORDER BY RequestDate ASC
i tried adding the req1 and req2 parameters in a WHERE clause, but recieved the the data without the parameters when trying to view the detailed report B
i want the parameters passed to be included in the datasource, but i keep getting the error below when i try and add them to the datasource statement
"The report parameter 'Req2' has a DefaultValue or a ValidValue that depends on the report parameter "Req2". Forward dependencies are not valid"
any help? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-03 : 22:40:46
|
| You need to pass parameters through jump to report or jump to url properties available in navigation tab of cell in main report. you need to specify the detail report as report to navigate too. |
 |
|
|
|
|
|
Passing Parameters between reports