create dynamic report to change no. of columns based on parameter
Hello,
I've one table which is contain 96 columns and I want to generate one Dynamic report based on this table so, based on parameters passed it will select some columns only from the table or select all columns.
So, for example I can pass 'empno, ename, hiredate' to display these columns only or pass more up to 96 columns it will display whatever columns I passed in the parameter
Any one know how to accomplish this task.
Thank you