kschmitte

I have stopped development of scriplets and moved everything into a simple JAR. This jar is part of my JasperServer Repository and needs to be linked as resource for every report. For iReport I need to keep the java *.class and *.java files in the folder where the report jrxml is stored - then I don't need to change anything in iReport or the report itself. Gruss Kai Schmitte

This is a completly different issue ;) I would create a subreport with a query designed to return exactly the data I need in the chart - and then just put in the resluting fields. If needed you can pass parameters to your subreport (like your "YXZ"). Kai

Hi, each "line" needs its own "Category Series" (in Chart Properties - Chart Data - Details) regards, Kai Schmitte

OK - shame on me. It seems to be the GRPUP_CONCAT() in my SQL which I use to concatenate the contents of differnent rows which cuts the content at 1024 chars. Unfortunatly it's hard to see in the returned data from the SQL that there is something missing... Sorry for any inconvenience. Kai Schmitte

Hello lucianc, thanks for the reply. The SQL works when being executed in a simple SQL Tool. The original program (php) does read/write without issues. Unfortunatly I cannot provide you with the table (to try to reproduce it in your lab), as the data is company confidential. I will try to build a sample table when I'm back from my business trip next week. Gruss, Kai

Hello All, for me it is the same - I can't get more than 1024 characters in my textField - although the filed is designed to be much bigger and "Stretch with overflow" is set to true. I checked if setting the styledText Attribute would help - no change in behaviour. In the xml of the report (generated from IReport 2.0.2) I could also not see any restriction. It seems as if this forum has nop answers yet (see e.g. http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=37284#37284). Is this by design? Or is this a bug? Is there a way to work around this limitation? The report should be shown in JasperServer - maybe I can set here another limit? Thanks for your help! Kai Schmitte

saurabhraval, assuming that you cann access both of your reports by html (thus served by the web server of your choice) you can define hyperlinks for certain fields in the reports. To create a hyperlink open the properties of the field and fill in the information in the "Hyperlink" tab. There you can define a dynamic link (according to the row / field you are in) containing the info to call the second report correctly. Kai Schmitte

Hello Teodor, thank you very much! Then I'll wait for the next release of JasperReports. Will I need to get a new JasperServer version also, or will it be sufficient to exchange the JasperReport files? Thanks! Kai

As I also needed to show HTML which is in the DB inside a report, I have opened up a new JasperReports Enhancement Request in the Tracker: http://jasperforge.org/sf/tracker/do/viewArtifact/projects.jasperreports/tracker.feature_requests/artf3042 artf3042 Regards, Kai Schmitte

In similar situations "matches" fitted my needs - it takes a string and returns a boolean... Gruss Kai

Hi all, first of all - this thread turned out to be a real good help. As I have seen, the issue only occurs when the name is the same - but with different upper/lower cases (for me it was the first character). My issue was resolved when deleting the report unit and creating it new - but now with the notation of the original report. Hth. Gruss, Kai

Hello all, I have the exactly same issue (since my todays changes included removing a report and creating it again). Nice coincidence (if it would stop me working ...). If this is programatical you should think about changing the iReport PlugIn (where it is easier to delete a report with subreports and create it newly again than changing something in the report -> the first option automatically creates the correct links to the subreports...) Anyone who could help? Thanks for any help Kai

Have you tried to enter the same "Print When EXpression" (new Boolean($F{DBLSOLL}.intValue() ==0)) for both fields? Gruss, Kai

Hi Mike, Ben, yes - that was it. After reordering everything worked as I wanted to have it! Thank you very much! Kai

I'm currently using iReport 2.0.2. I have attached the whole report jrxml to this reply - maybe this helps. Of interest is the parameter filter (and the other params used in this parameter...). Interestingly I failed in creating a simple report just showing the failing behaviour. With this report the parameters don't seem to be evaluated at all - all Text Fields contain "null" ... Thanks for your help! Kai [file name=showCompanyTickets_CompanySub.jrxml size=17235]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/showCompanyTickets_CompanySub.jrxml[/file]