using prompt value in expression?

[ravina]

Hi,

I see following conditions in expression for amount..

if ([tax prompt] = 'HST') then amount=10 else amount=20.

I thought there is a prompt with name..'tax prompt'?

I searched through everywhere.. but does not seem to find 'tax prompt'?

from where is this name coming from?

-ravina

 

[mfgf]

Hi Ravina,

[tax prompt] is a data item in your query. Hover over the Query explorer on the middle toolbar, and select Query1 to find it.

Regards,

MF.

 

[ravina]

thanks. will try it today.

 

[ravina]

what you are saying is correct. 'tax prompt' does show up under data items. and under its properties expression says ?Tax type code?

similarly it shows up in Filters.. where its condition says.. [tax prompt] = [tax type] or [tax prompt]=[taxid].

I still do not understand....from where did the word 'tax prompt' came in the first place?

-ravina

 

[mfgf]

Hi Ravina,

Whoever wrote the report originally created this as a calculated item in the query. The expression indicates that it's simply getting hold of the value in the parameter called Tax type code.

This item is then being used in your filter.

If this is the only place tax prompt is used, it seems a rather convoluted way of doing things. You could probably simplify the report by changing the filter to
[tax type] = ?Tax type code? or [taxid] = ?Tax type code?
then deleting the [tax prompt] item.

On the other hand, if [tax prompt] is used elsewhere, then leave things as they are.

Regards,

MF.

 

[ravina]

got it now. Thank you.
-ravina