Click here to Skip to main content
14,130,705 members
Rate this:
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.

1 solution

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190518.1 | Last Updated 11 May 2011
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

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