kumargsk2014

Hi team, I Have a springMvc based webapplication where i want to implement jasper column filter,column sorting in my web application .currently i able to integated jasper with springmvc .i want to achieve sorting ,filter in the application please help me in this. Thanks

<?xml version="1.0" encoding="UTF-8"?><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="report6" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="99e47486-8bc8-49f4-9ffc-ee4d9983ce95"><property name="ireport.zoom" value="1.0"/><property name="ireport.x" value="0"/><property name="ireport.y" value="0"/><style name="table"><box><pen lineWidth="1.0" lineColor="#000000"/></box></style><style name="table_TH" mode="Opaque" backcolor="#FF7F50"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_CH" mode="Opaque" backcolor="#FFD0BF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><style name="table_TD" mode="Opaque" backcolor="#FFFFFF"><box><pen lineWidth="0.5" lineColor="#000000"/></box></style><subDataset name="TradeDataSet" uuid="42153102-523f-4799-84d6-3ab1395f22b0"><queryString language="SQL"><![CDATA[select trade.OWNER owner,trade.DeskID deskid, trade.ErrorCode errorcode,count(*) countvaluefrom dbo.trade_details_for_poc tradegroup by trade.OWNER,trade.DeskID,trade.ErrorCode order by trade.OWNER asc]]></queryString><field name="owner" class="java.lang.String"/><field name="deskid" class="java.lang.String"/><field name="errorcode" class="java.lang.String"/><field name="countvalue" class="java.lang.Integer"/></subDataset><queryString><![CDATA[select trade.OWNER owner,trade.DeskID deskid, trade.ErrorCode errorcode,count(*) countvaluefrom dbo.trade_details_for_poc tradegroup by trade.OWNER,trade.DeskID,trade.ErrorCode order by trade.OWNER asc]]></queryString><field name="owner" class="java.lang.String"/><field name="deskid" class="java.lang.String"/><field name="errorcode" class="java.lang.String"/><field name="countvalue" class="java.lang.Integer"/><background><band splitType="Stretch"/></background><title><band height="79" splitType="Stretch"/></title><summary><band height="81" splitType="Stretch"><componentElement><reportElement key="table" style="table" x="147" y="14" width="360" height="50" uuid="fa2d4c4d-6d56-43fb-9667-da42c16d3aca"/><jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"><datasetRun subDataset="TradeDataSet" uuid="e6201a07-73bf-4116-b7ff-d3cf8ac02103"><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression></datasetRun><jr:column width="90" uuid="006cb2b5-1e3b-4c78-ba63-2e71893a23e1"><jr:columnHeader style="table_CH" height="30"><staticText><reportElement x="0" y="0" width="90" height="30" uuid="3d51eea8-49e7-4256-8660-1403535a3fe3"/><text><![CDATA[owner]]></text></staticText></jr:columnHeader><jr:detailCell style="table_TD" height="20"><textField><reportElement x="0" y="0" width="90" height="20" uuid="019b61fc-7350-4aca-b3ec-dfcc1f175532"/><textFieldExpression><![CDATA[$F{owner}]]></textFieldExpression></textField></jr:detailCell></jr:column><jr:column width="90" uuid="06a9baff-3bcb-4613-90f5-708c5aa3515f"><jr:columnHeader style="table_CH" height="30"><staticText><reportElement x="0" y="0" width="90" height="30" uuid="65515909-b7b7-484b-8220-531b525fb144"/><text><![CDATA[deskid]]></text></staticText></jr:columnHeader><jr:detailCell style="table_TD" height="20"><textField><reportElement x="0" y="0" width="90" height="20" uuid="1b8cb110-acb0-4f2b-9472-a2b6c11b7d07"/><textFieldExpression><![CDATA[$F{deskid}]]></textFieldExpression></textField></jr:detailCell></jr:column><jr:column width="90" uuid="3e17c7c9-4fbb-4a42-bd37-18f1ece82eff"><jr:columnHeader style="table_CH" height="30"><staticText><reportElement x="0" y="0" width="90" height="30" uuid="538ab5ae-80d2-4405-b785-0ed67a03040a"/><text><![CDATA[errorcode]]></text></staticText></jr:columnHeader><jr:detailCell style="table_TD" height="20"><textField><reportElement x="0" y="0" width="90" height="20" uuid="880dfd53-639e-4325-b0b4-f7c060dfece0"/><textFieldExpression><![CDATA[$F{errorcode}]]></textFieldExpression></textField></jr:detailCell></jr:column><jr:column width="90" uuid="edb74a63-3165-478b-b8ce-5107dc08cd72"><jr:columnHeader style="table_CH" height="30"><staticText><reportElement x="0" y="0" width="90" height="30" uuid="f7f073c1-520d-4b06-8aab-2982abba25bd"/><text><![CDATA[countvalue]]></text></staticText></jr:columnHeader><jr:detailCell style="table_TD" height="20"><textField><reportElement x="0" y="0" width="90" height="20" uuid="ac7b5700-26d8-4cd2-a6ed-ef208bfdcac4"/><textFieldExpression><![CDATA[$F{countvalue}]]></textFieldExpression></textField></jr:detailCell></jr:column></jr:table></componentElement></band></summary></jasperReport>

Hi , I Created UserInteractiveReport using Ireport tool and deployed this JasperReportServer.In Report1 dispalyed data in table and passing query string to another report(report2) .In Report 2 how to take value from query string that we passed from report1.I Created input control with paramer name but it is not working .please help me in this

Hi i have created interactive jasper report using ireport and Jasper Server .Same report can i Create with jsp , java and tomcat? .As i know we can create only read only reports with jsp,java and tomcat.And how much effort it will be .what are prons and cons.

Hi i want to display data in UI with excel options in Jasper is it possible