Report - IFF statement

rico1931 · 2012-06-08

Hi everyone,

Does anyone know how to write and iff statement for a report on this expression?

=Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177))))

I've used the below code for my other reports but it seems to not work on the above..
=IIF(Code.GetData(24,3) = "CAD","CAD","USD")

can anyone give me some pointers?

azerty74 · 2012-06-08

Can you explain what you're trying todo? Where and why are you using the expression?

=IIF(expression, IfExpressionIsTrueThisIsTheResult,IfExpressionIsNotTrueThisIsTheResult)

rico1931 · 2012-06-11

azerty74 wrote:

Can you explain what you're trying todo? Where and why are you using the expression?

=IIF(expression, IfExpressionIsTrueThisIsTheResult,IfExpressionIsNotTrueThisIsTheResult)

Hi,

All i'm trying to do is the following : If there is no Currency code present (meaning "Blank") Show USD..

I'm trying to do this on the Purchasing Order report where they have the following code in the header

=Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177))))

This and the Purchasing quote are the only reports where I find they write the expressions like this. Every other report is much more simpler using the Code.GetData () ...all i want to do is write a simple IIF statement ](*,)

Troubles_In_Paradise · 2012-06-11

[quote="rico1931
All i'm trying to do is the following : If there is no Currency code present (meaning "Blank") Show USD..

I'm trying to do this on the Purchasing Order report where they have the following code in the header

[/quote]
Not sure I understood your problem but...
You could try with something like the following:

=IIF(Code.GetData(1,1) = "","There isn't a currency","There is a Currency")

rico1931 · 2012-06-11

ok let me see if I can start over.

=Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177))))

Above is the expression in the text box that returns the Customer Cards Foreign Currency. What I need is a IIF statement that says something like the following

=IIF(Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))) = This part I need help on

We have multiple currency like CAD, EUR, etc.. the above "This part I need help on" I want to put IIF =Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))) = BLANK to always return USD

that's it..

and i've been having a complete brain fart on how to write that part..

I hope this is better explained.. i'm sorry everyone.

skulla · 2012-06-13

Did you try like this

=IIF(Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))) = "","USD",Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))))

rico1931 · 2012-06-13

Hi skulla,

Thanks for the reply but this is actually the first thing I tried and I got a syntax error. It doesn't like Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))) being used twice as an expression in the report header.

skulla wrote:

Did you try like this

=IIF(Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))) = "","USD",Cstr(Choose(16,Split(Cstr(ReportItems!PageHeaderCaptions.Value),Chr(177)))))

rico1931 · 2012-06-15

anyone have any other work around?

rico1931 · 2012-06-21

can anyone help me? The only option left is to redo the whole report

thegunzo · 2012-06-21

Hi Rico

You can use the same approach as in Code.SetData and Code.GetData
If you are already doing a SetData you can simply add this to the code in your Report.

For example if you create a function like this (given that the currency code is in Data1):

Public Function GetCurrencyCode as Object
if Cstr(Choose(16, Split(Cstr(Data1),Chr(177)))) = "" then
Return "USD"
else
Return Cstr(Choose(16, Split(Cstr(Data1),Chr(177))))
end if

Then use Code.GetCurrencyCode in your report

Report - IFF statement

Answers

Categories