VB.Net and Crystal Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Does anybody know if there is a way to dynamically have a dataset linked to a predefined crystal report? The project initially was created to deal with a few static reports but now my client has the need for much more reporting and it would be much easier to do this dynamically, if at all possible

Current situation
User is coming from a form where parameters for a report are specified. These are then passed to the form that will generate the Crystal Report. From this point, a dataset would be created and based on the information, the query that was sent to the database would be displayed in the CrystalReportViewer.

I have yet to figure out a way around this because the crystal report cannot be created without a predefined dataset, and this would seem to suggest that the dataadapter would also have to be predefined. :(

Is there a better way of doing this??

Cheers

Karl
 
Karl,

The following works if you want to change databases (the user can do this)

'set crystal reports to new database
Dim MyReport As New MyCrystalReport
Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
Dim myLogonInfo As CrystalDecisions.Shared.TableLogOnInfo
For Each myTable In MyReport.Database.Tables
myLogonInfo = myTable.LogOnInfo
With myLogonInfo.ConnectionInfo
.ServerName = DatabasePath & DatabaseProjectName
End With
myTable.ApplyLogOnInfo(myLogonInfo)
Next myTable

Jan

Hello,

Does anybody know if there is a way to dynamically have a dataset
Click to expand...
linked to a predefined crystal report? The project initially was created to
deal with a few static reports but now my client has the need for much more
reporting and it would be much easier to do this dynamically, if at all
possible.
Current situation:
User is coming from a form where parameters for a report are
Click to expand...
specified. These are then passed to the form that will generate the Crystal
Report. From this point, a dataset would be created and based on the
information, the query that was sent to the database would be displayed in
the CrystalReportViewer.
I have yet to figure out a way around this because the crystal report
Click to expand...
cannot be created without a predefined dataset, and this would seem to
suggest that the dataadapter would also have to be predefined. :(
 
Back
Top