Report formatting

[swetham]

Hi,
In my report i have,
1) report header where i placed some text objects
2) Group1,group2,group3. In group 3 header i placed one crosstab which has serial nummbers(i have written a formuls for that)
3) In report footer a, I have another crosstab
4) In report footer b, I have another crosstab related to crosstab in report footer b.

Problem is while viewing or exporting the report, when the report goes to next page it is repeating the column names, and in group crosstab, if in before page sno 11,12,13 are there then in next page again it is showing same sno 11,12 instead of 14,15.

How can i resolve those two problems? I dont want column names in next page if the crosstab is split and i want the serial numbers to continue when the crosstab is split

Thanks,
swetha.

 

[hilfy]

As far as I know, there is no way to prevent the column headers from repeating. I just checked in the Cross-Tab Expert and didn't see any setting for that.

As for your serial numbers, what is the formula you're using to calculate it?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[swetham]

I wrote the formula in display string of row field,

whileprintingrecords;
numbervar i;

i:=i+1;
if i<10 then
' '+totext(i,'00#')+'.'+' '+ currentfieldvalue
else if i>=10 then
' '+totext(i,'0##')+'.'+' '+ currentfieldvalue
else
' '+totext(i,'#')+'.'+' '+ currentfieldvalue

 

[hilfy]

Try this instead:

1. Create a running total field that counts your records. I'll call it {#RecCount}.

2. Modify your formula:

Right('000'+ToText({#RecCount}, 0), 3) + ' ' + currenfieldvalue

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

You can suppress the column labels using a formula:

pagenumber <> 1

You could remove the lines around the labels by going into the customize style tab->format grid lines->select the labels lines->uncheck "draw".

The numbering formula won't work correctly because it needs to accumulate whilereading records, and your groups are interfering with that.

-LB

 

[swetham]

in my report for every group the number is continuing like it is 1,2,3,4,etc. but i want the sno's to start from 1 for every group. Is it possible? In the formula given above
Right('000'+ToText({#RecCount}, 0), 3) + ' ' + currenfieldvalue. How can i get the sno if record count is give?

 

[hilfy]

Set the running total to Reset on Change of Group.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[swetham]

I wrote formula for sno in row field in this way

whileprintingrecords;
numbervar i;

i:=i+1;
if i<10 then
' '+totext(i,'00#')+'.'+' '+ currentfieldvalue
else if i>=10 then
' '+totext(i,'0##')+'.'+' '+ currentfieldvalue
else
' '+totext(i,'#')+'.'+' '+ currentfieldvalue

In my formula running total is not there. I want the sno to increment and get reset for every group