I have a relational schema in which there is a table for each business type(say Part, Document). Each of these table's columns are defined by the attributes defined for the given type. i.e, if Part has the following attributes - Part #, Category, Description and Unit, the Table called PART will have four columns - PART # ,CATEGORY , DESCRIPTION and UNIT. Similary for other business objects , the columns will differ. I need to give the user, the ability to define the reports at run time. i.e user will be provided initially with a list of all business entities. Once he chooses the entity(say PART), he will be subsequently provided with a list of attributes for that entity(in this case, it will be the list of 4 attributes on PART). User can choose one or more attributes and the report will be displayed with those attributes as columns. Hence in this case,  the final structure of the reports in terms of the number of columns will be decided only at run time

 

I am new to crystal reporting and with the investigation done so far, I believe it can be achieved using a combination of formula and parameters. Any help in this regard is appreciated.

 

Thanks in Advance,

Sumesh.