Calling python function from script report html

Frappe Framework Customization
2

So, I found a temporary hack on my own.

The def execute function for the report from Python can return more arguments than those required. Which means user can modify function to return a List. The fact that it is a list, and only a list is “the hack”, however, at least the Script report print format HTML can access the data direct from Python, and then the user can work with this list using Jinja directly.

The solution is as follows:

  1. Create your custom Script report or similar.

  2. Open your dev server directory in terminal or similar, you’ll find:
    [your_custom_report].py
    [your_custom_report].js
    [your_custom_report].json

  3. Create a boilerplate HTML file (this will be your printed report), name it exactly as above: [your_custom_report].html

Edit this HTML file, such that you place your headings, tables and data elements properly.

  1. Inside whichever HTML element you need to place your data, type in the following line of Jinja:

{%= report.raw_data.data_to_be_printed[0] %}

Notice that we are referring to a JavaScript array, and accessing by index, which is similar to what python does. This will be very clear in the next step.

  1. Open the [your_custom_report].py file, and you will find the execute() function. In the return statement there are only two items: columns, data. Modify this line of code so it looks like this:

return columns, data, [ ], [ ], data_to_be_printed

We are interested in adding a list or dictionary to data_to_be_printed either with a fixed assignment or by calling another function within the function execute(). Options are unlimited here!

Let’s create a simple hello world list within execute()

data_to_be_printed = [“My very important data”, “secondary data”]

You will have to define the columns as well, along with some dummy data for this example, such that the report can be run by ERPNext successfully. Save all files.

  1. Run your report on ERPNext, and then click on Menu > Print to bring the print report dialog. Since it is a custom report, do not select letter head, nor pick columns, and make sure the orientation is landscape. Click on Submit.

Your report will display your columns and data, and the html element you specified will show the contents of the list specified: My very important data

Options:
You can also use a dictionary assignment for data_to_be_printed, for example:

data_to_be_printed = {
    'title': 'My Report Title',
    'subtitle': 'My report subtitle'
}

And then in the HTML you call it with:

{%= report.raw_data.data_to_be_printed['title'] %}
Which prints: My Report Title

Personally, I prefer using a dictionary, since keys are more meaningful and useful for debugging.

You can also inject an HTML string, which will be properly interpreted, for example:

data_to_be_printed = {
    'title': 'My Report Title',
    'subtitle': 'My report subtitle',
    'blue_text_div':'<div style="color: blue;">My awesome blue text</div>
'
}

Which results in a blue colored text in the HTML.
My awesome blue text

6 Likes