Re: Ace report question

In-Reply-To: <20490009@hpspkla.spk.hp.com> mills@hpspkla.spk.hp.com (Terence J. Mills) In article <20490009@hpspkla.spk.hp.com> Terence J. Mills writes: > I have a question regarding the Ace report writer in Informix SQL. I am trying > to generate a multiple column report that has repeating columns. For example, > the columns might be: > > COL1 COL2 COL3 COL4 COL1 COL2 COL3 COL4 > > When I run this report, I get duplicate values in the identically named > columns. For example: > > 1 2 3 4 1 2 3 4 > 5 6 7 8 5 6 7 8 > > What I desire is to format across the page. The previous data would be printed > like: > > 1 2 3 4 5 6 7 8 > > How can I do this with Informix Ace reports? I have isql, esql and 4gl > available. I prefer to use the isql solution if there is one. My immediate thoughts are to do something like this: define colnumber int variable col1_1 <type> variable col2_1 <type> : : variable col1_2 <type> variable col2_2 <type> : : end then in your format section page header let colnumber = 1 on every row if colnumber = 1 begin let col1_1 = {whatever from your select statment} let col2_1 = : : let colnumber = 2 end else begin let col1_2 = let col2_2 = let colnumber = 1 print col1_1, col2_1,..., col1_2, col2_2,... end I hope this helps. -------------------------------------------------------------- | Who cares whos opinions these are?! | | Send me mail and I'll love you forever (Maybe) | |------------------------------------------------------------| | Stuart Hemming | shemminga@cix.compulink.co.uk | | Tudor Labels Ltd | uunet!cix.compulink.co.uk!shemminga | | Roman Bank Bourne | Tel : (+44) 778 426444 | | Lincs PE10 9LQ. UK. | Fax : (+44) 778 421862 | -------------------------------------------------------------- Stuart |8-)