individual records into same line 1

[stevesd]

I need to eliminate most of the detail lines in a report because the result gives more lines than our server, sometines even Excel can handle. The situation is that I am displaying several items per account and each generates a line in CR so each takes a line in the resulting spreadsheet. If I could line up the items horizontally instead, I could have many less lines.
example
1. Acct1 / date1 / amt1
2. Acct1 / date2 / amt2
3. Acct1 / date3 / amt3
4. Acct1 / date4 / amt4
If I could make it display,
1. Acct1 / date1/ amt1 / date2/ amt2/ date3/ amt3/ etc
It would give the detail I need without blowing through all the excel lines!
One fine sticky point: I don't know in advance how many items and amts any account will have. Some will have one and others more.

 

[kskid]

If you tried the Keyword Search Tab, you would have found your answer.

See thread 767-563497 on multiple items on one line or
thread 767-692825 if you are concerned with duplicates

 

[kskid]

By the way, to go directly to the thread, enter

thread767-563497

in the Search area at the top of the screen and click go.

If you use the Keyword search tab to enter the thread, you will come up empty handed.


By the way, is there a way to insert the thread link directly in a reply?

 

[stevesd]

I didn't find any way within the structure of the reply 'box' to insert a link to the thread. Your tip on how to enter it was the way in. I admit, tho, that that tip was too technical for me. Can you tell what it does and try to break it down step by step. I realize it would be a lot of work to do that. I am having trouble following the logic in there.

 

[lbass]

You might try grouping on account, and then placing only the date and amount fields in the detail section. Then go to format->section->details->and check "format with multiple columns." Then choose the layout tab and choose "Across and then down" and also experiment with the field widths until the details repeat as you wish. You should probably check "format groups in columns", too.

What I'm not sure about is how well this translates when exporting.

-LB