Query Reports Questions and Answers

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.



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-forum+un...@googlegroups.com.

To post to this group, send email to er...@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.

 

 

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

On 08-May-2013, at 11:35 PM, Aditya Duggal <ad...@gmail.com> wrote:

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.




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-forum+un…@googlegroups.com.

To post to this group, send email to er…@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.

 

 




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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.

On 09-May-2013, at 8:30 AM, Rushabh Mehta <rm...@gmail.com> wrote:

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

On 08-May-2013, at 11:35 PM, Aditya Duggal <ad...@gmail.com> wrote:

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.




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-forum+un…@googlegroups.com.

To post to this group, send email to er…@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.

 

 





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-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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 :)




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

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 <ad...@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 :)





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-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 




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-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.