I'm printing a report using ireport tools
Consider there is a table Student which having 4 columns Student-Id, Student-First Name, Student-Last Name, and Student-Age.
In My Student Table Student-Last Name column not contain any values. i want to generate a report in such a way that if any column name not contains any values then that column name shifted to another column name, in place of previous column name.
Student-Id Student-First Name Student-Last Name StudentAge
201 Vinay 24
202 Kishore 26
203 Komal 28
So went I display my report, I want My Student-Age column name come in placed of Student-Last Name .
Output:
tudent-Id Student-First Name StudentAge201 Vinay 24
202 Kishore 26
203 Komal 28
How can I accomplish this?
Please help.
Thanks & Regards