Yes, you can do that with Crystal Reports. There are a couple of ways you can approach it:
- Completely design the report in code. However, this requires additional licensing and royalty payments to Crystal Decisions.
- Give complete WYSIWYG design to the user. This also requires additional licensing and royalties.
- Have a report template that names the fields, Field1, Field2, etc then map those to the actual data selected by the user.
>I pretty unfamiliar with crystal reports. Can crystal reports be used to configure report fields dynamically?
>
>My company wants to allow users to select, from a list, database fields they want to see on a report. They will also have the ability to determine selection criteria.
>
>I'm not concerned about the selection criteria aspect of this. I've looked into Crystal and seen a few examples using datasets, so the selection criteria can be handled in the dataset creation/fill.
>
>However, I haven't seen any tools with Crystal that appear to allow a report to be dynamically created/modified (add specified database fields to the report). It seems that all reports are created as static files, as far as the displayed data is concerned.
>
>My boss seems to think this can be accomplished using crystal. Am I missing something?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer