Report Builder

thatdudejoss · March 4, 2013, 10:45am

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

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

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

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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

system · March 4, 2013, 11:26am

Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.

For example you can check Selling > Customer Addresses And Contacts

Thanks,

Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

thatdudejoss · March 4, 2013, 12:10pm

Hi

Thanks for the quick response, but i keep getting ‘404 Not Found’ error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:

Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/Zd3I3gqUrLMJ.

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

thatdudejoss · March 4, 2013, 12:18pm

Hi

Is there no way to make a custom report, and not view current reports?

Thanks

On Monday, 4 March 2013 14:10:57 UTC+2, Joseph Siame wrote:

Hi

Thanks for the quick response, but i keep getting ‘404 Not Found’ error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:
Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4QRHAyFD8vQJ.

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

system · March 4, 2013, 12:49pm

Hi Joseph,

To create query reports, you need to have System Manager role.

so, if you have installed erpnext at localhost:8080 then,

http://localhost:8080/app.html#query-report

will show you a page where you can click on edit button and create a new query.

Thanks,

Anand.

On 04-Mar-2013, at 5:48 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

Is there no way to make a custom report, and not view current reports?

Thanks

On Monday, 4 March 2013 14:10:57 UTC+2, Joseph Siame wrote:
Hi

Thanks for the quick response, but i keep getting '404 Not Found' error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:
Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4QRHAyFD8vQJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

thatdudejoss · March 4, 2013, 3:21pm

HI

That series of steps didn’t work, every time i hit the edit button it kept giving me the ‘404, Not Found’ error. Anyway i managed a work around that.

Okay so i have now established how to create custom reports, my next question is how do i get to appear in the Reports list of ,say the Human Resource, module? Do i have to write a custom script for that?

Thanks

On Monday, 4 March 2013 14:49:07 UTC+2, Anand Doshi wrote:

Hi Joseph,

To create query reports, you need to have System Manager role.

so, if you have installed erpnext at localhost:8080 then,
http://localhost:8080/app.html#query-report

will show you a page where you can click on edit button and create a new query.

Thanks,
Anand.

On 04-Mar-2013, at 5:48 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

Is there no way to make a custom report, and not view current reports?

Thanks

On Monday, 4 March 2013 14:10:57 UTC+2, Joseph Siame wrote:
Hi

Thanks for the quick response, but i keep getting ‘404 Not Found’ error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:
Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th…@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4QRHAyFD8vQJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ItLvu4AsEswJ.

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

system · March 4, 2013, 3:38pm

In report set standard = no and the report will appear in the module of the reference doctype

Sent from my phone

On 04-Mar-2013, at 8:51 PM, Joseph Siame <th...@gmail.com> wrote:

HI

That series of steps didn't work, every time i hit the edit button it kept giving me the '404, Not Found' error. Anyway i managed a work around that.

Okay so i have now established how to create custom reports, my next question is how do i get to appear in the Reports list of ,say the Human Resource, module? Do i have to write a custom script for that?

Thanks

On Monday, 4 March 2013 14:49:07 UTC+2, Anand Doshi wrote:
Hi Joseph,

To create query reports, you need to have System Manager role.

so, if you have installed erpnext at localhost:8080 then,
http://localhost:8080/app.html#query-report

will show you a page where you can click on edit button and create a new query.

Thanks,
Anand.

On 04-Mar-2013, at 5:48 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

Is there no way to make a custom report, and not view current reports?

Thanks

On Monday, 4 March 2013 14:10:57 UTC+2, Joseph Siame wrote:
Hi

Thanks for the quick response, but i keep getting '404 Not Found' error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:
Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4QRHAyFD8vQJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ItLvu4AsEswJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

jessica_lea · April 16, 2014, 6:31am

Hi

I would like to create a custom report but when I type in app.html#query-report, all I get is this error message :

No Report Loaded. Please use query-report/[Report Name] to run a report.

Also, going from an existing one, once I modify a report and give the system a name to save it to, I get :

(Report): No Permission to Create

I use erpnext 3.6.0 and a system user with every possible right.

Thanks for your help

Jess

On Monday, 4 March 2013 15:38:36 UTC, Anand Doshi wrote:

In report set standard = no and the report will appear in the module of the reference doctype

Sent from my phone

On 04-Mar-2013, at 8:51 PM, Joseph Siame <th...@gmail.com> wrote:

HI

That series of steps didn't work, every time i hit the edit button it kept giving me the '404, Not Found' error. Anyway i managed a work around that.

Okay so i have now established how to create custom reports, my next question is how do i get to appear in the Reports list of ,say the Human Resource, module? Do i have to write a custom script for that?

Thanks

On Monday, 4 March 2013 14:49:07 UTC+2, Anand Doshi wrote:
Hi Joseph,

To create query reports, you need to have System Manager role.

so, if you have installed erpnext at localhost:8080 then,
http://localhost:8080/app.html#query-report

will show you a page where you can click on edit button and create a new query.

Thanks,
Anand.

On 04-Mar-2013, at 5:48 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

Is there no way to make a custom report, and not view current reports?

Thanks

On Monday, 4 March 2013 14:10:57 UTC+2, Joseph Siame wrote:
Hi

Thanks for the quick response, but i keep getting '404 Not Found' error every time i try click on the what appears to a query button at the top. What could be the problem?

I really want to create this custom report.

Thanks

On Monday, 4 March 2013 13:26:56 UTC+2, Anand Doshi wrote:
Hi,

You can use query reports. We try to restrict it to developers, hence the link is not visible.

You can create one by typing #query-report in the url after app.html

In query reports, you can use sql query to generate a report.
For example you can check Selling > Customer Addresses And Contacts

Thanks,
Anand.

On 04-Mar-2013, at 4:15 PM, Joseph Siame <th...@gmail.com> wrote:

Hi

I want to firstly commend you on the over haul upgrade, making it much simpler to navigate and use.

I added a custom field in employee master, called daily rate, now at the end of the week i need to report on specific employees who work on a weekly basis, and to do that i nee to build a new report to calculate and report the amount owed to that employee on a weekly basis. Where do i find the report builder? with the new interface its a little confusing.

I hope to hear from you soon.

Thanks

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

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

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4PZxRZDpxIUJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4QRHAyFD8vQJ.

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 unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To post to this group, send email to erpnext-dev…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ItLvu4AsEswJ.

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

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/65c20b05-c946-473c-a0df-d2fea331b618%40googlegroups.com.

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

rmehta · April 21, 2014, 6:30am

1. The query-report/[report-name] is how you run the report.

2. Do you have the required permissions on Report? I think you have to login via Administrator to create a new report. Also remember to set developer_mode = 1 in conf.py

On Wednesday, April 16, 2014 12:01:20 PM UTC+5:30, Jessica Lea wrote:

Hi
I would like to create a custom report but when I type in app.html#query-report, all I get is this error message :
No Report Loaded. Please use query-report/[Report Name] to run a report.

Also, going from an existing one, once I modify a report and give the system a name to save it to, I get :
(Report): No Permission to Create

I use erpnext 3.6.0 and a system user with every possible right.
Thanks for your help

Jess

–

Note:

If you are posting an issue,

We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

End of Note

—

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

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

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/4662293b-9df7-43c4-85d7-59e373f65ec0%40googlegroups.com.

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