Print Data Horizontally 1

[haydn]

I know this is probably horribly elementary, but despite playing with the 'Layout' settings in detail > format, I can't quite get it right. The problem is very simple. I have a detail line with job numbers and associated job statii. It's those job status values I want to print horizontally. I'm using 8.5. For example:

Now:

Job No Status
12345678 0
1
3
98765432 0
2
3
4
etc

I would like:

Job Number Status
12345678 0 1 3
98765432 0 2 3 4

and so on.

 

[synapsevampire]

Here's a cheat that will work, providing the length of the combined statii per row doesn't exceed 254 chars:

Group by Job Number

Add in 3 formulas:

Group Header:
whileprintingrecords;
stringvar Statii :="";

Details;
whileprintingrecords;
stringvar Statii := Statii+{table.status}+" ";

Group Footer:
whileprintingrecords;
stringvar Statii

You now display everything at the Group Footer level.

-k

 

[pgtek]

hi

read this thread

faq767-995

cheers

pgtek