Problem in new query report

Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise,  and total profit on base of quantity of items.
It works fine in mariadb database console. 
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]

Example:
Employee:Link/Employee:200
Rate:Currency:120

My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item",  `tabSales Invoice Item`.qty,    `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items"  from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.

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

Hi Anand,

There is no extra space before "select".

Regards

Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.

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

Can you send javascript console's output?

-Anand.


On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,

There is no extra space before "select".

Regards


Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.


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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3RHrm-TBTi9j-N2Cz-LEM1JNM8Wa%3DZDaUj4%3DsOqGf7GA%40mail.gmail.com.

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

Hi Anand,

I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.

I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.

Regards
Amit Bondwal



On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?

-Anand.


On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,

There is no extra space before "select".

Regards


Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.


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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3RHrm-TBTi9j-N2Cz-LEM1JNM8Wa%3DZDaUj4%3DsOqGf7GA%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iFtU%3DL1pcUo6meoEZOA%2B-0c9B7PWcMiavCm6Oj%2BB9c%2BTQ%40mail.gmail.com.

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

Amit,

We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.

-Anand.




On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:

Hi Anand,

I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.

I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.

Regards
Amit Bondwal



On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?

-Anand.


On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,

There is no extra space before "select".

Regards


Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.


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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3RHrm-TBTi9j-N2Cz-LEM1JNM8Wa%3DZDaUj4%3DsOqGf7GA%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iFtU%3DL1pcUo6meoEZOA%2B-0c9B7PWcMiavCm6Oj%2BB9c%2BTQ%40mail.gmail.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1MQf%2B2ppLMXq3au3WcXb33Oq3naYOaxyzgM9KDxEEVAw%40mail.gmail.com.

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

Hi Anand,

Where can I check these logs?



On Thu, Sep 4, 2014 at 4:36 PM, Anand Doshi <an...@erpnext.com> wrote:
Amit,

We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.


-Anand.




On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:

Hi Anand,

I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.

I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.

Regards
Amit Bondwal



On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?

-Anand.


On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,

There is no extra space before "select".

Regards


Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.


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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3RHrm-TBTi9j-N2Cz-LEM1JNM8Wa%3DZDaUj4%3DsOqGf7GA%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iFtU%3DL1pcUo6meoEZOA%2B-0c9B7PWcMiavCm6Oj%2BB9c%2BTQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1MQf%2B2ppLMXq3au3WcXb33Oq3naYOaxyzgM9KDxEEVAw%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iGVd1CO1ovKQ%3DPcbuh39BXabExeoodHkvCrNPZASbq%2B4Q%40mail.gmail.com.

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

https://www.google.co.in/search?q=open+browser%27s+javascript+console


On Thu, Sep 4, 2014 at 4:57 PM, Amit Bondwal <bo…@gmail.com> wrote:

Hi Anand,

Where can I check these logs?



On Thu, Sep 4, 2014 at 4:36 PM, Anand Doshi <an...@erpnext.com> wrote:
Amit,

We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.


-Anand.




On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:

Hi Anand,

I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.

I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.

Regards
Amit Bondwal



On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?

-Anand.


On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,

There is no extra space before "select".

Regards


Amit


On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:

Make sure there is no empty space or blank line before "select..."

-Anand.


On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,

I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-

My sql query is given below:--

Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.

[Label]:[Field Type]/[Options]:[Width]


Example:

Employee:Link/Employee:200

Rate:Currency:120


My sql query is given below:--

select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;



Could you help me to build this query report.

Regards

Amit Bondwal



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/9bd96ec3-46d8-4d32-a057-5000635b71c3%40googlegroups.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.


To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3x8dkjbQKWzq6E53WGukfK5LpMX4knJ_wrrHoA_FQ4fQ%40mail.gmail.com.


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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iESqRSTOtK98BX%3D7sV-jPE6bgwrT%3DJ%2BwNL3rP0y7E%2BsqQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF3RHrm-TBTi9j-N2Cz-LEM1JNM8Wa%3DZDaUj4%3DsOqGf7GA%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iFtU%3DL1pcUo6meoEZOA%2B-0c9B7PWcMiavCm6Oj%2BB9c%2BTQ%40mail.gmail.com.


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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1MQf%2B2ppLMXq3au3WcXb33Oq3naYOaxyzgM9KDxEEVAw%40mail.gmail.com.

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



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAJ%3Dk2iGVd1CO1ovKQ%3DPcbuh39BXabExeoodHkvCrNPZASbq%2B4Q%40mail.gmail.com.

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




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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF25GenvW4A-3TFvyD71NwjaQue6%2Bsi49NX9L7eo2P2d2w%40mail.gmail.com.

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