Set expression and Input box not working ? Help

[shekhar_analyti]

Hi All ,

I have to calculate sales for particular Item ( which has to be selected by user from Input box ) . But both are not working .

I tried same with sector , it worked for both Input box and set expression .

Thanks & Regards

Shekar

[swuehl]

I believe the single quote in your field values are corrupting your set modifier, because a pair of single quotes will indicate a literal. You can replace your single single quote with two single quotes to handle this

='Sales for Item '  & vItem & '  ' &

sum({<Item={$(=chr(39) & Replace(Replace(vItem,chr(39),chr(39)&chr(39)),';',chr(39)&','&chr(39))&chr(39))}>}sales)

The second Replace() is used to create a proper list of field mofidfier values, comma separated, while using semi-colon in your variable definition.

Escape sequences

[devarasu07]

Hi,

Apostrophe causing the issue,

Escape sequences

chr( n ) function

[shekhar_analyti]

Hi Stefan ,

Thanks for the reply , but how to get this list of Items into Input box for user to select .

Thanks & Regards

Shekar

[swuehl · Accepted solution]