What prompt to use for condition 'LIKE'

[ahlone]

In ReportNet, I am currently using the "Select & Search Prompt" for filter material "[PA Purchase Order Detail].[Material].[Material Identifier] in (?Material1?)"

instead of "in", I would like to use like condition. It would be "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1%?)"

Is it possible in ReportNet, &, what prompt do I need to use?

Thanks........

 

[KingCrab]

change your filter to what you have there.

"[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1%?)"

A LIKE filter would work best with a text box or similar. Where the user manually inputs the string.

 

[ahlone]

Thanks KingCrab, I changed the filter to:
"[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1%?)"
And, try using text box prompt, but, it doesn't seem to be working, becasue, I tried running the report with 06, 01, 95 in the text box prompt, and, the result is always the same. Do you know any other prompt might work with like condition?

 

[KingCrab]

Are you expecting to filter to seperate a comma delimited field for you? That wont happen.

 

[Draoued]

If you are using the "Select & Search Prompt" , then you can expand it by clicking the "Option" when running the report.
In the Option , you can select "Contain", then you ll get in the list all the items containing your string. You select the ones you want , and click OK.
Your filter in the report query should be IN.

 

[ahlone]

Thanks KingCrab,& Draoued for the response. "Select & Search Prompt" won't work for me because the list of material start with 06% will be over 1000, &, I will be getting this oracle error. That's why I am trying to use the 'like' statement instead of 'in'.
KingCrab, What I meant on my previos post was that I tried to run the report with 06, and then I tried to run the report with 95. And, I am getting the same result on the report output. Actually, there is no material start with 95%, but, we have over 3000 material start with 06%. So, when I run the report for 95, the report should return no data.

 

[ahlone]

I finally got it working, by using the filter as "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1?)". And, when running the report, let's say I want all the material start w/ 06, then, I would run the rpt, with '06%' on this text box prompt. Thanks ......

 

[KingCrab]

Sorry I missed that

"[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1?||'%')

 

[ahlone]

(?Material1?||'%') concatenate works. Appreciate all your helps.