Hello,

I've been modifying a report with some extra checks in the record selection formula.

This works fine when running it in Crystal Reports XI.

But when I run it from in the program where this extra report has been added to it's always gives the error that a date/time is expected.

The program uses a Business Objects plugin.

The formula that works fine in CR is listed below.

schoolyear can be something like "2015-2016" and the date "2015-8-28" I even added code to be sure it ends up at yyyy-MM-dd for the mssql query.

Any help/hint would be appreciated.

Thanks in advance!


{vPackages.schoolyear} = {?p_schoolyear}

// from here is the new code

and

(

    (
        {vPackages.startdate1} < totext( {?p_month} , "yyyy-MM-dd" )
        and
       (
        isnull ( {vPackages.enddate1} ) or
        {vPackages.enddate1} > totext( {?p_month} , "yyyy-MM-dd" )
        )

    or

        {vPackages.startdate2} < totext( {?p_month} , "yyyy-MM-dd" )
        and
       (
        isnull ( {vPackages.enddate2} ) or
        {vPackages.enddate2} > totext( {?p_month} , "yyyy-MM-dd" )
        )

    )

)

In the original table those fields are of the smalldatetime type.

As the query takes some time I use a job to fill another table every hours or so, there it is plain date (not datetime or smalldatetime) and the data is correct inthere.

Any idea why it works fine in CR11 and not when used via a BO CR viewer?

Good question.

This is a program from an external company and it might be a VB6 app as it doesn't require any .NET framework to get it working.

I'll ask the company about this.

what has the browser to do with it?

It's opening like a reporting report in a .NET program not in a webview/browser.

I'm using 8.1 and I first noticed the problem when showing the modded report at an enduser on his Vista or 7 box.

I'll give that company a call tomorrow as it's almost 21:00 here.

I'll keep you posted.