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 |
|
shebert
Yak Posting Veteran
85 Posts |
 Posted - 2009-11-09 : 16:19:14
|
| HelloI have a main report that has parameters startdate, enddateit returns a list of parts and quantitiesI added a sub report down below the main report it accepts startdate,endate and part from main reportit works but only gives me the data for last part from main.I want to be able to click any part from main and have sub refresh with data from that part clicked in main.any Ideas?Thanks Steve |
|
|
shebert
Yak Posting Veteran
85 Posts |
Posted - 2009-11-09 : 16:41:08
|
| Ok so if go to properties if the part field on the main report I can set navigation to the subreport, but then it jumps out of main and into sub report giving data for part selected.is there any way to get it to run the subreport and display it on the main report? |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-10 : 16:06:26
|
| Can you force a value to be at the end of the table that you can use to control whether or not it is hidden?Something like if part# 9999999 then under visibility:=Iif(Field.PartNo.value=9999999, True, False)JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-11 : 12:13:11
|
| cant you navigate to same report with part field value as selected part & mode parameter with 'detail' value? then when mode=detail, show only part info alone |
|
|
|
|
|
|
How do I get the sub report to data