Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message when using rank function ?

Status
Not open for further replies.

NicolaTesla1

Programmer
Feb 9, 2009
37
CA
Hi to all,

- We have a simple list report with only 4 columns
- One of the columns (the last one from the left) is named "Rank" and is based on one of the columns (measure)
- The code inside this column is as follows: rank([Number of Pieces])
- we are using Report Studio 8.4 against a package coming from a BW cube
- When validating the report i get the following error message:
RQP-DEF-0585 The expression, 'rank([Number of pieces] desc auto )', is too complex for carrying over the attributes
(format, currency and unit of measure). Column attributes are only retained for expressions with just 2-part item references.

Anyone has an idea why ? Or any suggestions ?

When in the expression editor, i noticed that there is 2 diff. rank functions available from the "Functions" tab of the "Available components"
I can only use one of the 2 rank functions because the other one has a exclamation mark next to it.

Thanks in advance !
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top