I need to create my own report based on a query ... how?

I have a query which I need to make a report based on it … how can I do that in ERPNext ?




You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/kMI_Gi5p60YJ.

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

 

 

Hi HF,

We have this feature request in our list - it will also help us release reports much faster...

Right now, if you can install MySQL Administrator (a free tool) you will be able to do this.

best,
Rushabh


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

On 20-Sep-2012, at 2:08 PM, HF <h....@gmail.com> wrote:

I have a query which I need to make a report based on it ... how can I do that in ERPNext ?




You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/kMI_Gi5p60YJ.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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

 

 

Hi Rushabh;

I already have a better free utility called Heidisql , but I need the reports to be executed and shown in the ERPNext menu.

So it will be in your next release.

I have made something, I added the report in 'tabSearch Criteria' and put my sql statement in the Custom query field, the report appear in the menu but not accessible (Why ?)



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/FFXV8D242UoJ.

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

 

 

We will try and incorporate in this version too (no promise)

There would be a doctype / parent_doctype column in Search Criteria - the report appears enabled / disabled based on that DocType's permissions


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

On 20-Sep-2012, at 6:44 PM, HF <h....@gmail.com> wrote:

Hi Rushabh;

I already have a better free utility called Heidisql , but I need the reports to be executed and shown in the ERPNext menu.

So it will be in your next release.

I have made something, I added the report in 'tabSearch Criteria' and put my sql statement in the Custom query field, the report appear in the menu but not accessible (Why ?)




You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/FFXV8D242UoJ.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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