How to page Break in Cross tab


Hi,
    I designed Cross tab reports. it's working fine. in cross tab 1st page showing 12 months. but i don't want to display like that. i want display only 5 months only. it's displaing total months.

how can i resolve that?

Attached sample image here..
CrossTab.jpg
CMANI10Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this idea.

Use the display formula for the group lines (grey color)
WhilePrintingRecords;
Global NumberVar i;
i := 0;
CurrentFieldValue

That should reset the countr to 0 as each new group starts.

mlmcc
0
 
mlmccCommented:
What do you mean a page break?

Is the report just the cross tab?

mlmcc
0
 
CMANI10Author Commented:
Yes, it's Cross tab Report. i want to display first 6 months only in the first page remaining second page.
ie: page wise i need to display only 6months Data.

another one is, How to set Serial or Record number for this Cross tab???
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
CMANI10Author Commented:
Sample File Attached, Cross Tab
0
 
mlmccCommented:
If the dates are a full year you can try this

Add a formula to the report
If Month({YourDateField}) <= 6 then
     1
Else
      2

Add a Group on the formula
Put the cross tab in the group header
In the Section Expert
    Set the NEW PAGE BEFORE for the group header

WHat is the serial number?

mlmcc
0
 
CMANI10Author Commented:
Cross tab returns N no.of rows. i want to give Serial Number or Record Number for the Result set.
here i have attached sample images bellow. i got Serial number for records.

first page will assign serial number correctly , 2nd page again start from serial Number 1.

here i attached 2 images... for you,
how to resolve this??

SerialNo-1.jpg
SerialNo-2.jpg
0
 
mlmccCommented:
WHere are you setting the serial number?

mlmcc
0
 
CMANI10Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.