Perform Step 1 to Step 5 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.
Get the query for Input Control (filters).
For example, if you have a prompt filter for Platform, create a report and select Platform in the
panel, instead of the panel.Click
.In the
panel, copy the query and save it on your device.Perform Step 6 to Step 23 in Section 1.1, Migrating ZRS Custom Reports with Simple Filters and without Filters.
Delete the content from the SQL keyword WHERE through the end.
For example, the original query is as follows:
SELECT zDevice1.Platform FROM zDevice zDevice1 INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType='Device') WHERE zZENObject1.Name IN @prompt('Enter value(s) for Device Name:','A','Managed Device Status\Device Name',Multi,Free,Persistent,,User:0) AND (zZENObject1.Path like '/~dev%')
And the modified query is as follows:
SELECT zDevice1.Platform FROM zDevice zDevice1 INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType='Device')
All fields related to the query are displayed. If an error is displayed, it indicates that the query has issues, and the query must be modified.
Click
.In the
panel, expand .Select all the fields and drag them into the
column.All of the fields are added to the report, with their respective names on
.If you want to format the report, for example, to change the
, select s, then change the Height, Width, Border, Font Size, Font Style, and so forth.After creating a report, perform the following steps to upload it into ZENworks Reporting 5:
In the
panel, expand tree.Select the folder location, then
.In the
, specify the details, then click .Select
and browse to a report.Click
.In the /datasources/ZENworks_Datasource.
list, selectClick
.In the
panel, select right-click, then click .In the
panel, specify the details.For example, to create input control for Platform, then in
specify as Platform, and specify , and .Click the
tab.In the
list, select .Select
, then click .Specify the details.
Click the
tab in the list, select , then specify the query in the .You must specify the query that you saved on your device in Step 4.
Click the /datasources/ZENworks_Datasource from the list.
tab, select , then selectClick
.In the
, click the tab.Click the
tab.Specify the details.
Specify the Name used in the modified query in Step 17.
Click
.In the
panel, right-click .In the Step 12, then select java.util.Collection in the list.
panel, change to the same inIn the
panel, click .In the WHERE $X{IN,zZENobject1.name, Platform}
, append is fromClick
and then click . If an error is displayed, it indicates that the query has issues, and it must be modified.(Conditional) If your report has more than one Input Control, perform Step 2 to Step 4 and Step 11 to Step 28.
Go to Main jrxml file, then click .
, expand your report, right-click theClick
to save the report and upload it to the server.Click
.Run the report in ZENworks Reporting 5.