kunkasurendra

Hi all, I have hundreds of reports made by with crystal report XI. I wonder i can manage those reports with jasperReports. I need actually to evaluate formula and parameters in crystal report formula. does jasper manage those typical structures? I am not able to understand the formulas in Crystal Report. I need to do the same formulas in JasperReports. Please can any one help me regarding this problem. or Is there any tutorial or meterial for evualating the formulas. Thanks in Advance, Surendra Babu.K.

Hai, I have created one user in JasperServer, UserName : tom Password : tom In repository i created one folder --- reports. When i loged into the jasperServer through Tom username Only i want to access the reports folder and their contents, Please give me the solutions, Thanks in advance, Surendra Babu.K.

Hai , I have one MasterReport and One SubReport, I placed into the JasperServer. MasterReport : masterReport.jrxml SubReport : AddressReport.jrxml Reporsitory Path : [root] /reports /MasterReport both JRXML's are placed into the [root] /reports /MasterReport folder. when i click on the MasterReport,it's giving the error. Error Trace: Code:com.jaspersoft.jasperserver.api.JSExceptionWrapper: Could not load object from location : /reports/MasterReport/AddressReport com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Could not load object from location : /reports/MasterReport/AddressReport at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:266) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:311) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:260) [file name=MasterReport.jrxml size=9431]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/MasterReport.jrxml[/file]

Hai, I want to execute the report from the server. this report has the 3 subreports. I have created the main report and 3 subreports using iReport designer. Through iReport designer the report is executing fine. Problem : I placed the main report and 3 subreports into jasperServer. [All .JRXML files has been placed into the jasperserver] /reports/jobhistory/mainreport /reports/jobhistory/subreport1 /reports/jobhistory/subreport2 /reports/jobhistory/subreport3 But main report is not executing. It's giving the exception like how to define the SUBREPORT_DIR path in main report before placing into the JasperServer. please help me here, Thanks in advance, Surendra.

I had 3 subreports. I uploaded the three subreport files to JasperServer as jrxml files. They are in the repository folder [root]/reports/subreports. I uploaded the main report also in to the Jasper server repository [root]/reports/subreports. In main report Code:<parameter name="SUBREPORT_DIR" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA[".\"]]></defaultValueExpression> </parameter> [".\] may be this is on local system. If i placed the all main and subreports into the server, How can i mention the subreport dir, and Code:[code] <subreport isUsingCache="true"> <reportElement x="32" y="8" width="678" height="14" key="subreport-1" positionType="Float" isPrintRepeatedValues="false" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true"/> <subreportParameter name="PROJECT_GUID"> <subreportParameterExpression><![CDATA[$F{PROJECT_GUID}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="ACCOUNT_ID"> <subreportParameterExpression> <![CDATA[$F{ACCOUNT_ID}]]> </subreportParameterExpression> </subreportParameter> <connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression class="java.lang.String"> <![CDATA[$P{SUBREPORT_DIR}+"StatusResponse-sub.jasper"]]> </subreportExpression> </subreport> I placed the main report as well as subreports into the Jasper server repository, repository path in the server:[root]/reports /jobhistory /reports/jobhistory/mainreport /reports/jobhistory/subreport1 /reports/jobhistory/subreport2 /reports/jobhistory/subreport3 i am not able to execute the main report. I think it's because of "SUBREPORT_DIR" Plaase help me, Thanks in advance, Surendra Babu.K. Post edited by: kunkasurendra, at: 2007/08/15 16:32

Hai, i tried this one also,it's also giving the error. Please help me i strucked in doing this if .... else formula here

Hai All, I am facing the problem while doing the formulas. i want to execute the if ... else statement using formulas. I am using oracle. Here i have the database column with data type BigDecimal column name : ACT_DURATION Datatype : BigDecimal In iReport i created one variable named as planedDuration with variable class type is BigDecimal Then in Report i created one text field. In that i want to validate the expression using formulas. means if planedDuration is < 1 then it wants to display the "<1 day" or planedDuration is > 1day it wants to display the no of days. Code:( new BigDecimal(($V{planedDuration}.intValue()) /(24)) < 1 ? "<1 DAY" : new BigDecimal(($V{planedDuration}.intValue()) /(24))+" DAYS" ) here i am getting error. The operator < is undifined for the argument type(s) BegDecimal,int please any one help me, it's very urjant, Thanks in advance, Surendra Babu.k.

Hai All, I am facing problem to create a formula for the condition formula is like that. Code:( new BigDecimal(($V{planedDuration}.intValue()) /(24)) < 1 ? "<1 DAY" : new BigDecimal(($V{planedDuration}.intValue()) /(24))+" DAYS" ) means if planed duration is < 1 then it wants to display the "<1 day" or > 1day it wnats to display the no of days. here i am getting error. The operator < is undifined for the argument type(s) BegDecimal,int plz help me any one are working on this type of formulas. Thanks in advance, Surendra

Hai All, I am facing problem to create a formula for the condition formula is like that. Code:( new BigDecimal(($V{planedDuration}.intValue()) /(24)) < 1 ? "<1 DAY" : new BigDecimal(($V{planedDuration}.intValue()) /(24))+" DAYS" ) means if planed duration is < 1 then it wants to display the "<1 day" or > 1day it wnats to display the no of days. here i am getting error. The operator < is undifined for the argument type(s) BegDecimal,int plz help me any one are working on this type of formulas. Thanks in advance, Surendra

Hai, I am not taking about parameters passing to to the where cluase. Ii am talking about ad hoc report generation, for example in my table i have 6 columns, suppose user may select 2 columns,it will create the report with two columns,he may select 3 columns,it will create the report with three columns,like that. please if have any idea on that help me.

Can anyone help me to generate the dynamic .jrxml file based on the user provided columns? if any one have the idea on dynamically create a JRXML file? Basically, I would like to create a report template based on providing columns from a JSP page and create the JRXML file on the "fly" and compile it. Example: My query is like that: select uid,fname,lname,address,city,state,country,phone from profile. Then user may select only uid,fname,lname based on that the report will generate with three columns, Suppose he may select 4 or 5 columns based on that the report needs to generate. Please help me is there any api to generate the dynamic report based on the columns!

Hai all, Subject : Generating Dynamic report based on user selected columns I am new to JasperReports. I want to generate the Ad Hoc reports using the JasperReports API. For this I am displaying the columns on jsp. From jsp (Front-end) user may select different columns to get the report. If user select 2 columns (UserID, UserName) and select PDF then on PDF file 2 columns will be displayed with data. If user select 4 columns (UserName, UserAddress, UserId, Email) then on pdf/html it will display a report with that columns and sequence of columns also can be changed. 1. How will I send this dynamic columns (database table field name) to Jasper? I want to generate the .JRXML or report file dynamically based on the user selection. Is it possible any way Using JasperReport API. Please help me. Thanks in advance, Surendra Babu. K. Post edited by: kunkasurendra, at: 2007/08/06 10:18

I had 3 subreports. I uploaded the three subreport files to JasperServer as jrxml files. They are in the repository folder [root]/reports/subreports. Now I want to include them in my main report, which is located in [root]/reports. I edited the subreport references in the main jrxml to look as follows: repo:/reports/subreports/StatusResponse repo:/reports/subreports/workflow repo:/reports/subreports/version In main report : Code:<parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String"> <defaultValueExpression> <![CDATA["repo:/reports/subreports"]]> </defaultValueExpression> </parameter> Code:[code]<connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression class="java.lang.String"> <![CDATA["repo:/reports/subreports/workflow"]]> </subreportExpression> then I got this exception java.lang.ClassCastException: com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.client.ReportUnitImpl Please can any one help me ? Thanks in advance

Hi , I am new to iReport tool, i have created five subReports .how to view this Master Report through parameter. Any one can guide on subreports? Is there any documentaion to help and guide for developing the subreports. Please help me by giving an example. Thanks in advance, Surendra Babu > k

Hi , I am new to iReport tool, i have created five subReports .how to view this Master Report through parameter. Any one can guide on subreports? Is there any documentaion to help and guide for developing the subreports. Please help me by giving an example. Thanks in advance, Surendra Babu > k

Thanks, i will try.

Hi, I am new to JasperReports, Can anyone pl help me. I am looking for migrating from crystal reports to jasper reports. is there a way i could reuse/rebuild the same reports with a minimal effort. my advance thanks Regards, Surendra > K

can i have your source .jrxml file?

Hi, I am new to Jasper Reports. I have one query. I have created one adminstrator, and one user from the jasper server for my clients. I want to provide adhoc drag and drop feature for my administrator. Can someone will guide me on same. Thanks in advance. Surendra.