luke2000

Hello, i have the following problem: in my database i have a table with credentials and values, the credentials come from System UserDomain and user name. i already implemented a custom method for Jasper this is working fine and i can put the owner on the report. but i need to limit my results with this parameter. therefore i created a Parameter OWNER, which is of type java.lang.String and its Default Value Expression = OWNER() (note that i set Evaluation Time to Early. currently my query for the Dataset looks like this: this is working nice if i run my jrxml from within Jaspersoft Studio. When i use my .jasper file in my Applications window i get the following error message: net.sf.jasperreports.engine.JRException: Error preparing Satatement for executing the report query (followed by the query above) so i guess i am missing something - i guess its the jar with my custom methods how can i include this in the report (i am not suing jasper server) NOTE: i get the same error in jaspersoft studio when i create the report and include the custom method jar in build path PS: obviously i can provide the jar

I am using Jaspersoft Studio 6.6 and try to add own functions to the Expression Editor. Therefore i follow the tutorial here Jaspersoft Studio Expression Editor: how to extend it and contribute your own functions (part 2) - updated for version 5.5 All works fine but i had to replace the language of the generated report (SampleFunctionsReport.jrxml) from groovy to java to get rid of file not found exceptions Finally after fixing this i still have the following Errors I checked the tutorial a couple of times... What am i missing?

Dear Community, i have to implement reports in my application, therefore the app provides a set of id's which shall be used in the report. In the docs i found how to implement a DataSource, so passing the first entries to the report should be fine. The next step would be to provide related Objects. Within the Report, I need to retrieve related objects from my DataSource. NOTE: related objects might be direct attributes from the Object provided by the DataSource or via dedicated methods. // this method returns a direct attribute (can be another object/entity)Object getFieldValue(JRField field)// this method returns related Multimedia for the Object with id Object getRelatedMultimedia(Object id) [/code]Therefore the DataSource will implement further methods to gain those Objects. Unfortunately i did not find a sample how to do this. I am willing to work out an simple example, if someone can lead me through how to do so. EDIT: if possible its also fine to specify a query to gain the related data - then no DataSource for the subreport would be required - just needs to pass the id of the Object for the subreport and its Table name / Class name Thanks in Advance!