Special characters

Jet Reports Historic Posts

July 19, 2012 21:40

None

Hi,

I have the following simple function:

NL("Sum";"Value entry";"Amount Cost (actual)";"Item No.";NL("Filter";"Item";"No.";"FilterField1";"Filter1"))

Item Numbers may have special characters, so I get an error. How do I combine the "@@" with the NL(Filter) - function? I tried a lot, but nothing worked.

Regards

Frank

Date Votes

2 comments

Jet Reports Historic Posts July 19, 2012 22:11 Official comment

Hi Frank,

I think you could do this with a calculated field like this:

=NL("Sum";"Value entry";"Amount Cost (actual)";"Item No.";NL("Filter";"Item";"=""@@""&NF(;""No."")";"FilterField1";"Filter1"))
Does that work for you?

Regards,
Hughes

Comment actions Permalink
0

Jet Reports Historic Posts July 20, 2012 10:14

Hi Hughes,

it works, thanks! I had the idea with the calculated field, but not the syntax.

Frank

Comment actions Permalink

Please sign in to leave a comment.