Crystal report in Web form

ybao · January 20th, 2005, 01:00 PM

Is there a quick way to generate a Crystal report from the dataset of an adhoc query at run time?

jbenson001 · January 20th, 2005, 01:53 PM

there is no "'Quick" way when it comes to Crystal Reports. It is kind of a pain to implement in ASP.NET. I created a class to set up variables etc that needto be done. If you are interested, i can post the code.

ybao · January 20th, 2005, 02:22 PM

Post the code please. I need to generate a Crystal report from an adhoc query user specify at run time, and export it to different formats.
Thanks.

jbenson001 · January 20th, 2005, 03:05 PM

This is what you need.. Exporting is another issue.. I have a class for that..

   Dim crDatabase As CrystalReports.Engine.Database
        Dim crTables As CrystalReports.Engine.Tables
        Dim crTable As CrystalReports.Engine.Table

        crDatabase = crReportDoc.Database
        crTables = crDatabase.Tables
        For Each crTable In crTables
            crTable.SetDataSource(DsCommonReport_rpt1)
        Next
        crvAssess1Comp.ReportSource = crReportDoc --ReportViewer