Cool Solutions

Customized Ad Hoc Template Report

hshari

By:

September 28, 2016 1:34 pm

Reads:2,649

Comments:1

Score:5

Print/PDF

Download CustomizedAdhocReportTemplates.zip

In ZENworks Reporting Server 5.6.1, creating an Ad Hoc report displays only plain data. This cool solution will display Ad Hoc reports with the default customized template that includes the Micro Focus logo, Logged in user, and Page footer for all the page orientations (Actual Size, Portrait, and Landscape). In addition these default templates can also be modified, once Jaspersoft Studio 5.6.1 is connected to ZRS Reporting Server 5.6.1.

Steps for Creating Ad Hoc Template Report :

1. Log in to ZENworks Reporting Server as user.
2. Go to Manage -> Server Settings -> Import
3. Enable Update Checkbox and disable rest of all the check-boxes.
4. Upload the zip file CustomizedAdhocReportTemplates attached and Click Import.
5. Create an Ad Hoc view, drag required objects.
6. Add a title header in “Click to add a title” section.
7. Click the option Save Ad Hoc view and Create Reports.
8. In the dialog box, Select the radio button “Generate Report with: Custom Report Template” as mentioned below.

cool1

9. Browse the customized template that has different page orientations added as a part of this zip file.

Cool2

10. Save the Ad Hoc Customized report in the desired location and run the report that was just saved.

TemplateReport

This is the default report template that has been provided. we can edit the templates, based on the requirements.

For instance, to change the logo of the default template, connect Jasperstudio 5.6.1 to ZRS Reporting Server 5.6.1 using the following link:

https://www.novell.com/documentation/zenworks113/zen11_zrs_installation/data/b1cy2qjo.html

Once connection is established, go to root folder Public > Templates in Jaspersoft Studio, all normal and Customized templates are available and it can be modified. In this case, Actual Customized jrxml file is opened.

cool11

Adding a new image resource file in Jasperreports Server resource file.

Cool12

Add the image resource file and browse the required image file from the local file system.

Cool13

Once the image is uploaded, the image resource file name is available and it can be seen in the below mentioned snapshot.

cool14

Drag the actual customized jrxml file in editor and click on the image file that is seen on the template file, expression editor is seen in the properties file shown below. Change the path of the image file location in Expression editor accordingly.

cool15

Once the exact path location is mentioned, you can see the image file getting modified in the template jrxml file. Press Ctrl + S, to save and publish these changes to ZENworks Reporting Server 5.6.1.

cool16

Try creating Ad Hoc view and save the report with Custom Report Template that is modified. Newly created custom template report has data with the new logo changes.

Cool17

Similarly, once JasperStudio 5.6.1 is connected, these default templates can be extended based on the requirements.

1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5 (1 votes, average: 5.00 out of 5)
You need to be a registered member to rate this post.
Loading...

Tags: , , ,
Categories: Cool Tools, Technical, Unified Endpoint Management, ZENworks, ZENworks Reporting

Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

1 Comment

  1. By:spencapl

    Hi

    Great article however i’m hitting an issue when trying to import my own logo and naything into the Public -> templates folder via Studio.

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

    Seem to not have the right level of access ? even though i can create custom reports.

    Thanks

    Spencer

Comment

RSS