how to make my crystal report can split by 2 coloum 1

[bantakiah]

i want to make my report have 2 coloum and if the record continues in coloum 2 it will repeat the coloum title in coloum 1. like this


A b |A b
1 2 |1 2
1 2 |1 2
1 2 |1 2
end of page

the A and b refer to my coloum title and 1 and 2 refer to my record and end of page refer to end of page and my record continues in next coloum

thanks

 

[dgillz]

What version of Crystal?

I believe you can acheive the desired effect by formatting with multiple columns.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[IdoMillet]

Detail section, Section Expert, turn on "Format with Multiple Columns", a new "Layout" tab appears...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Let's assume you are using formatting with multiple columns. In order to get labels at the top of each column you would always have to have the same number of records per column (except for the last column). Place a formula in the detail section like this:

whileprintingrecords;
numbervar cnt := cnt + 1;

Notice the count per column. Then insert a detail_b section and in design mode, drag detail_b so that it becomes detail_a. In detail_a, place your column labels.

Then you would select each column label->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar cnt;
remainder(cnt,40) <> 0 //if 40 is the column record count

-LB

 

[bantakiah]

how i put this? im page new after or what?

whileprintingrecords;
numbervar cnt := cnt + 1;
if i use line to the coloum title how i can hide this line and coloum title in coloum 2

 

[lbass]

You create that formula in the field explorer->formula->new and then place it in the detail section. My earlier suggestion will result in the column title repeating in column 2. I don't understand your last sentence. Do you mean you want a line dividing the columns but it is repeating to the right of column 2--and you don't want that?

-LB

 

[lbass]

I just inserted a line that ran from the page header through the detail sections and it only appeared once on the page, as you seem to want to do.

-LB