[Merged macro excel file with Studio export]

I receive the Error Message

net.sf.jasperreports.engine.JRException: Input stream not found at : /Folder/Resources/macro.xlt

 

[Merged macro excel file with Studio export]

Hello,

I am attempting to merge an excel exported file from JasperSoft studio 5.6.1 with a macro-enabled excel file. However, when I use the "Add JasperReports Server Resource", other file types are not permitted. What is the proper procedure for uploading macro.xls

Is the macro file needed in the local studio folder structure and get compiled together with the .jrxml OR does it exist on the JasperServer as a resource that is retrieved when the report is executed.

 

thanks

 

Mike