Text prompt for currnet ID and Previous ID

[COGNOSBC]

Hi Friends,

I have one ?ID? text prompt in my prompt page.
in the query I have 2 columns like current ID and Previous IDs.

currently my filter is : current ID = ?ID?

little bit requirement has been changed to: user wants the prompt as it is now means one text prompt but they may enter in that box either current ID or Previous ID so then they want to see the report for both ids.

so I tried to change my filter: (current ID= ?ID? or Previours ID = ?ID?) but I am getting below error:

The specified value 'parameterDataTypeEnum:xsdHexBinary' is not a valid enumeration value

any idea how to do this??

Thanks..

[RKMI]

Hi,

Don't combine the filter like you did but, instead current ID= ?ID? in one filter and Previours ID = ?ID? in another filter and set them to optional. So if there is a ?ID? for either of the filter it will pass it.

If that doesn't work tell us if this relational or dmr and wht is the full path of current id data item and also the for previous id. Also you have not mention weather you tested it for only previous id=?ID?, since you only speficed currently my filter is : current ID = ?ID?. Reason asking you test that is to see if the ?ID? for previous ID is getting passed correctly. Might be a case where current id is a number and previous id is a character.

Thanks,
RK

[DSR]

I think you need to convert both the Id's to text or prompt value to numeric value to apply the filter.

Regards,
DSR