ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Printing custom reports


#1

Hi

Is there a way to print a custom report (in the same way you could add a print format for query-report?)

If no, can a create custom query-report (where I can add custom print formats?)

br
Jens Bohlin


#2

Hi @Jens_Bohlin, Could you do something about it?

Any Someone know how to do this?


#3

Any updates


#4
  1. Created query report
  2. Set the query report as Standard = Yes
  3. Folders for query report got created into app/module/report/query-report-name folder
  4. Created html in the query-report-name folder
  5. Created dummy doctype in app/module
  6. .html file formatting visible.

Till I had created a dummy doctype, the Menu/Print or Menu/PDF was not visible.

Hope it helps


How to customise query report html
#5

Not sure what’s happening, but the Menu/Print and Menu/PDF has disappeared again.


#6

@aakvatech, I think you need to export the fixtures first via bench --site site_name export-fixtures in order to keep the print format template.

bench migrate and bench update updates print formats, custom fields and other customizations based on the fixtures folder. If there are no fixtures in the fixtures folder, it will only retain the default print formats found in the modules.

Hope this helps.


#7

Hi Hera,

Thanks. I deleted the custom report and recreate it.

Didn’t bother as it was a testing report only.


#8

Somehow, now the files are not getting created.

Installed Apps
ERPNext: v10.1.52
Frappe Framework: v10.1.47


#9

Query report files not getting created in the below version. Anybody else faced similar problems?

Installed Apps
ERPNext: v11.0.3-beta.30 () (staging)

Frappe Framework: v11.0.3-beta.39 () (staging)

NOTE:

developer_mode is set to 1
query name is “test”
folder app/module/report not getting created


Creating Report
#10

developer_mode: 1 is necessary to be integer. I had configured as developer_mode: "1"