Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Return data in a Column format

Experts,
What is the best method (using Crystal 9) to display report data in a series of 3 columns?
The report is a deposit slip.  One column set would include (payee, check number & check amount).  When the quantity of rows exceeds column set 1, the next record(s) should roll to column set 2, then column set 3.
I don't have any problem returning the data in one column set.  The main problem is rolling the records to the next column set on the same page.
See my mock up in attached excel.  I tried cross tabs w/o success.
I'll award points best I can.  I hope you can provide the theory and get me started.
 Mock-Deposit-Slip-for-Experts-Ex.xlsx
0
LFreehauf
Asked:
LFreehauf
  • 4
  • 4
1 Solution
 
mlmccCommented:
Crystal can use multiple columns which should do what you want.  However, the limit on the column height is the page height so you can't get it to move after say 5 records.

How many records do you want in a column?
mlmcc

0
 
LFreehaufAuthor Commented:
Hmmm  10 line per column set.  
I guess the attachment is still a pretty good viasual.  I'd like to get (approx) the first ten lines in column set #1.  The next 10 lines on column set #2, the next 10 on column set #3
0
 
mlmccCommented:
Would that be 1 page?

mlmcc
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
LFreehaufAuthor Commented:
Yes.  It's one page.  
The current system generates an 8.5 X 11 page that is perforated to generate 1/3, 1/3 & 1/3 "Check sized document" that can run through a MICR check/deposit slip scanner.  I'm trying to duplicate said document.  I think I can make the data repeat 3 time on the 8.5 x 11.  It's the Column set issue that I can't fix.
0
 
mlmccCommented:
Is it perforated horizontally so you have 3 pieces as shown?

So long as you are willing to have the left column fill before moving to the middle column then the multiple column idea wll work.

I think you may have to use 3 subreports to get the data to repeat 3 times on a page.

mlmcc
0
 
James0628Commented:
Are you actually trying to repeat the data, or when you say "repeat 3 time", are you really just referring to filling each third of the page, but with different data in each third?

 I'm guessing that it's the latter, where the first column would go down the first third of the page, then the second column would start and fill the first third of the page, then the third column, and then the first column in the second third of the page would be started, and so on.  Something like the following.  I'm using 3 lines for each third of the page, instead of 10, for simplicity.

 1   4   7
 2   5   8
 3   6   9
-- perforation --
 10   13   16
 11   14   17
 12   15   18
-- perforation --
 19   22   25
 20   23   26
 21   24   27
-- end of the 8.5x11 sheet --

 Is that what you're looking for?

 If so, you might be able to use a subreport for each third of the page, with each subreport producing a different set of records.  For example, the first subreport produces the first 30 (10 rows in 3 columns), the second subreport the next 30, and so on.  The trick there is what happens when you have more than a full page of records (90, in this example)?  You might just have to make sure that you include enough subreports to handle the maximum number of records that you could have.

 Another option might be to use variables instead of subreports.  For example, you'd save a list of the payees in one variable, and then have formulas that output the first 10 values for the first column, the next 10 for the second column, and so on.  As with the subreports, you may have to make sure to include enough formulas to handle the maximum number of records that you could have.

 James
0
 
LFreehaufAuthor Commented:
To answer Jases0628's question:  Not latter; first.  They seperate the perforated paper (one goes with checks to bank, one for internal accounting filing system, 3rd to owner)

mlmcc:
1.  Regarding your comment: "I think you may have to use 3 subreports to get the data to repeat 3 times on a page."  I understand.  I think I'll be good with that.
2.  Regarding your comment: "So long as you are willing to have the left column fill before moving to the middle column then the multiple column idea wll work."   - I guess I'm dumb.  I hear the column idea will work.  However, I don't know how to execute (or obtain the 3 column sets; with the 1st (left) column set filling first, then the 2nd column set, then the 3rd column set).

The end users advised that the existing system/report never generated a quantity of deposits that made a forth column or 2nd page necessary.
Thank you for your help.
Please adivse how to execute the "Column sets"

0
 
mlmccCommented:
Crystal handles it for you.

You format the detail section to use multiple columns.  You just have to set how wide.

Right click the detail section in the left margin
Click SECTION EXPERT
Click the check box FORMAT DETAIL SECTION WITH MULTIPLE COLUMNS
A new tab will appear, click it
Set the column width to 1/3 the width of the page

You can then format the column the way you want and Crystal will create 3 columns

mlmcc
0
 
LFreehaufAuthor Commented:
Outstanding
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now