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]

Hi mshoe and svenn, thanks for the help! The shortcut to use '"' only instead of creating new String objects is good. Will save me lots of time. But - it does not change the behaviour... I tried the adding the "!" - unfortunatly it did not help either. :( For me the issue is, that having this "if-construction" in the Default Value Expression of a parameter does not work. As I described, the if-statement works when being used in Text Field, but does not work when being used in the Default Value Expression of a parameter. Maybe someone of the Jasper team can comment on this? Is this works as designed - or a bug? Thanks, Kai

Go to the Properties of the Subreport. There you will find the tab "Subreports (other)". The lower section contains the "Subreports Parameter" tab - which should get the parameter names. If you choose "Copy from Master" iReport will do the most for you automatically. Otherwise: Parameter == Parameter name Expression == Expression to the parameter (like $P{myParameter) hth Kai

Some tests later ... It seems as if the expression <boolean> ? <value1> : <value2> does not work as expected when being used in the default value of a parameter. I now changed everything to be as simple as possible: Code:$P{hasCompanyID}.booleanValue() ? new java.lang.String("companyName"«») : new java.lang.String("companyID" ) What should return a string with eiter companyName or companyID when the parameter is used in a text field. But - I always get "null". When I test the expression simply in the Expression filed of a Text Field, everything is OK. Is there something wrong? Do I need to re-format it? Or does it imply not work this way? How can I get around it? Thanks for any help Kai Schmitte

Weird - now I moved the " and " from the expression to the query itself - and now I get "The document hasno pages" when I run the report. Although I have tested any possible setting in "When no data", the report does not show.

Hello All, I'm not able to run a report with a dynamic query - I always get a message which shows me that there may be a "null" value being added to the query. Now I don't have a log4j.properties in my iReport home folder (at least I didn't found it, otherwise I would have the ability to check the query like proposed in http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=34035&catid=10&limit=6&limitstart=0 -> is there a way to check the rendered URL in iReport? What is weird, is that a simple parameter default value works (like "and company.id = 1"), but my complicated expression not: Code:($P{companyID}.equals(""«») ? new java.lang.String("and company.name like '"«») + $P{companyName} + new java.lang.String("'"«») : new java.lang.String("and company.id = "«») + $P{companyID} )The expression should use the company.id when available - otherwise make a search for the company.name. When I now use the simpler parameter default value and use the expression in a text field, the value in the text field is always correct. -> is the expression evaluated after building the query? -> Is there a way to get around this? Thanks for any help! Kai Schmitte

Hello all, swoods hint worked for me (2.0.1). I have a folder where the access is read-only and a user for the ANONYMOUS_USER role. I needed to redeploy the war file in tomcat to get the changes. Thanks for that help! Kai

Hi nike007, I had a similar issue when the access rights on the report were too tight. As I remember I needed to set the rights for the Anonymous User to "Read only" to get the e-mail sending working. hth Kai

Hi ilopez, just as a short note: afaik - JasperServer runs on different DB systems as JasperServer repository. I guess, that you want to know, if you can run a report with data from a MSSQLServer DB. I have not tried it yet, but the JasperServer plugin for iReport offers to import an iReport connection. And iReport offers the connection to a SQLServer DB. Therefore I deduct that JasperServer will be able to run reports on SQL Server. hth Kai

Hi all, is there a way to do the same without scriptlets? It seems to be not possible to get the scriptlet into JasperServer (see http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=30956 ). Would I be able to get the same when using a "simple" additional java class? Then I could get rid of the scriptlet ... Thanks for any input! Kai

just for anyone interested, I'm trying to get this: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=29748#29748 running. I need to get the value of the last row in the current one to calculate the percentage deviaton...