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