pythonreports-users

[PythonReports-users] if / else for a field value

[Werner F. B. <wer...@fr...>]

Hi,

I hope you got well into the New Year!

In some of my reports I have conditional values, how could I do this in 
PythonReports:

if ru.oCurrentvalue:  # variable defined on an import alias "ru"
     currentvalue # variable from report data set
else:
      lastpurchaseprice # variable from report data set


Werner

Re: [PythonReports-users] if / else for a field value

[Werner F. B. <wer...@fr...>]

On 01/01/2013 12:13, Werner F. Bruhin wrote:
> Hi,
>
> I hope you got well into the New Year!
>
> In some of my reports I have conditional values, how could I do this in
> PythonReports:
>
> if ru.oCurrentvalue:  # variable defined on an import alias "ru"
>       currentvalue # variable from report data set
> else:
>        lastpurchaseprice # variable from report data set
I am getting there:

(lambda o, c, p: c if o else p) (ru.oCurrentvalue, currentvalue, 
lastpurchaseprice)

Now I just need to figure out how to do:

if ru.oShowprice:
     if ru.oCurrentvalue:
         currentvalue
     else:
         lastpurchaseprice

"lambda" gives me headaches, but I assume above can be done with a more 
complex lambda - so I go get an Aspirin:)

Werner

Re: [PythonReports-users] if / else for a field value

[Werner F. B. <wer...@fr...>]

On 01/01/2013 13:59, Werner F. Bruhin wrote:

...
> if ru.oShowprice:
>       if ru.oCurrentvalue:
>           currentvalue
>       else:
>           lastpurchaseprice
>
> "lambda" gives me headaches, but I assume above can be done with a more
> complex lambda - so I go get an Aspirin:)
Got it, was easier then I thought, maybe this will be helpful for 
someone else, so here is what I ended up with:

(lambda o1, o2, cV, pV: '' if not o1 else (lambda o2, cV, pV: "%.2f" % 
cV if o2 else "%.2f" % pV)(o2, cV, pV))(ru.oShowprice, ru.oCurrentvalue, 
currentvalue, lastpurchaseprice)

Werner

Re: [PythonReports-users] if / else for a field value

[alexander s. <al...@go...>]

On 01.01.2013 13:13, Werner F. Bruhin wrote:
>
> In some of my reports I have conditional values, how could I do this in
> PythonReports:
>
> if ru.oCurrentvalue:  # variable defined on an import alias "ru"
>       currentvalue # variable from report data set
> else:
>        lastpurchaseprice # variable from report data set

There are several possible ways to achieve that.

If you are using Python 2.5 or newer, the simplest way is field 
expr="currentvalue if ru.oCurrentvalue else lastpurchaseprice".

You may also do it using template conditionals:

     <field expr="currentvalue">
      <style printwhen="ru.oCurrentvalue" />
     </field>
     <field expr="lastpurchaseprice">
      <style printwhen="not ru.oCurrentvalue" />
     </field>

Finally, you may create a Python module with any functions you need and 
import it into your template.

Best wishes,
alex.