![]() ![]() Scroll down until you see the relation indicator.Ĭlick on the table that you want to get related data from - eg Products in this example. The list of fields will then change a little. To include fields from the "one", or "parent" table, choose Related Tables from the popup menu above the field list. The list of fields that initially appears in the Quick Report field list is from the many table. Check with QuiclReport developers if they included exporting TQRChart to pdf file (pdf is generated by using QR engine and not by TeeChart pdf export engine). It's the "child" table in the relationship. If you have Companies and Employees, Employees is the many table. For example, if you have Products and Parts, Parts is the many table. ![]() You must start out with a list of records from the "many" table. ![]() (Please see our Database 101 tutorial for more info about database relations.) In this case, it would be better to create a Publishing Style Sheet and choose the Plain Text option for your Publishing Destination. A many-to-many relationship exists when you have multiple "child" records related to multiple "parent" records - for example, Products and Parts: each Product can have any number of Parts related to it, and each Part can be related to any number of Products. You can include data from a related table in your report, but if you have a "many-to-many" data relationship, this will not work reliably. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |