jsutherland_1

I was having this same error connecting back to an IBM i mid-range server using IBM DB2. Using Studio, language type SQL worked. But when it was running from the jasper server, it would not execute and gave the above error until I changed the language type to PLSQL, which I never would have thought of had it not been for finding this post. Many thanks for posting a solution!!!

That helped a lot. Exactly what I needed for a subtotal in a table. I agree with you -- I didn't find what I thought would be an easy answer to the subtotal question. I was trying various options and would not have considered <none> for type.

I am using a "table only" report. No other bands exists and no other objects exists except the table. The reports purpose is to fill a strickly column related data set so it can be exported to Excel without titles or page footers. The report works well. The export function creates a Excel file that only contains column data without any other text or merged cells. Works great unless the result set is empty based on the user's entry of parameters. Then JS show blank or our interface with JIVE shows a blank section on the web page. I've read other entries that appear to be hacks on how to get something to show on the report if the table is empty, like running the query in the main data set to get the record numbers only. This woudl be unacceptable from a performance standpoint as it may return thousands of rows. Is there a way to indicate that the table's data set returned 0 rows, is emtpy and then either enable a band that I'm missing? Any help would be deeply appreciated.

Using JasperStudio 6.4. I set up a conditional style: <style name="Style2"> <conditionalStyle> <conditionExpression><![CDATA[$F{CheckInDate}.getDate() < $P{ArrivalDate}.getDate()]]></conditionExpression> <style mode="Opaque" forecolor="#FF0000" backcolor="#FFFF33"/> </conditionalStyle> </style> The style I want is a font color of red, matching the bolded forecolor above. Then applied the style to a text field: <textField isStretchWithOverflow="true" pattern="EEE MMM d, yyyy" isBlankWhenNull="true"> <reportElement key="" style="Style2" mode="Opaque" x="2" y="3" width="130" height="15" isRemoveLineWhenBlank="true" forecolor="#000000" uuid="be1438e8-5fd6-4cf5-9b9f-455991047978"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textElement> <font isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{CheckInDate}]]></textFieldExpression> </textField> When the condition is met, the background color changes, but not the forecolor, ie: font color. It stays black. What am I missing?

What I ended up doing was in our javascript code that utilizes the Visualize.js APIs I loop through the options if the type is 'singleSelect', check for the first element as '---' and set it to 'All' if (p.type === 'singleSelect' && p.state.options[0].label === '---') p.state.options[0].label = 'All';

NiK, interestingly, that is a new requirement on our project as well. I hope TIBCO responds to your question soon with an answer.

Did you find a solution? In JasperStudio 6.4, I do not get the error. When I publish to the server and run the report, I get the error.

I've just about got the effect I want by adding: <hc:chartProperty name="plotOptions.pie.dataLabels.distance" value="-50"/> This puts the name and % together, and builds the label into the chart, maximizing the available chart space.

The answer below does help, and I appreciate the response. Using the .format option with: <hc:chartProperty name="plotOptions.series.dataLabels.format" value="{point.name} {point.percentage:.0f} %;"/> It does show the name and % as part of the data label. My intent/hope though is to keep the data label as the name only and put the % in the pie slice itself. Has anybody successfully done that?

Wow, you'd think it would be easier to get % or data labels in the pie slices! Unless I'm missing something, you have to have a function as a custom property. I've tried it, yet it won't display the % in the HTML5 pie slices. Here's the code in the jrxml file: <hc:chartProperty name="plotOptions.pie.dataLabels.formatter"> <hc:propertyExpression><![CDATA["function() {return Math.round(this.percentage*100)/100 + ' %';}"]]></hc:propertyExpression></hc:chartProperty>[/code]I've also got <property name="com.jaspersoft.jasperreports.highcharts.function.properties.allowed" value="true"/> but at the local level in JasperStudio 6.4 not sure that is relevant. The pie chart is showing in Studio, just not with the %. Anybody know what I'm missing?

I have a data set that looks something like this with 3 columns of data named Type, Label and Value: Type Label Value==================================================================SubHead1 Fiscal YearTitle Equipment ReportData Cars 50Data Trucks 25Data SUVs 10 The Data rows form the pie chart. The Title and SubHead1 vary depending on the report needs. I need to have a Text field on top of my report be the value of Label "Equipment Report" when Type="Title" for example to get the right title on the report. And, then another Text field for the subheading when type is "SubHead1" I've tried various expressions but none work to grab the right row from the data set for a title or subheading. How can I do this? Thanks in advance!

Wow. Turns out it was the title.margin property. I had changed it to 5 from the default of 15 so the chart woudl be a bit larger on the canvas. Showed fine in IE. In Firefox, Chrome and Opera, the chart would not show. When removed, it shows. Interestingly, the title.margin on the bar charts is set to 5 as well, and they show.

I've got a report with two chart types and multiple types of each: pie and column. In Explorer, they appear fine. In any other browser, the pie charts won't render except for the Title property. The bar charts (both horizontal and vertical style) do show. No matter what I do to change the pie chart properties or move they within the section they will not show except in Explorer. Has anybody else run into this issue?

I have an HTML5 pie chart. It is possible the data coming in has 0 values. The chart renders fine but shows 0s for all values. I would like to condition the chart to not show if the values are 0. How can I do that? I'm using JS studio, v6.3.0.

I don't have an answer but want to join the group is wondering why we set Show Legend property to False in Chart Properties and it still.