DavidKnight
Programmer
Hi There.
(VS2005C# and Crystal 10)
I have an Invoice report with a subreport that runs from a Stored Procedure and is rendered as a PDF. I currently have the report and sub running from the same stored proc. The stored proc sends a range of invoices back as a dataset with the following in my VS2005C# code, which works!:
crReportDocument.SetDataSource(InvoiceHeadService.GetInvoiceData(officeID, billingDate, rangeFrom, rangeTo, invoiceList));
The problem with the sub running from the same stored proc is that the sub has to filter through (by a link) all the invoices to find the one the main is printing. And I find the time to render the report is much to long.
(45 seconds)!
I wanted the main report to run from a "range" stored proc and the sub to run from a "specific" stored proc. But keep getting a not very descriptive error when I run from 2 different SP's..
How do I connect a seperate dataset to a crystal report subreport??
Thanks in advance for your suggestions!
(VS2005C# and Crystal 10)
I have an Invoice report with a subreport that runs from a Stored Procedure and is rendered as a PDF. I currently have the report and sub running from the same stored proc. The stored proc sends a range of invoices back as a dataset with the following in my VS2005C# code, which works!:
crReportDocument.SetDataSource(InvoiceHeadService.GetInvoiceData(officeID, billingDate, rangeFrom, rangeTo, invoiceList));
The problem with the sub running from the same stored proc is that the sub has to filter through (by a link) all the invoices to find the one the main is printing. And I find the time to render the report is much to long.
(45 seconds)!
I wanted the main report to run from a "range" stored proc and the sub to run from a "specific" stored proc. But keep getting a not very descriptive error when I run from 2 different SP's..
How do I connect a seperate dataset to a crystal report subreport??
Thanks in advance for your suggestions!