Ideas for a specific requirement in cognos 8

[cognos8user]

Hi,

I am looking forward to ideas for a specific requirement that I have.

Description:
Display the column names of a table to the user.
And for all the selected columns I would need to show the maximum(Column) from the actual table.

Say my 'Employee' Table has 500 columns few being:
1) Basic Salary
2) Bonus
3) HRA
.
.
.

Now I have to display all the 500 column names to the user in report studio, user can select one/more values ( this part is fine )

My final output is:

Column Name max min
Basic Salary 80000 50000
Bonus 10000 2000


where max stands for max(basic salary) from employee
where max stands for min(basic salary) from employee

likewise for all the columns selected.

Any Inputs?

Thanks.