Removing previouse values of prompt

building reports desktopintelligence
1

Hi,

Please help me how can I remove previous selected prompt value in my deski report. we are using Deski 11.5.

This report is using Free hand sql and has @variable function used for prompt. Below is the code.

@variable(‘EnterNum:’,‘A’,mono,free,Not_Persistent)

Even Not_Persistent is not working.

Thanks,
vrrm

vrrm (BOB member since 2008-08-04)

2

Hi,

Instead of @variable() use @prompt() function.

And, purge the data provider and the previously selected prompt value will be gone.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi,

Using @prompt also doenst work. I am getting the previous selected prompt value.

@Prompt(‘EnterNum:’,‘A’,mono,free,Not_Persistent,))

Thanks,
vrrm

vrrm (BOB member since 2008-08-04)

4

Hi,

Have you tried purging the data provider?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Yes. But purging is working for only first time. When user runs second time, prompt value is not purged.

vrrm (BOB member since 2008-08-04)