When working with the Report Designer, you might create a layout design that you want to utilize as a template for future Custom Query Reports. You can do so using Save As File.
In Report Designer, open the Custom Query Report whose design you want to save as a template.
Select Save > Save As File.
Name and save the layout.
The layout is saved as a .repx (Report Definition XML) file.
You can use saved .repx files as design templates for Custom Query Reports.
NOTE:You can also use the sample report layouts and SQL queries that are available from the File Query Cookbook website. Both the SQL queries and report layouts can be customized as needed.
You can access the File Query Cookbook at https://filequerycookbook.com.
In Report Designer, open the Custom Query Report you want to design using a saved template.
Click Open, then select the .repx file you want to use for designing your report.
The report is updated with the design from the .repx file.