By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,175 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,175 IT Pros & Developers. It's quick & easy.

need help open crystal report based on ADO.net dataset and two tables

P: n/a
I have a form with a dataset that contains account records in one table
and another table that contains transactions for accounts that are in
the other table. I'm trying to create a report based on the two tables
using an inner join. I used the report wizard to create my report and
when I open it it just sits there not populating like it is hanging.
The dataset maybe has about 4500 records in one table and the
transaction file has 35K records. here is the code I'm using to open
the report viewer and load the report. Any help would be great!

Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

reportDocument1.Load(Application.StartupPath & "\CrystalReport2.rpt")
reportDocument1.SetDataSource(Form1.SQLDataSet)
reportDocument1.Refresh()

With CrystalReportViewer1 'ReportViewer1

..DisplayGroupTree = True

..DisplayToolbar = True

..ReportSource = reportDocument1

..Refresh()

End With

End Sub

Nov 30 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.