Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wrapping data to another column and not next page

Status
Not open for further replies.

jveglia

MIS
Mar 26, 2001
13
US
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
 
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
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top