Wrapping data to another column and not next page

[jveglia]

I am using Crystal 8 and linking using ODBC. I need to create an sales order form that prints a list of items in column A and any items above the page length print in column B. Currently, Cystal will print the additional records on Page 2 of report.

Some background: The customer is the main grouping for the report and the order form will print for all customers and not just one at a time. The amount of records will change by customer depending on the items purchased in the previous year.

Any ideas on how to approach a report in this format?

Thanks for your assistance.

John

 

[kenhamady]

Try formatting the details to be multiple columns (Format - Section, Highlight Details, check off the check mark at the bottom right). You will get a layout tab that allows "down then across". Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[blues4evr]

I have a similar situation but need to print data in multi-columns on a sub report within a defined area. I've tried the multiple columns/down then across but don't seem to have any success. Any suggestions?

Thank you for your assistance
Ken

 

[Ngolem]

yes...you can do it the old way....before Crystal 8.0 came along.

What I did was not print the details in the detail line...but rather I stored them in an array. As long as there are less then 1000 values this works fine. (using arrays is a tiny bit easier now)

I would first have an initialization formula

whileprintingrecords
stringVar array x := make array["","","",......,"",""];
numberVar arraycount := 0;


then in the detail line I would have a calculation formula that was suppressed if other details were displayed or I suppressed the whole detail line.

whilePrintingrecords;
stringVar array x ;
arraycount := arraycount + 1

x(arraycount) := {field one};


Now in the footer I would put as many display formulas as was necessary.

NOTE: your display can only contain 254 characters . so let us say each element of array x is 4 characters then if I had 1 display formula for x and another for y then I could have 254/4 = about 63 array elements displayed so let's round it to 50 elements for simplicity

so one display formula would be

whilePrintingrecords;
stringVar array x ;
stringVar result := "";
numberVar i := 1;

while i <= 50 and x(i) <> &quot;&quot; do
( result := result + x(i) + chr(13) + chr(10);
i := i + 1);

result;

the next one beside it would be
similar with i starting at 51 and ending at 100

you get the idea....put &quot;can grows&quot; on the display formulas

that ought to do it...unless I made a syntax mistake in the &quot;while&quot;

jim

 

[blues4evr]

wrapping data into columns is explained in detail at:

http://support.crystaldecisions.com/kbase/c2006953.asp?AJID=F9CB7379FA30B1