Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: 'The String is non-numeric' issue Post Reply Post New Topic
Author Message
Moki
Newbie
Newbie
Avatar

Joined: 15 Dec 2008
Location: New Zealand
Online Status: Offline
Posts: 1
Quote Moki Replybullet Topic: 'The String is non-numeric' issue
    Posted: 15 Dec 2008 at 2:55pm
Hi,
 
I'm having an issue getting some very simple Crystal XI reports up and running on BOXI. The reports run just fine standalone with the Crystal client but doesn't run when setup as a scheduled reports in BOXI.
 
Quite simply, I have a field in an Oracle db that identifies a transactional date in the YYYYMM format (e.g. 200811) and the datatype is numeric.
 
All I'm trying to do this set the runtime date parameter when the report is run as scheduled - currentdate - and use this to compare and report on the previous months transactional records. 
 
tonumber(totext(currentdate))-1             should equal 
 
PrevMonthTransDate = 200811
 
Of course, end of year would pose a problem when the year changes
--
However, when I set the report up to run in BOXI it fails with message currentdate 'The String is non-numeric'.  I've found vague indications that this is down to the BOXI server needing a patch of some sort. 
 
Anybody come across this before?
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.