Prompt in Prompt Macro in Native SQL

[kkirnbauer]

Hello,

i've created a report with a native sql statement.

In this statement i use the #prompt Macro as a filter critera.

Here a short example:


select * from rko0pf, rrp0pf
where rpisnr = koisnr
and rpapzn = koapzn
and rpbtrz = kobtrz
and rpdate = kodate
and rptime = kotime

#prompt('Auftrag','string',' ',' and trim(koaun7) concat '' / '' concat trim(char(koaura)) concat '' / '' concat trim(char(koaure)) =')#



My problem is now, that the concats bring big performance problems.

Is it possible to split the prompt before in 3 Fields?

Another workaround could be to split the prompt in 3 prompts, but then i lost my Search Value prompt and also have problems with Default Values. I tried to use prompt in prompt to solve this:
#prompt('AUN7','string',' ',' and koaura=#prompt(''AURA'')# and koaure=#prompt(''AURE'')# and koaun7 =')#

But that didn't work.

Anybody has solution on my problem?

Kind Regards
Klaus