on 05-23-2013 2:52 PM
Hi Everyone,
I got a report with a date parameter which enables the user to select a single date
however the user selection should pull in the data for the fyscal year by month
so I've created to formulas as follow:
@FYStart:
cdate(year({?Date})
-(if month({?Date})<7 then 1 else 0),7,1)
@FYEnd
cdate(year({?Date})
+(if month({?Date})>=7 then 1 else 0),6,30)
and I've declared the following in the record selection:
{billing_tx_history.date_of_service} >= {@FYStart}
and
{billing_tx_history.date_of_service} <= {@FYEnd}
The report works fine on my local but once I deploy it to the WebApp which is a Web-portal called AVATAR and try to run the report from there I get an error msg saying that:
"Date or number or currency is required here"
and I think the problem that the two formulas above were created using IF function which returns Boolean
Any help would be appreciated
Hi Mohamed,
Try modiying the Record Selection to:
if(month({?Parameter}) >= 7) then
{billing_tx_history.date_of_service} IN
[cdate(year({?Parameter}),7,1) to cdate(year({?Parameter})+1,6,30)]
else
{billing_tx_history.date_of_service} IN
[cdate(year({?Parameter})-1,7,1) to cdate(year({?Parameter}),6,30)]
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As this is happening in a web app and assuming this is a .NET app, I moved the thread to the
SAP Crystal Reports, version for Visual Studio SCN Space.
How are you passing in the parameter? Are you using the CR parameter prompt screen or APIs?
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
Indeed, I’ve removed the CR 2008 new functions based objects from the report and then the report worked just fine in the WebPortal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I believe that the following applies to my case:
Error: A Number, Currency Amount, Boolean, Date, Time, Date-Time, or String Is Expected Here
Explanation: In general, this happens when you're running a Crystal Reports template that was created on one machine, that the report developer used a custom DLL to create the report (in a formula field), and those DLLs were not copied/installed/registered on the machines running Report Runner Viewer or Report Runner Batch. The custom DLLs are normally stored/registered in the Windows Crystal directory.
In short, it means your report is trying to use a function that the Crystal Reports runtime engine does not recognize.
You can also get this with version incompatibilities. For example, if you were to run a Crystal Reports 2008 template in Crystal Reports XI, there are a few new functions to 2008 that XI doesn't know how to run.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohamed,
The record selection formula I supplied does NOT use any Custom DLLs. It uses native CR functions. I don't know what AVATAR is, however if the report works fine in the CR designer, it is ought to work in any application that calls it.
If AVATAR is a custom portal, I would suggest that you have a word with their Tech Support and find out if it's an issue with their CR Runtimes.
Also, CR 2008 has many new features that older versions of CR do not support. If your report has any of the newer functionalities and if AVATAR is based on lower runtimes, the report will not work.
-Abhilash
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.