ok, no matter you use a same database or different database in a crystal reports and its subreports,

guest (BigDesk)
<本文发表于: 相约加拿大:枫下论坛 www.rolia.net/f >
you can try the following two ways:
1- use dsn. in each report/subreports, you set your dsn respectively, which actually get you the data from the tables/views in the database, and then in all your subreports you use the record selection function to filter and match you data for the subreports, this is the old way, if your tables/views hold huge data that would be very slow to show the whole reports;
2- use ttx/ado. in your main report/subreports, set the database sourse to a series of ttx files, and then in your program you call the sp to get the reqiured recordset, and then send the setdata command to the crystal reports, and show the reports. you also should set the record selection fomular in your subreports to get the matched data for it. this would give u the best perfomance coz the recordset returned is filtered instead of the whole table.
in both situation, you should make sure you have set the field link for your main report and subreports so that the record selection function in your subreports would work.

good luck to you!
<本文发表于: 相约加拿大:枫下论坛 www.rolia.net/f >

2001-7-29 -04:00

回到话题: Help. I try to use Crystal Report in VB. But this is the first time. Who has this kind of experiences?

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论