
June 29th, 2005, 10:27 AM
|
|
Registered User
|
|
Join Date: Jun 2005
Posts: 3
Time spent in forums: 58 m 13 sec
Reputation Power: 0
|
|
|
VB, Crystal Reports and Access
I need to call a crystal report from VB.NET that uses user input paramters for the report and queries an MS Access database. What is the best way to do this?
Currently, in VB.NET I have written a query as a string (i.e. qry = "Select * from myTable where time = " & userInput ) I need to save this query to Access such that Crystal Reports may reference that query. I am very new to all of these (especially Crystal Reports,) so I'm pretty lost as to how to do this.
I tried (and almost succeded) in just loading the query into a dataset and then using the dataset to generate the report. it worked fine when I only used one table. But when I used multiple tables (qry = Select table1.*, table2.*, table3.* from (join...)) I couldn't figure out what to name my dataset (da.fill(ds, "???") for it to work. I'm pretty sure this is the issue since my other report using one table didn't work until I named my ds the same as the table in access.
is there any other way to do this? My biggest problem is I don't know how to work with Crystal Reports.
|