I need some help. I have a fairly simple CR.net report that works great. I'm using the PUSH method, so I made an .xsd file with the data schema to create my report, I query the DB and fill a dataset in code, then pass it to the report as shown in the code snippet.
This works great and I have the ability to "massage" the data in the DS before I push it out to the CR report.
Problem is that I want to add a subreport using the same data access method. I've created the subreport xsd file, built the report itself and added all my fields. I added the second, new report to my other report as a subreport and linked the proper main report ID field to the subreport ID field.
But I can't seem to figure out how to call the Report.SetDataSource() method on the subreport. I can't find a Report.SubReport property as I've seen shown on some of these postings for this type of issue.
Also, whenever I run the code it keeps asking me for database logon information - which shouldn't even be involved since I'm pulling the data from the DB myself in code. The reports don't know anything about my database connections and shouldn't need to.
If anyone knows how to pass a DS to a linked subreport or knows of a good write up on how to do this, please let me know.
Thanks a lot,
Dim ADP As New SqlClient.SqlDataAdapter(qry.ToString, con)
Dim DSx As New DataSet
Dim Rpt As New rptStandardCageV2
CRViewer.ReportSource = Rpt