adrianzazugmail.com Posted November 27, 2017 Share Posted November 27, 2017 Hello, good morning, I have a lot of experience in handling Ireport, what I need to do is a report where I use several fields, when making the query if there is more than one record in one field, register1 and in another record2 and so on. I will try to be more specific:this would be the page of my report:+++++++++++++++++++++++++++++++++++++++++++++ register1 register3 register4 ++ register2 register5 register6 ++ ++ ++ ++ ++ ++ ++ register1 ++ register2 +++++++++++++++++++++++++++++++++++++++++++++First of all, Thanks Link to comment Share on other sites More sharing options...
hozawa Posted November 27, 2017 Share Posted November 27, 2017 Not sure what you are asking so not sure if this will answer your question. It's not possible to have a field show different records, but it's possible to overlap fields and use print when expression to set which field to display on a report. Link to comment Share on other sites More sharing options...
adrianzazugmail.com Posted November 28, 2017 Author Share Posted November 28, 2017 Thanks, I want to make a report with fields with the same name, only if the record has more than one record, write the first register in one field and the second in another.Example:The query SHOWS ME THE FOLLOWING LINES.FIRST NAME:1.- PETER2.- JHON3.- HOZAWA4.- ADRIANZAZUin my report I want this: +++++++++++++++++++++++++++++++++++++++++++PEATER HOZAWAJHON ADRIANZAZU PEATER(sign) JHON(sign)+++++++++++++++++++++++++++++++++++++++++++If is it possible?First of all, Thanks Link to comment Share on other sites More sharing options...
rpaderes Posted April 24, 2018 Share Posted April 24, 2018 Use sub-select in your SQL. Sample:select rownum,(select name from table where rownum = 1) as field_1,(select name from table where rownum = 2) as field_2,(select name from table where rownum = 3) as field_3,(select name from table where rownum = 4) as field_4from tablewhere rownum = 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now