nehachd38

Hi All, I am using Jasper server commnity edition which is installed on Microsoft Azure VM. I am able to login to Jasper Server but not able to create My SQL datasource in Server. Its giving connection timed out error again and again. Also when i try to connect to SQL server datasource it is giving below error. [TIBCO][sqlServer JDBC Driver]The SQL Server login requires an SSL connection. My reports are already created in Jasper Studio with My SQL database and I need to publish them on the Server. I have published reports before on Jasper Server installed on another VM and I was able to create datasources also. I think this time problem is because of Microsoft Azure VM. Can anyone give any input on this.

Thanks line chart worked. but Month names are displaying alphabetically. I need in order April May June July August. But its coming like April August July June. Any idea how to solve

Hi, I am new to Jasper and creating X-Y chart . On x-axis I want to dispay month name but currently numbers 4.0, 4.5 , 5.0 like this are coming. I am using below sql query : select `description - output`.Keywords, month(details.Date), count(distinct `description - output`.`Incident ID`) from idg_dataquality_db.`description - output`, idg_dataquality_db.details where `description - output`.`Incident ID` = details.`Incident ID` group by `description - output`.Keywords, month(details.Date) If I use monthname in query the Jasper studio is giving error : java.lang.String cannot be cast to java.lang.Number Below is my whole source code: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0 --> <!-- 2018-09-26T12:55:12 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Keyword trend over a period of Time" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="108161ea-b60a-409a-b1fd-615f83762f54"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DQ Dashboards"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[select `description - output`.Keywords, month(details.Date), count(distinct `description - output`.`Incident ID`) from idg_dataquality_db.`description - output`, idg_dataquality_db.details where `description - output`.`Incident ID` = details.`Incident ID` group by `description - output`.Keywords, month(details.Date)]]> </queryString> <field name="Keywords" class="java.lang.String"/> <field name="month(details.Date)" class="java.lang.Integer"/> <field name="count(distinct `description - output`.`Incident ID`)" class="java.lang.Long"/> <background> <band splitType="Stretch"/> </background> <title> <band height="46" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="560" height="30" uuid="a7a3a2f6-309f-48e4-bcb7-a797e01a9e78"/> <textElement textAlignment="Center"> <font size="18" isBold="true"/> </textElement> <text><![CDATA[Keyword Trend over a period of Time]]></text> </staticText> </band> </title> <summary> <band height="250" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <xyLineChart> <chart evaluationTime="Report"> <reportElement x="0" y="0" width="560" height="250" uuid="42d9a7f3-ede2-4eaf-b4fd-4544070f526c"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <xyDataset> <xySeries autoSort="true"> <seriesExpression><![CDATA[$F{Keywords}]]></seriesExpression> <xValueExpression><![CDATA[$F{month(details.Date)}]]></xValueExpression> <yValueExpression><![CDATA[$F{count(distinct `description - output`.`Incident ID`)}]]></yValueExpression> </xySeries> </xyDataset> <linePlot> <plot/> <categoryAxisFormat> <axisFormat/> </categoryAxisFormat> <valueAxisFormat> <axisFormat/> </valueAxisFormat> </linePlot> </xyLineChart> </band> </summary> </jasperReport> Please help me to write a expression to type cast and dislay month name instead of numbers.

I am able to successfully establish connection to my sql database and able to design the report in jasper studio 6.3.0 with my sql queries. I am getting difficulty to publish report in jasper server. I have tried publishing through local data source but its giving following error: org.apache.http.client.HttpResponseException: illegal.parameter.value.error Specified driver class is not registered DriverClass com.mysql.jdbc.Driver Also when i try to publish through Data Source from Repository , I can see my report on server but its not getting generated. Its giving below error: There was an error on the server. Try again or contact site administrators. (Error UID: 56ddcd55-7819-4005-9bcd-6e137e19dd0e) Please let me know how to publish my report successfully on server through studio.