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 |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2010-03-26 : 16:08:22
|
| I have to reports:Software Reporting Summary with 3 fields:AppName (1 of each - about 60 recoreds)AppIDAppCount (an aggregate count of detail records in the sub-report)No parameters. When it runs, all 60 AppNames are retrieved.Software Reporting DetailAppName (many of each AppName with different details)WorkstationNameEtc.. detail lines(Has parameters, including AppName so, when run separately, narrows the search down)Both reports use different stored procedures as datasets on the same shared datasource in the same project. They run fine separately and the summary report runs quickly.When I put the detail report in the summary report as a subreport and link the AppNames, the report takes a great deal of time to run and runs, complete with all 60 summary lines and a toggle '+'. But when I click the toggle, a little error comes up and says the subreport cannot be displayed. I get an error like this at the bottom: [rsNone] An error occurred while executing OnInit: Object '/51f0c79c_9e05_4692_8f3c_17c6535ecbb5/5d9tlkkf58bpfkgjq77fnmi6_323.rem' has been disconnected or does not exist at the server.I think I may be dropping the subreport at the wrong place on the design layout. I have a tablix which has the 3 main fields and a group field with the aggregates underneath it. I tried putting it in a separate area and it wouldn't let me. I tried putting it in the AppName column in the detail area (it would complain about scope, etc.) Then I would put it in the group area, and then I tried making another column. None of it worked. Please help me. Thank you.Duane |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-27 : 03:34:07
|
| are you passing any parameters from main to subreport?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2010-03-29 : 11:37:12
|
| No I am not, but I did try to before, but couldn't figure out how to do the output parameters. Yhen, I thought maybe I was wrong in using them since you map the columns to each other in the sub-report properties. I have another thread in this forum where I have some more detail on a similar subject. Thank you for your attention here.Duane |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-29 : 12:32:16
|
quote:
Originally posted by duanecwilson
No I am not, but I did try to before, but couldn't figure out how to do the output parameters. Yhen, I thought maybe I was wrong in using them since you map the columns to each other in the sub-report properties. I have another thread in this forum where I have some more detail on a similar subject. Thank you for your attention here.Duane
As answered in earlier query you pass fields/parameters from main report as parameters for subreport------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Report with sub-report won't display detail