Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
rmehta
December 18, 2012, 7:29am
2
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta
<rm...@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
rmehta
December 19, 2012, 5:42am
4
Arun,
You will have to look it up yourself. There are a few examples in the ERPNext modules.
- Rushabh
HI Rushabh
I browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta
<rm...@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
–
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 .
Ok Rushabh
I got some ideas about Reports
So i ll start working on reports
Thanks
Arun
On Wed, Dec 19, 2012 at 11:12 AM, Rushabh Mehta
<rm…@gmail.com > wrote:
Arun,
You will have to look it up yourself. There are a few examples in the ERPNext modules.
HI Rushabh
I browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta <rm…@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
–
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
I went through the codes and got some idea about how the reports are generated
I have one doubt
i used erpnext/accounts/search_criteria/trial_balance/ as my reference
In that trial_balance.py file
# if output is more than 500 lines then it will ask to export
# ------------------------------------------------------------
if len(res) > 1000 and from_export == 0:
msgprint("This is a very large report and cannot be shown in the browser as it is likely to make your browser very slow.Please click on 'Export' to open in a spreadsheet")
raise Exception
From where i can get the res variable??
Also where u have written the sql ?
Thanks
Arun
On Wed, Dec 19, 2012 at 7:46 PM, Arun Emmanuel
<ar...@gmail.com > wrote:
Ok RushabhI got some ideas about Reports
So i ll start working on reports
Thanks
Arun
On Wed, Dec 19, 2012 at 11:12 AM, Rushabh Mehta
<rm...@gmail.com > wrote:
Arun,
You will have to look it up yourself. There are a few examples in the ERPNext modules.
HI Rushabh
I browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta <rm…@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
–
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 Arun, You will find sql file in trial_balance directory itself. And the output of the query specified in sql file stored in res variable. Regards, Nabin Hait
On Thu, Dec 20, 2012 at 12:30 PM, Arun Emmanuel
<ar…@gmail.com > wrote:
Hi
I went through the codes and got some idea about how the reports are generated
I have one doubt
i used erpnext/accounts/search_criteria/trial_balance/ as my reference
In that trial_balance.py file
# if output is more than 500 lines then it will ask to export
# ------------------------------------------------------------
if len(res) > 1000 and from_export == 0:
msgprint("This is a very large report and cannot be shown in the browser as it is likely to make your browser very slow.Please click on 'Export' to open in a spreadsheet")
raise Exception
From where i can get the res variable??
Also where u have written the sql ?
Thanks
Arun
On Wed, Dec 19, 2012 at 7:46 PM, Arun Emmanuel
<ar...@gmail.com > wrote:
Ok RushabhI got some ideas about Reports
So i ll start working on reports
Thanks
Arun
On Wed, Dec 19, 2012 at 11:12 AM, Rushabh Mehta
<rm...@gmail.com > wrote:
Arun,
You will have to look it up yourself. There are a few examples in the ERPNext modules.
HI Rushabh
I browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta <rm…@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
--
Regards,
Nabin Hait
–
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 .
Ok… Thanks a lot
On Thu, Dec 20, 2012 at 12:44 PM, Nabin Hait
<na…@gmail.com > wrote:
Hi Arun, You will find sql file in trial_balance directory itself. And the output of the query specified in sql file stored in res variable.
Regards, Nabin Hait
On Thu, Dec 20, 2012 at 12:30 PM, Arun Emmanuel
<ar...@gmail.com > wrote:
Hi
I went through the codes and got some idea about how the reports are generated
I have one doubt
i used erpnext/accounts/search_criteria/trial_balance/ as my reference
In that trial_balance.py file
# if output is more than 500 lines then it will ask to export
# ------------------------------------------------------------
if len(res) > 1000 and from_export == 0:
msgprint("This is a very large report and cannot be shown in the browser as it is likely to make your browser very slow.Please click on 'Export' to open in a spreadsheet")
raise Exception
From where i can get the res variable??
Also where u have written the sql ?
Thanks
Arun
On Wed, Dec 19, 2012 at 7:46 PM, Arun Emmanuel
<ar...@gmail.com > wrote:
Ok RushabhI got some ideas about Reports
So i ll start working on reports
Thanks
Arun
On Wed, Dec 19, 2012 at 11:12 AM, Rushabh Mehta
<rm...@gmail.com > wrote:
Arun,
You will have to look it up yourself. There are a few examples in the ERPNext modules.
HI Rushabh
I browsed through the code and application and found out these things
We can create Report Doctype. But there is no way to add some custom query etc.
But for Search Criteria DocType many options available. sql,py,js files are all associated with Search Criteria - #Report
So how can i implement some reports similar to Search Criteria - #Report using the Report Builder: #Report2, since u said
Search Criteria - #Report is deprecated. Also you did lots of reports using this Search Criteria Doctype but only one report using
#Report2
Also i didnt find any examples for Query Report: #query-report. So could you please give me some idea about that
Thanks n regards
Arun
On Tue, Dec 18, 2012 at 12:59 PM, Rushabh Mehta <rm…@gmail.com > wrote:
Hi Arun,
There are 4 report tools to help you get started:
Query Report: #query-report
Report Builder: #Report2
Grid Report - lib/public/wn/views/grid_report.js (you will have to subclass and customize)
Search Criteria - #Report (deprecated)
You can learn more by looking at examples.
- Rushabh
Hi
How can i generate some custom reports?
What i want to fetch some data from the database based on certain conditions, do some calculations on these data and the generate a report based on these calculation
Thanks n Regards
Arun
–
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 .
–
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 .
–
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 .
--
Regards, Nabin Hait
–
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 .