6 replies
Are the three tables related by means of primary key/foreign key relationships? If so, you can create a ADO datashaped recordset either through code or through Data Environment. You then establish a heirarchy based on a predefined relationship amongtables. You then use Groupings in your Data Report depeding on the heirarchy of your data. For example, you have three tables, table1 related to table2 (one is to many) and table2 related to table3 (one is to many). You put the data of table 1 in your header, the data of table 2 in your subgroup (you create that group), and the data in table3 in the details section. You use the datamember property to indicate which data command (or which part of the heirarchy) the group belongs to.
Also you may want to check out the Crystal Report Designer, which offers a lot more functionality than the simple data report.
hope this helps.
by miss kitty
If you are using VB 6.0 Professional, Crystal Reports shipped with it but does not install when you install VB. You have to go into Windows Explorer; look at the VB cd and find Crystl32.exe; and double click on it. After you install it, go into Crystal and run the report wizard. It will guide you through setting up your report. After you have got your report set up correctly, email me and I'll send you an example of VB code to call in the report. Crystal is geared toward Sql and Access reporting not at all like Data Report.
Cathy
covcat@riverstonegrp.com
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending