Query Reports Questions and Answers

[Aditya Duggal]

Is it possible to control the precision of floats in a query report.

Like

`tabItem`.length as "L:Float:60"

Now I would like to make this field precise upto say only 1 decimal point so how could I go about that ways.

I would like to ask another thing that I have noticed that incase I make a column as Int then it is not possible to show 0 values as NULL but the same is not true in case of Float.

[Rushabh Mehta]

Aditya,

It is possible (both issues), but we will have to add it in the report builder. Will let you know once its done.

- Rushabh

W: https://erpnext.com
T: @rushabh_mehta

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/XuPSuA8Pd3UJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Anand Doshi]

Hi Aditya,

Please pull the latest updates. We have fixed both issues.

Where-ever you wish to specify float precision in reports, use a slash "/" after Float and specify decimal places:

`tabItem`.length as "L:Float/2:60"

Thanks,

Anand.

[Aditya Duggal]

Thanks Anand,

It Works perfectly, just to let you know that I tried /0 and it did not work, I was just testing the if we could use float as int :)

[Anand Doshi]

Hi Aditya,

If you pass 0, it will take the default float precision. So it won't work. It hasn't created any problems till now, so we haven't changed this behaviour.

Thanks,

Anand.

On 09-May-2013, at 5:22 PM, Aditya Duggal <adi...@rigpl.com> wrote:

Thanks Anand,

It Works perfectly, just to let you know that I tried /0 and it did not work, I was just testing the if we could use float as int :)