Crystal Report and Datatable
Posted on 2006-11-16
I have a Crystal Report which I designed by importing an access table and selecting the fields i wanted.
The actual report is generated not from the access table, but from a datatable which is filled from a query on the access table and others
The problem is the DataTable has a couple of extra columns which are added separately before the DataTable is used as the crystal report datasource
The extra column names do not exist in any database, but I know what they will always be named. How can I add report fields in the Crystal report to take the data from these extra columns, without having to design an access table with the extra columns and appropriate field names, attach the access table to the report to design it using the extra fields, and then takeg the fields out of the access table again or simply delete the access table, as the data will always come from a datatable generated on the fly. I have tried adding unbound formula fields of the same name but i just get blank entries,. Is their a way to add fields to the crystal report similar to database fields so that the crystal report will recognise all the columns in the DataTable?