Generating Reports

1

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.

 

 

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


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

On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.

 

 

3

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


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

On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.

 

 

4
Arun,

You will have to look it up yourself. There are a few examples in the ERPNext modules.

- Rushabh


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

On 18-Dec-2012, at 6:39 PM, Arun Emmanuel <ar...@gmail.com> wrote:

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


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

On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.

 

 

5

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.

- Rushabh


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

On 18-Dec-2012, at 6:39 PM, Arun Emmanuel <ar...@gmail.com> wrote:

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


On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.





–

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.

 

 

6

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 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.

On 18-Dec-2012, at 6:39 PM, Arun Emmanuel <ar...@gmail.com> wrote:

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


On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.






–

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.

 

 

7

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 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.

On 18-Dec-2012, at 6:39 PM, Arun Emmanuel <ar...@gmail.com> wrote:

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


On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.






–

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.

 

 

8

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 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.

On 18-Dec-2012, at 6:39 PM, Arun Emmanuel <ar...@gmail.com> wrote:

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


On 18-Dec-2012, at 11:32 AM, Arun Emmanuel <ar...@gmail.com> wrote:

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.






–

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.





–

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.

 

 

9