Prompt common to Universe and Free hand SQL

[mk7393]

Hi,

I have a report which uses both Universe and free hand sql in different data providers.

I have a prompt input which will be used in both data providers.

How can I use same prompt in both dataproviders one being universe?

Thanks
Murali

 

[skrandel]

Just make the prompt text exactly the same in both places and it should do exactly what you want.

Steve Krandel
VERITAS Software

 

[mk7393]

Hi Steve,

I saw that it works if you have 2 data providers.
How to set the same prompt in universe?

Thanks ,
Murali

 

[mk7393]

I did not make my question clear.

The prompt works if both data providers use freehand SQl..

Will it work if one uses universe?

 

[skrandel]

Yes, it will. It's all based on having the EXACT same prompt text.


Steve Krandel
VERITAS Software