i want to create Dynamic report at run time.that is we can create a view at run time  based upon one or mote tables . after that , the report will be displayed from corresponding view .

for example ,
1.Empmaster table having empcode, first name,last name
2.Designation table having designation name
3.grade table having  grade name.

In front end(JSF), i show the three table column.the field selection are only end user (becoz he/she want what ever column)

i give some example below .. please see that..
now we create a view as .......

create view viewname as select empmaster.empcode,designation.desiganationname,grade.gradename from empmaster,designation,grade where empmaser.gradeid=grade.gradeid and empmaster.designationid=designation.designationid

after that , based on view we can create dynamic report at RUNTIME(this is important) . which report we want to be print out or something else . they can do it?
this is my idea..

is there any solution for that one?

anybody knows please tell me ...

with  regards
tamil