Cross tab field display string not displayed properly 2nd page of the report

[Former Member]

Hello,

I am creating new crystal report, inserting some cross tab reports with multiple pages,

In my example, based on the SAMPLE ID as Row, some other details as columns.

right click Row field and format text  and Click display string, and placing below formula

numbervar x=0;

x:=x+1;

ToText("M " & chrw(48 + x))

If i use cross Tab into my 1st page of the report displaying like M1, M2, M3. what my expectation is right.

the problem is like, If I place same cross tab into in my report  page 2, It displaying like M4, M5, M6

I tried multiple ways to reset the Value of x, But It's working properly,

Even though, i placed into 3rd/4th page, It's displaying M4, M5, M6 only.  I am Not understand where logic get's wrong..!

Please help me how to resolve.

Thanks

[abhilash_kumar · Accepted solution]

Hi Sankar,

How many crosstabs do you have and on what sections have you placed them?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Totally 5 cross tab using inside the report.

These cross tab's are placing Group Header sesction..

Thanks

[abhilash_kumar · Accepted solution]

Instead of resetting the variable x in the display string formula, go ahead and create another formula that reset the variable and place it on the group footer section.

E.g:

Whileprintingrecords;

Numbervar x := 0;

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash..

It's displaying properly,

I struggled lot for this. Thank you very much..

[raghavendra_hullur]

Hi,

Can you explain what you mean by inserting into 3rd, 4th pages?

Do you mean page header/footer sections?

As you will not be allowed to insert a crosstab into page header or page footer sections, you will not be having control over the number of pages the crosstab grows, hence I think page number cannot be reset as Crosstab output will not have page numbers.

Please explain more on your requirement.

Thanks,

Raghavendra

[Former Member]

Hi Raghavendra,

In My Crystal report having totally 5 pages(in Preview).

Each page i am placing one cross tab,

In the Preview screen, Page 1, displayed correctly like(m1,m2,m3..).

and 2nd page inwards displaying M4,m5,m6..

Even tried to same Cross tab table placed into 2nd page of the report. it's getting M4,m5,m6(rows data)

I am expecting results display as such 1st page result table.

Hope you understand my problem.

Thanks