Jump to content
We've recently updated our Privacy Statement, available here ×

How can shifted column-name in place of previous column name when column not contains any value


anwarzamal25

Recommended Posts

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                                                StudentAge
    
    201                                                            Vinay                                                                         24
    
    202                                                          Kishore                                                                      26
    
    203                                                             Komal                                                                     28

How can I accomplish this?

Please help.

Thanks & Regards

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...