Link to a Report

Frappe Framework Customization
1

I’m wondering if there is a way to set up a Link field to go to a specific report as opposed to just the Form view of a document.

For example, I have a custom Script Report (called "Production Order Stock Report) which tells me how many sub-items are required to make the item in the production order, and how many I have in stock. One of the columns is the BOM for that item. Right now there is a Link field where if I click I get sent to the Form page for the BOM. What I would like to do is have a Link field to another report I’ve created (called “BOM Stock Report”), which gives detailed information on each BOM Item, the quantity required to build one, and the stock of each item.

Any ideas on how to accomplish this? It basically needs to link to a report instead of a Form, and plug in one of the filters. Is this possible?

2

@Ben_Cornwell_Mott, you can use a custom button and a route_options

eg:

cur_frm.add_custom_button("Open Something", function(){
    frappe.set_route(["query-report", "Some Report"]);
});
2 Likes
4

What if you’d like to add filters?

5

yes, its possible to create button link to report

6

You can try this to set filter

frappe.set_route('query-report', 'General Ledger',
	{ party_type: 'Supplier', party: frm.doc.name });
7

second filter when passed crashes the whole condition, one filter works just fine