populating a crystalreport

[Anti-Rich]

hi everyone

i read in another thread in the forum that it is possible to use a query to grab the information you need (for a crystal report) to put into a report, this avoids the pitfall of the report requiring a login when accessing the report. can someone please either show me how to do this, or point me towards a site/thread that can? does it get done through datasets? i would greatly appreciate someone clarifying this for me as i know it will save me many many headaches down the road.

cheers
adam

 

[DavidT_macktool]

Are you asking about a 'PUSH' method, where a data table established in vb.net is used in a crystal report.

Research 'Crustal reports push' and you should find some information.

Basically, create your dataset(sql commands and stuff) - define a shared datatable and fill it with your info - then tell your report to use that datatable.

example code for setting the datasets:

Dim MyRpt As New YourReportName
MyRpt.SetDataSource(YourSharedTableName)
MyRpt.OpenSubreport("YourSubReportName.rpt").SetDataSource(SharedTableForSubreport)

Hope that gets you started...

 

[Anti-Rich]

hi david

thankyou for your reply, it was exactly the sort of thing i was looking for. you have saved me many stressful nights, hahah

cheers mate

regards
adam