Crystal reports export error

typo above---->   customer formula = CUSTOM formula

It is not a formula field.

PAGE # is just a text box placed directly in the Page Header
After that I place the "Special Field" Page Number also directly in the header

Have you tried removing the field and adding it back in again? I looks like you have the "Total Page Count" field appended to the "Page Number" field.

Failing that try creating a Formula like this:

shared numbervar pages;
pages:=pages+1;
pages


Add it to the page header and you should see it show the page number. It just basically increments a user defined varible called "pages" every time it is displayed.

Hope this helps.

Jon

Jon,

Thank you for responding. We have over 200 reports which are generated using a set of parameters to a total of 20000+ exported files - so it is not an issue of having placed TotalPageCount by accident.
I have tried a few things including shared variables, placing the special field Page Number in a text field and also in a formula field.

But for some reason the page count shows up randomly in any of these cases

Does it happen if you run the report manually in CR or just when you run it using the .net service?

Jon

Try this.

Make a copy of one of the reports
Open the copy
Delete all fields from the PAGE HEADER
Insert the special field PAGE NUMBER
Display the report

What do you get?

mlmcc

It does not happen when I export the report manually from the CR designer. It only happens from the .NET service and that too, for some reports at some times. A report may run just fine in one run and then this problem shows up in the next run.

Are the runs made from the same machine?  Using the same printer?

mlmcc

Yes from the same machine ( a W2K3 enterprise server). There is no printing tho.. the output is just a text exported file

Does the default printer change? or could it?  Crystal uses the default printer to help in the rendering of the report thus if the default printer changes it could affect how a report looks.  For instance if you change to a dot matrix printer you might get that result for a bold field since bold is done by printing the text twice.

mlmcc

Yes the reports are designed against a printer that the server does not have access to - so that may be an inssue there.

Since we do not need the print function from the reports, do you think it may be wise to use the "No Printer" option available under Page Setup

Thanks

Tried the following with  NO PRINTER Option selected, but the problem presists -
 
1:

Declared a shared & incremented in the PageHEader section. Same variable refered in a separate formula field  as "Page#  " + cstr(@SharedPageNum)
 
2:

Page number(spl field) directly inserted in to the PAGE # text field with required spaces in between.

Not sure what the NO PRINTER option does.  Crystal may have a generic driver it uses.  I know it means you cannot print.  I tried changing a report to NO PRINTER and  The preview changed.

Try taking you fields out.  Do you get a page number?

mlmcc

I also tried the reports by adding the same n/w printer on the server (where reports run) as the one that I designed the reports from my desktop. Didn't help.

I did take the field out and from what I could tell, it did not print the Total Page count then. But since it anyway occurs at random, I will give it another try.

I had also posted this issue on BusinessObjects support forums. Did not get any response. Do you know if there is way to get any support from them without having to pay for it (I will leave that as the last option)

If it helps, this is the formula I am using to print the Page number in the Page Header now -
(where page is a shared variable that I increment in the page header)

StringVar Page_Num;
NumberVar page_len := length(split(cstr(shared numbervar page),".")[1]);
StringVar page_no :=split(cstr(shared numbervar page),".")[1];
StringVar PageNum := split(page_no,",")[1];

if(page_len > 4) then
PageNum := PageNum & split(page_no,",")[2];
(
select page_len
case 1 :
    Page_Num := split("PAGE #          ;",";")[1] + ltrim(right(PageNum,1))
case 2 :
    Page_Num := split("PAGE #         ;",";")[1] + ltrim(right(PageNum,2))
case 3 :
    Page_Num := split("PAGE #        ;",";")[1] + ltrim(right(PageNum,3))
default :
    Page_Num := split("PAGE #       ;",";")[1] + ltrim(right(PageNum,4))
);

Appreciate your help

>>Do you know if there is way to get any support from them without having to pay for it
We got some but that was shortly after we had purchased Crystal and for the most part pertained to problems installing Crystal.

How is Page being incremented?  What does it contain?

mlmcc

Using this formula in the page header

shared numbervar page:= shared numbervar page+1;

Try it this way

WhilePrintingRecords;
shared numbervar page;
page := page + 1;

mlmcc

I can try it that way, but the issue is not with the value of this variable. If I print the value elsewhere in the report (other than the Page header section) it displays the correct value. Even in the Page header the value itself is correct in the .rpt export. The problem shows up only in Text export

Samit

Change this one in a similar way

StringVar Page_Num;
shared numbervar page;

NumberVar page_len := length(split(cstr(page),".")[1]);
StringVar page_no :=split(cstr(page),".")[1];
StringVar PageNum := split(page_no,",")[1];

Since page is a number why are you converting to a string?  What is the SPLIT for?

mlmcc

Will appreciate if you can close it please.
Thank you