Need Help with Parameter and/ or Formula

[Former Member]

Post Author: codyj

CA Forum: Formula

Hey all, another newbie question.

I have a report with 2 parameters, user name and case number. I would like to make it so that the report users can choose a case number or a name or both. Here is the record select formula I am using:

{?Name}={ae_audit.usrname} and {?Case\ Jacket Number}={ae_dt1.field1}

I have tried using Or and Xor instead of And, but neither seems to work. Is there another operator that I am missing?

[Former Member]

Post Author: codyj

CA Forum: Formula

Thanks, that works for the most part. There are items that don't have an entry (no "DE" or other entry) and they seem to get filtered out now. Here is my version of your formula. I changed the "DE" to "DE" because there is also a "DES". It didn't seem to change anything though.

{RP_INPAR7_VIEW.Storage} = {?Storage} andif {?Dispo} = "YES" then {RP_INPAR7_VIEW.Dispo} like "DE" elseif {?Dispo} = "NO" then not({RP_INPAR7_VIEW.Dispo} like "DE")

[Former Member]

Post Author: yangster

CA Forum: Formula

you are converting a boolean into a meaning for the db to understandsimple enoughin the select expertif {?parameter} = "YES" then field like 'DE" elseif {?parameter} = "NO" then not(field like "DE")

[Former Member]

Post Author: codyj

CA Forum: Formula

Sorry. looks like I didn't make sense. I want the user to be prompted "Show Destroyed Items?" which will have "Yes" or "No" options. "Yes" would show all items including "DE", "No" would show all except "DE".

[Former Member]

Post Author: yangster

CA Forum: Formula

Think about what you have just typed out.You want it to show you all values DE and to not show you all the values DE at the same time??Show me all the letters A or all letters except A.Think about what you are really after then ask the question. Computers take everything literally so you can't be one thing and the other at the same time.

[Former Member]

Post Author: codyj

CA Forum: Formula

Thanks. That example helps. I am still missing something. I think I need to define something else in the report. There is a value of "DE", I want to make the reports show all "DE" items or everything but the "DE" items.

[Former Member]

Post Author: V361

CA Forum: Formula

Pull up the sample reports (these are on the start page), feature examples, and look at the one called Prompting.rpt, there is a good example in this report.

[Former Member]

Post Author: codyj

CA Forum: Formula

Sorry forgot to mention that. I am running CR XI Developer.

[Former Member]

Post Author: V361

CA Forum: Formula

What version of CR are you on, in CRXI you can do things you can't in other versions