Click here to Skip to main content
11,408,708 members (60,470 online)
Rate this: bad
good
Please Sign up or sign in to vote.
Management wants me to pull yet another rabbit out of my... er... hat. Any help would be appreciated.

We have a number of CR reports on our website. They use the "push" method to populate the data: the user selects a number of filters, the page uses those to create a dataset, then pushes the data to the report using ReportDocument.SetDataSource. This has worked fine for many years, as all of the reports are flat.

Now I have to put out a report that relies very heavily on subreports; 11 of them, to be precise. When I try to retrieve the report using the above method, the viewer is not rendered and there is a nice, friendly HTML comment on the page source saying "Failed to open the connection." At a guess, I am retrieving the data for the main part of the report, but not for the subreports. I suppose I could try generating datasets for each subreport, but that strikes me as horrifically clunky, especially for a report that is still under development and will be for a few months. I have tried switching to a "pull" method, but that hasn't worked either.

So here are my requirements: The main part of the report draws from a view, and the different subreports use different fields from that view as their linking parameters. The report will only show one person's data at a time, so I can use a selection filter. At the moment the website and the database are on the same server so network permissions aren't an issue, but that will be changing in a few months.

If you have any suggestions or links, I'm all eyes.
Posted 11-May-11 6:56am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 390
1 Sergey Alexandrovich Kryukov 284
2 Maciej Los 155
3 Peter Leow 140
4 PIEBALDconsult 130
0 Sergey Alexandrovich Kryukov 8,626
1 OriginalGriff 6,855
2 Maciej Los 3,322
3 Abhinav S 3,238
4 Peter Leow 3,034


Advertise | Privacy | Mobile
Web01 | 2.8.150414.5 | Last Updated 11 May 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100