Scripting Functions (system.report.executeReport)

Ignition
1

Hi,

I did test the system.report.executeReport() function based on the tutorial Scripting Functions Video at Inductive University

image
image1258×419 41.8 KB

image
image1770×837 145 KB

image
image1173×997 109 KB

Can anyone guide me any mistakes I made, thanks.

Regards

Jian

2

Does you report work in preview mode? Is there data shown on the report? Any errors in the diagnostic console for the designer?

3

It’s possible MyReport is unsaved (based on it being in italics)... I would save and close all windows and try again. Reports and Named Queries sometimes need some extra saves for changes to take effect throughout.

4

Hi, Mate

I ran the script in the Script Console and followed the tutorial exactly, but I'm still encountering issues.

MyReport got nothing to configure except an empty parameter –‘functionName’

image
image1195×862 45.2 KB

I guess this error is fine. I have configured the event in the button.

image
image1248×932 85.4 KB

BTW, I put my code below for your trial.

reportBytes = system.report.executeReport(path='MyReport',project='myProject',\
	parameters={'functionName': 'Using executeReports()'}, fileType='pdf')
name = "executeReport() Report"
event.source.parent.getComponent('PDF Viewer').loadPDFBytes(reportBytes,name)
5

The report itself, is there data in it? When you run the report in preview mode in the designer is there data showing in the report?

6

Hi, Mate.

No, I did save it. It’s an empty report.

image
image1460×881 59.3 KB

But when I switch to the window, the text became italics again.

image
image1141×976 107 KB

I have pasted the code below; you can change the project name accordingly and try it in your software.

reportBytes = system.report.executeReport(path='MyReport',project='myProject',\
	parameters={'functionName': 'Using executeReports()'}, fileType='pdf')
name = "executeReport() Report"
event.source.parent.getComponent('PDF Viewer').loadPDFBytes(reportBytes,name)

Thanks.

Jian

7

If the report is empty... Then it might be showing the report. Just empty.

Add some static text or something to the report then you can tell if you are generating the report.

1 Like
8

Hi, Mate

It works. Thanks :slight_smile:

:+1:

Regards

Jian