bob_8

Hozawa, could you post the <categoryDataset> portion of your report please? I am pretty sure I've narrowed the problem to what happens in that section. Mine is: <categoryDataset><categorySeries><seriesExpression><![CDATA[$F{a}.contentEquals( "yes" )]]></seriesExpression><categoryExpression><![CDATA[$F{c}]]></categoryExpression><valueExpression><![CDATA[$F{b}]]></valueExpression></categorySeries><categorySeries><seriesExpression><![CDATA[$F{a}.contentEquals( "no" )]]></seriesExpression><categoryExpression><![CDATA[0]]></categoryExpression><valueExpression><![CDATA[0]]></valueExpression></categorySeries></categoryDataset> Note the CDATA[0] in the second seriesExpression (Studio generated this). It may not be possible to bin the numbers as I am trying. I might have to create multiple datasets, one for each series probably. Anyway... it would be good to see what yours looks like... Thanks! Bob

Hi Hozawa. Thanks for your note. Yes. I just confirmed that I get the zero column with the two-dimenssional stacked chart as well. What version of Jasper Server are you using? Thanks, Bob

Assuming this is not a Jasper bug, I don't believe the Studio import/export functions understand report dependencies. In fact, I am reasonably sure they do not. *If* I'm right, then you have two options: either bring each report or sub-report down individually; or, if you are familiar with the Jasper database, you can use a PHP script or may be even a SQL script to copy all the elements you'll need. Again, *if* I'm right... Either way, I would discourage you from going into the database directly. Good luck, Bob

This is just a guess but might be worth a few minutes... Try deleting the subreport first, then delete the main report. I don't know which version of Jasper you are using but, in my experience, Jasper has serious parent issues (!) when it comes to subreports. Good luck, Bob

Thaks for the note Hozawa. Here are the steps: In Jasper Studio 1. File->New, then select the blank letter template 4. Add the query (it is tested in the DBMS first to make sure this is not a SQL issue) 3. Enlage title, drap the chart item into the Title area, double click on Select 3D Stacked Bar 4. Create two series - one for a "yes" value, the other for the "no" value in one of the columns in the data. I am using $F{a}.contentEquals ("yes") or "no", to separae the two series. 5. specify a field for Value, and another for Category. 6. Preview in Studio - no errors. Everything shows up as expected, except the extra column. 7. Running the report programmatically also produces the same 0 column. 8. There are no 0 values in the data. Thanks for any and all help or suggestions, Bob

Hi guys... I am using the Stacked Bar Chart but an extra bar with the length and lable of 0 (zero), that is NOT in my data is added to every stacked bar graph - but it won't show if I do a regular bar chart. Has anyone seen this? If so, how did you get rid of it or is this a bug? I am using Jasper 5.5.0 CE. Thanks! Bob

Try right clicking on the jrxml file on the remote server (in Studio), then "Open in Editor," then save it locally.

Hi Rajesh, THANK YOU for your comment. I will look at your blog but my problem turned out to be that I had a dash in my report name. Quite a bit of time wasted before I figured it out. I do believe it is a bug in the PHP Client since the report works when run from iStudio. Anyway... Thanks again for taking time to respond. Bob

UPDATE: ****** INCASE SOMEONE FROM JASPER/TIBCO SEES THIS - THIS IS A REALLY STOOPID BUG AND SHOULD BE FIXED ****** The problem had nothing to do with the parameter. The problems ended up being the report NAME - if the report name contains a dash, you'll get a resource not found error. As soon as I removed the dash, everything worked just fine. Hey, I know this (the community version) is free but....

I am using the PHP Client. I want to dynamically create a table at run time and pass the name of that table to a report. My Query syntax looks like: <parameter name="x1" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["foo"]]></defaultValueExpression></parameter> <queryString> <![CDATA[sELECT a, b, c FROM $P!{x1}]]></queryString> If I set the isForPrompting to true and run this iStudio, it will prompt me for a table name and work just fine. If I try to use the same in my PHP Code, I crash. Here is the call in PHP (Note: This code works fine if I don't include the query variable. In other words, I know I can pass "normal" parameters to the report) $controls = array ('Header1'=>array ($Header1), 'Footer1'=>array ($Footer1), 'Footer2'=>array ($Footer2), 'SegVar' =>array ($SegVar), 'SegId' =>array ($SegId), 'Image' =>array ($logo), 'x1' =>array ("foo") ); $report = $c->reportService()->runReport($reportName, 'pdf', null, null, $controls); This is the error I get Fatal error: Uncaught exception 'JaspersoftExceptionRESTRequestException' with message 'Resource URI:/reports/KIZVA/CUST-REV-ANALYSIS Type:com.jaspersoft.jasperserver.api.metadata.common.domain.InputControlsContainer not found' in /opt/lampp/htdocs/pam/lib/jrs-rest-php-client-master/src/Jaspersoft/Tool/RESTRequest.php:380 Stack trace: #0 /opt/lampp/htdocs/pam/lib/jrs-rest-php-client-master/src/Jaspersoft/Tool/RESTRequest.php(464): JaspersoftToolRESTRequest->handleError(404, Array, '{"message":"Res...') #1 /opt/lampp/htdocs/pam/lib/jrs-rest-php-client-master/src/Jaspersoft/Service/ReportService.php(40): JaspersoftToolRESTRequest->prepAndSend('http://107.191....', Array, 'GET', NULL, true) #2 /opt/lampp/htdocs/pam/JobRunner.php(486): JaspersoftServiceReportService->runReport('/reports/KIZVA/...', 'pdf', NULL, NULL, Array) #3 /opt/lampp/htdocs/pam/JobRunner.php(553): RunJob(Array) #4 {main} thrown in /opt/lampp/htdocs/pam/lib/jrs-rest-php-client-master/src/Jaspersoft/Tool/RESTRequest.php on line 380 Does anyone have any suggestions? I've tried this multiple ways (with $P and $P!) and any combination I could think of. Any and all ideas would be greatly appreciated.

Thank you getbeedfrobe.

Thank you emestoo. This turned out to be a great suggestion. I had actully tried this about 14 months ago but I'd get weird printouts from one of our older printers that, unfortunately, is deployed everywhere. After reading your note, I tried running the old report and this time everything seems to be working. I can only guess that something was fixed in Jasper Server since we try to keep up with updates. Anyway... THANK YOU for your great suggestion. Bob

I would like to put a bunch of summary graphics on the FIRST page of the report, before dumping of the details. So, for example, let's say I have a bunch of sales figures for a product over a month. On the first page of the report I want to show a couple of graphics (max units by store, max $ by store, that sort of thing), then force a page break, and print the detail report. Right now I do this using two reports and merging them. That gets messy and it would be far easier (particularly in terms of making changes) if I could do all this in one report. If you know a clever trick to do this, I would very much appreciate a note. Thanks! Bob

I don't know if this is going to help you or not but I found it far easier to bypass the autoload and specifically load the classes I need. The idea behind the autoload is really nice (really, really nice) but I was having way too many issues - all of which went away once I started to explicitly load the classes.

You can do this using a parameter.

OK, so in case anyone else falls down this rabbit hole... 1) I have no idea what "Input Controls" USED to do but, currently, they are, for all intents and purposes, the same as Parameters. 2) However.... Input Controls DO NOT exist unless you specifically assign them in your PHP Code using runReport. 3) (So my problem was that I was trying to query Input Controls and the PHP Client does not do a good job (AT ALL) of checking to see if it has valid values. So I was crashing) 4) Input Controls is an array of arrays. Your parameters have to be an array, even if they have only one value, example: $controls = array ('Param1'=> array ("foo"), 'Param2'=>array("goo")); 4) Therefore, the right sequence is to (a) create a client object, (b) create an array of parmeters (see #4) and then call runRerport. 5) There is very little error checking. So if the parameter does not exist (case sensitive), or if the value is the wrong type, you'll get an often-meaningless (Java) stacktrace. It is meaningless because, depending on the state of TomCat, you may or may not get something you can use. Hope this helps someone...

I am having a bunch of really irratic problems using PHP to access report Parameters. I am hoping that someone out there has a sample that actually works? I am running the latest version of the library (just downloaded from Git). When I try to get the InputControls (JUST A LIST - not working with the controls yet), I get two errors: NOTICE: Trying to get property of non-object in [blah blah/jrs-rest-php-client-master/src/Jaspersoft/Service/ReportService.php on line 58 WARNING: Invalid argument supplied for foreach() in [blah blah]/jrs-rest-php-client-master/src/Jaspersoft/Service/ReportService.php on line 58 I have NOT made any changes to the above Jaspersoft module. *MY* code looks like the following. $c = new Client ("MYIP", "MYACCT", "MYPSWD", ""); $input_controls = $c->reportService()->getReportInputControls ("REPORTNAME"): Any and all suggestions would be greatly appreciated. Thank you, :=)

Don't know if you still need this or not but just in case others might... here is the link to a page with reasonable discussion on Restv2 and Jasper PHP API. http://community.jaspersoft.com/wiki/php-client-sample-code

I think the problem started when I installed an FTP Server. Certainly does not happen if not FTP server is running. See my update above. Thanks, again, for your help. Bob

I have not got to the "access part" yet. I am getting strange errors. I destroyed and rebuilt the vm, and downloaded the x64 installer again. When I tried to install it, I now get a new error: Warning: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-5.6.0/apache-ant/bin/ant import-ce -DimportFile=install_resources/export/js-catalog : BUILD FAILED /opt/jasperreports-server-cp-5.6.0/buildomatic/bin/import-export.xml:260: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.6.0/buildomatic/bin/import-export.xml:158: Java returned: 1 Total time: 4 seconds Very strange. These same steps worked as early as last Monday. Now all sorts of issues. No clue but will keep digging.

Hi Hozawa. Thanks for the note. The message is from Tomcat - connection refused. I tried to post the entire error log here but the Jaspersoft spam vendor, Mollom, flags it for some reason. No other instances of Tomcat were running at the time. I even rebooted the VM to make sure. I am a bit confused. This does not make any sense to me, particularly since as recently as last Monday this worked just fine. I will keep experimenting. Now I'm really curious. Bob

Hi guys. I have a problem with installing Server 5.6.0 using the x64 Linux (ubuntu) Installer. This worked earlier this week but now on a clean install, Tomcat refuses connection. I switched to 5.5.0a without changing anything else in the OS and that one works fine. Anyone have any clues as to what may have changed? Thanks. *************************** UPDATE ***************************************** OK, after arm wrestling with this for about 12 hours, I think (not sure, think) my problem started when I installed an FTP Server. I have now verified that the problem happens ONLY when I install an FTP server (does not seem to matter if it is VSFTPD or PROFTP). My guess is that there is some sort of a conflict with Tomcat but am too tired to try to figure that out. I rebuilt my VM without an FTP server and everything is working. If you have installed an FTP server on the same server you are running Jasper, please post your config file(s). *******************************************************************************

Here are some things to check if you are running Windows. 1. Make sure Postgres is also running. 2. Postgres installs on port 5432. Make sure your virus protection and/or Windows firewall have not blocked that port. 3. I know this may be silly but are you sure you installed the Pro version? try http://127.0.0.1:8080/jasperserver - (without the login.htm). This should redirect you to the login page. Good luck.

Thank you Hozawa. That is what I was looking for. I followed the instructions and it worked.

I just installed on 14.04 as well and don't have any issues with running the server. Did you start Tomcat and Postgres? (You can start them both by running ctlscript.sh in <jasper home>). You should also use the same script to check the status to make sure Tomcat and Postgres are running. Good luck. Bob