Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Asp.net Application How to push dataset to report and subreport

Status
Not open for further replies.

AndyBor

Programmer
Nov 19, 2004
2
US
I have a CR report that has a subreport linked dataset.xsd Need to know how to output the CR report and subreport to a CrystalReportViewer1. I have been able to push the data to see the main report but can't see the subreport data?

Dim conHaz As OleDbConnection = New OleDbConnection(ConfigurationSettings.AppSettings("strConn"))

Dim oleAdapter As New OleDbDataAdapter
'Main report
Dim RsPrintLableeRFD As New PrintLableeRFD
'Sub report
Dim RsPrintLabeeRFDChem As New PrintLabeleRFDChem

Dim strContentSQL As String
strSQL = " some sql statement"

oleAdapter.SelectCommand = New OleDbCommand(strSQL, conHaz)
oleAdapter.Fill(RsPrintLableeRFD, "PrintLableWebRFD")

Dim oRpt As eRFDLabel
oRpt = New eRFDLabel
oRpt.SetDataSource(RsPrintLableeRFD)
oRpt.SetDatabaseLogon("Admin", "")

??I think I must fill the subreport?

CrystalReportViewer1.ReportSource = oRpt

Please help I am new with .net and crystal report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top