Combining Values from Different Tables

[O2BNSV]

Using v2008 or vXI, is it possible to combine values from several different tables into one field from which a group can be created? I work with a database that has "attributes" which are essentially user defined fields. When I report directly off the back-end tables, all these attributes live in one table called attributes. However, so that all people in the organization can use certain reports, I have to use the custom report writing module which exports data into an access database. I create reports off of those access databases. When exporting attributes this way, it exports each individual attribute in a separate table. I am trying to create a subreport that has one group on the attribute type with the detail being the attribute description to avoid having to create a subreport for each attribute that shares values to the main report. The other limitation is that I cannot use the "add command" feature, nor can I use alias tables. I can only use the data that is exported in the way it was exported.

 

[IdoMillet]

Create a UNION query in Access and use that query as the data source for your report.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com