Combining Rows

[omaha01a]

I am a novice with CR XI.
My report currently shows:
verbiage
year
1 details
2 details
3 details
4 details
etc.
verbiage then new page.

Customer wants the data to be
year
1 details 30 details
2 details 31 details
3 details 32 details
4 details 33 details
etc,

Can this be done?

 

[synapsevampire]

It looks like what you're trying to say is that you'd like 2 columns of data per page, going down then across.

If so, right click the details and select format section, click the multiple columns and you'll see a new tab appear above which allows for tweaking the attributes if need be. Also make sure that you select Down the Across.

-k

 

[Turkbear]

Hi,
There is an option to use multiple columns for the report and you can then specify the order ( across then down, down then across).


See the Crystal help files - search for Multiple Column:
Here is the exerpt:

To create a multiple-column report
Open the report you want to format with multiple columns. 
On the Report menu, click Section Expert. 
Tip:     Another way to do this is to click the Section Expert button on the Expert Tools toolbar.

In the Section Expert, highlight Details, and then select Format with Multiple Columns. 
A Layout tab is added to the Section Expert.

Click the Layout tab and set the Width you want your column to be. 
Keep in mind the width of your paper when deciding your column width. For example, if you have three fields in your Details section, and they take up four inches of space, limit the width of the column to under four and a half inches so that all the field information can be seen.

Set the Horizontal and/or Vertical gap you want to maintain between each record in your column. 
In the Printing Direction area, choose a direction. 
If the report you're formatting contains grouping, select Format Groups with multiple column. 
Click OK.

Hope it helps..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[omaha01a]

Thanks this works, except I have a little twist. This is a group, but there is a footer that needs to appear on every page of numbers. If I do a detail, then the multiple columns duplicates it. If I do a group footer, it only appears at the end of the group.

Any ideas?

 

[lbass]

You can still set the details section to multiple columns and then in the layout tab be sure to check "format groups with multiple columns". Suppress the detail section.

If you need text at the bottom of each page, then it belongs in the page footer, not a group footer. If the "footer field" is meant to be a page summary, then you need to use formulas to summarize what's on the page, with a reset in the page header, an accumulation formula in the group section (or details, depending), and a display formula in the page footer. Please clarify.

-LB

 

[synapsevampire]

Not quite clear what "but there is a footer that needs to appear on every page of numbers" means. Do you mean every page, or on some numbered pages?

As LB points out, you can use page headers and page footers for some data/text, and if you right the group header you can use repeat group header on each page, but since you're getting into discussing this level, you should go ahead and clarify what you're dispolaying and where it sould display on each page, or which pages.

-k

 

[omaha01a]

I think we're going without the multiple coumns. But, this is what I'm doing trying to do. The final output is a financial sales proposal which is given to the customer as a paper document. It can have up to 40 pages. In this document are pages of verbiage defining what's going on, then several different sections which are pages of sets of numbers from a dynamic source. For instance, the first set of numbers could be what the basic numbers mean, the second set of numbers could be additional information for other members of the family, business, etc.
The groups of numbers require a different heading and different footing than the straight verbiage, but then there is verbiage at the end with the same heading information. The same footer appears at the bottom of each of the pages, however, the pages with the number data require legislative mandated wording at the bottom of each one of them.

 

[lbass]

This is a little hard to follow, but you could consider adding the data that you want in columns in a subreport which is formatted for details/groups in multiple columns, so that you can maintain the group structure (no columns) in the main report--if that helps address your issue.

-LB