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

26 views
Skip to first unread message

HF

unread,
Sep 20, 2012, 4:38:04 AM9/20/12
to erpnext-dev...@googlegroups.com
I have a query which I need to make a report based on it ... how can I do that in ERPNext ?

Rushabh Mehta

unread,
Sep 20, 2012, 8:20:31 AM9/20/12
to erpnext-dev...@googlegroups.com
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.far...@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 erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@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.
 
 

HF

unread,
Sep 20, 2012, 9:14:04 AM9/20/12
to erpnext-dev...@googlegroups.com
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 ?)

Rushabh Mehta

unread,
Sep 21, 2012, 12:01:36 AM9/21/12
to erpnext-dev...@googlegroups.com
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

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages