repeat on horizontal pages crystal report

You should check the “suppress subtotal” property for this group level so that it doesn’t generate duplicate totals (cross-tab Expert, customize style, highlight this formula and check the property on the left). You make this field the first “Column” field in the cross-tab. This makes it eligible to be used as a cross-tab column. The key is that the formula has to start with WhileReadingRecords. 'Orders From: ' & ToText ( Minimum ( ), 0, '' ) 'Sales by Region and Shipping Mode' & Chr(13) & This title can incorporate parameter fields and can also include a carriage return character to print on multiple lines.

Checking this property will cause the object to print again automatically for every horizontal page.Ģ) If you want the title to be part of the cross-tab, you can put your title into a formula and use that as your first column field. You should see a property called “Repeat on Horizontal Pages”. Right-click on the field, select “Format Field” and go to the common tab. You have two options to get the titles to repeat:ġ) If you want the fields to appear outside of the cross-tab, you can format them to repeat on each horizontal page.

So, any titles that you have in your page header will be missing on these horizontal pages. However, page header objects do not automatically repeat on these pages. If you were to print the report to paper, these horizontal pages would print as separate pieces of pages. When a cross-tab gets too wide, it generates a ‘horizontal’ page to the right of the original.

Repeat on horizontal pages crystal report