Problem in new query report

[Amit Bondwal]

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

[Anand Doshi]

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

-Anand.

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

[Amit Bondwal]

Hi Anand,

There is no extra space before "select".

Regards

Amit

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

[Anand Doshi]

Can you send javascript console's output?

-Anand.

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.

[Amit Bondwal]

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

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.

[Anand Doshi]

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.

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.

[Amit Bondwal]

Hi Anand,

Where can I check these logs?

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

[Anand Doshi]

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

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