Raphaël Peguet

Hi Siva,
I found the question of Sadakar describing very well how to use Base64 images in a JasperReports template. Not sure whether his server issue was resolved but you may find the post at 
With a field called image_base64 the image expression should then be:
net.sf.jasperreports.engine.util.JRImageLoader.getInstance(new SimpleJasperReportsContext()).loadAwtImageFromBytes(Base64.getDecoder().decode($F{image_base64}))  

There is a line at the top of the .jrxml file telling the JSS and JRL versions used to create the report, so if you look at the source of the report in Jaspersoft Studio, then you should get the info.

No worries, I am happy to help.
The users in JRS don't need to be the same as the DB users, you create the users in JRS as you prefer and several users will use the same DB connection if they share the same profile attributes values defining the DB connection info.
I have created a sample in my github at https://github.com/raphpeguet/JRS-demo-dynamic-DB-connection but I'm not sure if the import in the community edition of JRS will work since the export was done from the enterprise edition. If it doesn't work maybe you could create a new JRS instance using the free trial environment with the installer you get from jaspersoft.com/download.
I hope this helps,

Thank you for upvoting, downvoting or selecting the best answers in this thread to help us improve the experience on this forum.

Hello, I'm glad to hear you can now compile the report template.
Are you trying to preview the report in Jaspersoft Studio as well? It seems that an expression somewhere in the template is expecting a value which is not null from the parameter 'msg'.
To look for the expression(s) using $P{msg} the simplest is probably to do a quick search in the source tab (beside the preview tab).
Then once you identify in which object and band the parameter is used you can look at the expression from the designer view and see what's going on.
You will also need to review how the 'msg' parameter's value is set. There could be an issue there as well and its value remains null.
Last test in understand what's going on, try to set a default value to the property 'msg'

Hi Rohit,
You're using the Community Edition, open source edition of Jaspersoft Studio so it doesn't require a license.
Why do you need digital signature support? How do you plan to use it?
Raphael 

Hi,
Your XML data source contains namespaces.
Using Jaspersoft Studio 6.4.X or 7.X you need to:
enable namespace support in the data adapter
In the query use the following syntax to manage namespaces as described in https://stackoverflow.com/questions/4440451/how-to-ignore-namespaces-with-xpath for example./*[local-name()=Invoice]/* 
 

I would recommend you to review this wiki article that focuses on JSON data sources but the logic will be the same with your sub-report. So you can start reading this article after the check on report execution.
Also in your case the property "net.sf.jasperreports.data.adapter" should be defined at the sub-report level and its value can be the local copy of the export of the data adapter as Jaspersoft Studio will recognise it automatically during deployment and will export it as a linked resource and will update the URI in the property.
See attached screenshot for more info.

In Jaspersoft Studio (JSS) you can create a connection to JasperReports Server (JRS) using the Repository Explorer (if it's not displayed go to Window > Show View > Others and find Repository Explorer under Jaspersoft Studio section).
You need to connect to JRS using a user with administrator rights
Once you set up the connection to your JRS you can navigate through the repository and open a report that you can then modify.
JRS supports filtering, formatting and some editing while viewing tables if you use the table component in JSS. So instead of using the Column header and detail band to build your table, you will need to use the Table component that has the same structure and that comes with the interactivity for free once deployed in JRS.
All you can do with the tables are presented in this video https://www.youtube.com/watch?v=zUI4R8nt6pc

Alternatively you may want to disable the possibility to publish and overwrite resources when saving a report.
To prevent the input controls or any other resources from being overwritten when saving the report you need to untick the 2 properties under Jaspersoft Studio settings > Jaspersoft Studio > JasperReports Server:
 

To prevent the input controls from being overwritten or any other resources when saving the report you need to untick the 2 properties under Jaspersoft Studio settings > Jaspersoft Studio > JasperReports Server: