Friday, March 9, 2012

fail to change the value of parameter with operator 'range'

Hi all,

I have couple of paramters with operator 'range(inclusive)' in my report(Agains datacube), and I always get failure when I choose value with them. here's a example( 3 such parameters on my report).

...

From date To Date

...

From age To Age

...

From Salary To Salary

@.salary is the last one.

when i choose a value for 'From Salary' or 'To Salary' from the dropdown list, it runs correctly. But if I choose value for 'from age' or 'To age' or 'From Date' or 'To Date', it fails due to

  • An error has occurred during report processing. (rsProcessingAborted)

  • Query execution failed for data set 'DimTimesheetTimesheetNumber'. (rsErrorExecutingCommand)

  • Range operator ( : ) operands have different levels; they must be the same.

    BTW, all the default values for these parameters are 'all', since it allows only 'all' to select when I set up the parameters, and I tried to change the default value, but it caused errors about the parameter dependency.

    Any idea and suggestion will be appreciated!

    Jone

    Anybody has any idea?

    Thanks,

  • No comments:

    Post a Comment