Format Problem with Exporting to PDF on Eportfolio

[BeeBear]

Hi There,

I use Crystal Reports 10, and Eportfolio 10 (Crystal Enterprise 10) to publish the reports.

I have a report that is run in Eportfolio as a PDF file (Adobe), but when the report runs, one of the fields changes format on me.
This only happens if you run it in Eportfolio - if its run in CR10 and exported to PDF with the little envelope, it stays the same.

The fied that changes is a result of a formula below, and is a string field displayed to look like a time HH:MM
It changes to be: HH.hh:MM.mm, but they want it to stay as HH:MM

Here is the formula:

local numbervar TimeAvail := if isnull({#Actual Time in Minutes}) then {prehearing_limits.max_limit}
else
{prehearing_limits.max_limit}-{#Actual Time in Minutes};

if TimeAvail <10
then "00:0" & TimeAvail
else
if TimeAvail <60
then "00:" & TimeAvail
else

If TimeAvail = 60 then "01:00"
else
(If Remainder(TimeAvail,60) = 0
then
("0" & (TimeAvail/60) & ":00")
else
("0" & truncate((TimeAvail/60),0) & ":") & Remainder(TimeAvail, 60))


Basically, what the formula is doing, is working out the time still available to be allcated to sittings.

The Running Total {#Actual Time in Minutes} totals the time that has already been allocated, by summing a number field that shows the time in minutes
The {prehearing_limits.max_limit} field is a number field showing the total amount of time that can be allocated (usually 360 - 6 hours)
If the RT is null or nothing, then just show the {prehearing_limits.max_limit} number, else work out whats left by taking the RT from the prehearing_limits.max_limit}

The rest of this formula converts it to hours and minutes.

Can someone tell me how I can make this formula display in the correct format in the PDF when run on Eportfolio?

Let me know if its clear as mud, and if you need any other info.

Thanks



regards

BB

*** Count your blessings not your problems******

 

[MJRBIM]

What happens if you run the report in ePortfolio to the default "Crystal Report" format...?

Does the date format show-up correctly when you view that instance from HISTORY ..?

What happens then if you export from the CR-Viewer to PDF...?

 

[BeeBear]

To answer all your questions:

1. I just ran the report through Eportfolio as a Crystal Report format report, and it still changed the formatting to 00.00:00.00 instead of 00:00

2. When I export the Crystal Report from the History Viewer of Eportfolio to PDF, it still keeps the bad formatting detailed at #1.

3. I noticed something else too - if the Minutes portion is 00, Eportfolio DOESNT change it to 00.00 format, only if its say 10 minutes it changes to 10.00

So, the problem appears to only be when the report is run through Eportfolio - regardless of the report format.

OK - New bit I just found out.

I just went into Crystal Reports, and opened the CRYSTAL REPORT FORMAT instance I ran in Eportfolio (at #1 on this email). Now although this instance DISPLAYED the HH:MM in Eportfolio as HH.00:MM.00, when I opened it in Crystal Reports, it has reverted back to the correct HH:MM formatting.

Leads me to believe it has to be something specific to the Eportfolio server?????

Weird!

Would love to find a solution to this, but in the meantime as its an 'urgent' fix for publication next Monday, I'm going to do a fudged work-around in the meantime.



regards

BB

*** Count your blessings not your problems******

 

[MJRBIM]

It might be a local-preference setting on the Windows OS on the BOE-server.

What account do your BOE services run under...?

 

[BeeBear]

I have absolutely no idea whatsoever! I know we don't have a BOE server, we have a Crystal server (pre-BO).

I am tempted to call the team who is meant to maintain the server, and see if they can look into the problem and fix it, but as I have managed to build a work-around, by dumping the formula field into an empty text box, I might just leave it as if they change the wrong thing (as is very possible), it could stuff up other reports.

Thanks for your help though!

regards

BB

*** Count your blessings not your problems******