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.