zerglicious

I am using JasperServer Professional 2.1 and I am having a problem with ad hoc reports. I have entered a topic, my jrxml file, and certain parameters into JasperServer. However, some of the parameters that I have marked as optional are coming up as required on the filter popup. Does anyone know a workaround or a patch to address this issue? I do need the filters/parameters in the reports but having them as required is not workable.

Hey SuperMonkey, You may not want to go to this level of depth but you can pass the IGNORE_PAGINATION flag as a parameter to the filling process. In a recent project I did, we customized the Excel and CSV generation processes because we didn't want those reports to be paginated. You can of course override the export class implementations by updating the appropriate appliationContext files. Attached is a CustomReportExcelReporter class which uses the IGNORE_PAGINATION flag. You could probably pass this flag as one of the input controls but you might have to do a little customization of the EngineServiceImpl to pick it up before report generation.

did you find a solution to this? I am seeing this rather cryptic error too. Actually, I am seeing it not only when I try to save my Oracle datasource but also when I try to save any resource to the repository.

Ok....That could come in handy. I'll try this out over the next couple of days and post the results of the test here. Thanks lshannon, very helpful.

Well it might possible but would be really ugly in my case because I already have a 30 reports or so that I need to support. I don't really want to double the maintenance. Plus I'm not sure I'll really know about the datasources before JasperServer is deployed. The QueryExecutor thing sounds promising. This is really what I need -- to be able to select a DataSource as a parameter for running the report as part of my input controls.

I have a report which might run against one of two standard jdbc datasources. I haven't associated the datasource with the report because I'm not sure which datasource I'll need to execute the report against. However, when I don't define a datasource for the report, JasperServer 2.1 isn't prompting me for a datasource. It just returns an empty report. Do I need to create a customized web flow to achieve this functionality or am I just missing something?

JasperServer has a Custom Report View step in Version 2.1 when uploading or editing a new Jasper Report. It allows the uploading of an optional JSP file? What is the purpose of this feature? How does this optional page interact with the report template or does it?

There is a white paper that JasperSoft has on the site currently that is very helpful. I tried to upload it to the forum but it is too big. You can find it on the JasperSoft site under white papers. You have to register etc., but it is still there. It is called - Customizing and Rebranding the JasperSoft User Interface Post edited by: zerglicious, at: 2008/04/29 13:16

I am evaluating JasperServer and I need to do two tasks. 1. I have a series of inputs which will be repeated for approximately 30 reports -- I don't want to input all the controls for each report, I'd rather configure these so I'd like to create a custom generated JSP page which will have dynamic inputs. It looks like I'll be able to create a custom web flow and use this to generate my sql. Is this possible? That brings me to question #2. 2. How do I get my sql param $P!{SQL} into a report hosted on JasperServer? I want to just a pass my sql statement into the report as a single parameter. This is simple enough when I'm doing the API level report generation myself. How I pass parameters to a report hosted on the server? Thanks in advance.

I have a report with a Scriptlet which works fine in IReport but is failing validation on JasperServer because JasperServer can't find the scriptlet class on the classpath. I built the JasperServer from the source so it will be easy enough to put the scriptlet class in the /WEB-INF/classes directory but I was trying to upload the scriptlet as a jar in the JasperServer console. Is this the proper procedure for reports with Scriptlets?

I had this exact symptom too but when I dropped from JDK 1.6.0_04 to 1.5.0_05 then the server started working.

Ok I figured it out. I rolled back to source build 2.0.1 and just used a fresh settings.xml rather than trying to 'add' the JasperServerProfile to my existing settings file. I deleted my local repository and although it took 30 minutes to pull all the stuff out the maven repositories it built without a hitch. B)

Thanks for your reply I've tried what you suggested and I'm getting some more output but it doesn't seem to resolve the problem. It looks like Maven is trying to find the following file but can't. Downloading: file://C:/work/JasperServer/jasperserver-repo/com/jaspersoft/jasperserver/api/metadata/impl/jasperserver-repository-hibernate/2.1.0/ jasperserver-repository-hibernate-2.1.0.jar This file isn't in the jasperserver-repo that I downloaded. Was it supposed to be constructed by the code build?

Thanks for your reply I've tried what you suggested and I'm getting some more output but it doesn't seem to resolve the problem. It looks like Maven is trying to find the following file but can't. Downloading: file://C:/work/JasperServer/jasperserver-repo/com/jaspersoft/jasperserver/api/metadata/impl/jasperserver-repository-hibernate/2.1.0/ jasperserver-repository-hibernate-2.1.0.jar This file isn't in the jasperserver-repo that I downloaded. Was it supposed to be constructed by the code build?

Thanks for your reply I've tried what you suggested and I'm getting some more output but it doesn't seem to resolve the problem. It looks like Maven is trying to find the following file but can't. Downloading: file://C:/work/JasperServer/jasperserver-repo/com/jaspersoft/jasperserver/api/metadata/impl/jasperserver-repository-hibernate/2.1.0/ jasperserver-repository-hibernate-2.1.0.jar This file isn't in the jasperserver-repo that I downloaded. Was it supposed to be constructed by the code build?