Showing posts with label paramters. Show all posts
Showing posts with label paramters. Show all posts

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,

  •