Parameter setting

[Former Member]

In Query Generator How can set parameter in user defined fields in reports?

[former_member186095 · Accepted solution]

Hi,

what about conditions button? have your tried to use it ?

Rgds,

[Former Member · Accepted solution]

Hi

In user created table ,if alphanumeric fields available ,we cann't create parameter report for that fields.

eg.

select * from [@sub_cc_head] where u_itemid = [%0]

this qry is select the fields in itemwise , but it will not working.

becuase that itemid filed is alphanumeric field. but numeric field is working.

if any one know the solution plz share with me.

regards

anvar

[Former Member · Accepted solution]

Hi,

Use:

SELECT *

FROM .[@SUB__CC_HEAD] T0

WHERE T0.U_ItemID = '[%0]'

indicates the parameter is numeric

'[%0]' indicates the parameter is alphanumeric

Hope it helps,

Vítor