Yes. Create the report ahead of time with a dummy table, name the fields something like Col1, Col2, Col3, etc. Then when pulling the data, use a SQL SELECT and rename the fields to the same Col1, Col2 using the AS statement of SELECT.
>Hi Guys,
>
>Is it possible to dynamically generate a Crystal Report based on dynamically selection of fields? The idea is to give the users the option to choose from a list of fields and stores this information in an xml file. The program will then read the xml file containing the name of the field the postions and then dynamically generate the report.
>
>is this possible?
>
>Thanks in advance...
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer