Skip to Content
author's profile photo Former Member
Former Member

Date value required

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on May 23, 2013 at 02:12 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2013 at 05:39 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 23, 2013 at 06:54 PM

    Indeed, I’ve removed the CR 2008 new functions based objects from the report and then the report worked just fine in the WebPortal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.