Showing multiple columns in Report

Question

Hi
 I have a  situation, i need ur help
I have a report showing just EmployeeCode in crystal report
i need to show EmployeeCode with 4 columns in a row.
How to do this please help

regards
James

---

Beginner

Answer 1

In the Detail Section Enable Format with Multiple Columns an additional Layout Tab will be opened. Select the options as required.

Then drop the column which required to be print in multiple columns.

Answer 2

hi
thx for the reply
but i didnot make myself clear
this is wat i want

i need to show barcode of assets[Field name : SerialNo] in crystal report.
I put the serialno in details section and the data showed in vertical fashion [One serialno below the other]
eg:
AP12345
AP12346
AP12347
AP12348
AP12349

but i need it horizontally like

AP12345       AP12346           AP12347       AP12348       AP12349
AP12350       AP12351           AP12352       AP12353       AP12354
AP12355       AP12356           AP12357       AP12358       AP12359
AP12360       AP12361           AP12362       AP12363       AP12364
AP12365       AP12366           AP12367       AP12368       AP12369

regards
James

---

Beginner

Answer 3

i'm not sure how to do that in crystal ... but if you're using a sql stored procedure there's always a work-around

you could write a sql cursor or something to condense your records and make every 5 items go into one large row instead

example:

for each item in #originalTable
     declare @NewRow varchar(2000)
     set @NewRow = current item in #originalTable
     move cursor to next row (row #2) in #original Table if there is one
     set @NewRow = @newRow + '    '  + current item in #originalTable
     move cursor to next row (row #3) in #original Table if there is one
     set @NewRow = @newRow + '    '  + current item in #originalTable
     move cursor to next row (row #4) in #original Table if there is one
     set @NewRow = @newRow + '    '  + current item in #originalTable
     move cursor to next row (row #5) in #original Table if there is one
     set @NewRow = @newRow + '    '  + current item in #originalTable
  
     insert @NewRow into #newTable
end

select * from #newTable




forgive my shorthand ... i didn't feel like writing out the full code for a cursor

Then all you'd have to do in Crystal is print out that new dataset

Answer 4

James,

Did you select the "Acrcoss then Down" option? Maybe I don't understand the problem.

Answer 5

joe, where do i find that "across then down" option ... thanks