sagarnikam123
-
Posts
39 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by sagarnikam123
-
-
@ajinkya_c, How to send request for any bug/enhancement in Tracker for jasperserver/iReport,Can u tell me in short ? Thanks in Advance !!!
-
I am having two input for dates as below & want to set alert for that
Alert:- If difference between StartDate & EndDate is more than 6 months,it must generate alert / prompt panel showing text "Month Period exceed than 6", & report should not proceed.further, untill & unless the user select dates between any six months.
-
Also,when I upload,the same over jasperserver,first table prints fine on first page,but on second page,second table splits into 3-4 next pages,having single column on one page.I tried with "columnbreak offset"=0 & =5 of crosstab,but no effect
-
I am using Windows Server 2008 R2 Standard,iReport-4.8,
I have field which is dynamically filed with month names in crosstab,I tried with "data presorted" option in crosstab, ON as well as OFF.There is not effect on output. But months names are sorting alphabetically.
see highlighted square as in figure. How can I do it by Regular months sorting ?(jan,feb,march,april,may...so on)
Also I want to remore columns lines & make it single row ,without lines interfering (see 1st row with 1 number), so I removes all padding & borders of columns ,even though it shows below.(Indiacated by arrow)
-
Does this bug,present in iReport-4.8,where can I find that (bug list) ?
-
Does this bug,present in iReport-4.8
-
@ajinkya_c & @Sanbez,call u tell me properly how to write A customizer class & where to put it,just to show value axis tick labels.I seen some customized class samples,but they are out of my control to understand
-
I am using Ubuntu 12.04, iReport-4.7, MySQL database, mysql-jdbc driver
I write stored procedure in MySQL
DELIMITER //CREATE PROCEDURE first()BEGINselect * from person where id in (11,22,33);END //DELIMITER;
which return id & name as fields & calling it from iReport
select id+1,name from (call first)
gives me syntax error,
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'call first)' at line 1
but when I run call first in query executor,no error
How should I get required field for further calculations ? Does this is possible in MS-SQL ?
-
@jbernat , Can You explain in Details,because I can run stored procedure,but can't get required field from Resultset.e.g. select FieldName from (call my_procedure)
-
I am using ireport4.8 windows,I want to printed whole report in summary band (I tried using another band many times,but not giving good views,so I choose summary band)
I have 1) main report- with 2 table & 2 chart , 2) subreport-with 3 charts as below
1) I have put "page break" line where I indicated, but it is not working.I want to show subreport-1 in next page (also If I adds another subreport-2,want to show as separate page)
2) why second chart (right in Main report) floats in table(encircled) ? problem is when I specified it "relative to bottom",it goes in sub-report.But the left one when specified floats it stays in its position.I want to show them side by side
I used "summary" band in subreport also to print the contents
-
@ajinkya_C,I select "Check ON",on all properties below ,1)Value axis Vertical Tick labels 2)Category Axis Vertical tick labels 3)Show Labels 4)Show Legends, but its not showing values over tip
-
can u tell me according to ireport 4.7
-
@ajinkya_c,thanks, It works for Pie charts using "Legend Label Format" as {0} {2}, but for Bar chart,there is nothing like "show value" in Properties for Ireport 4.7
Can u elaborate more on how to set property ?
-
I am using iReport 4.7 community edition,ubuntu 12.04,making report & viewing it in both iReport and in HTML format, in chrome browser. I put 3D bar chart in summary band and want to show value on its tip (i.e. on top).So I go by below way.
1) check on
show Labels
&show Legends
in 3D Bar Chart Properties2) Right click on Chart > Chart Details > Details > Category Details > by selecting category,Modify > Item Hyper link > Tool tip > Tool tip Expression >
$F{dayname(ServiceDate)}.toString()
, where$F{dayname(ServiceDate)}
is field nameeven though, its not showing anything
Is this facility not present in community edition ? Should I embed any other .jar file for that ?
-
there are 2 blank answers
-
I have two crosstabs & two chartsIf I put crosstabs in detail band, error comes "Error filling print... Error incrementing crosstab dataset"when I put both in summary section,along side of Charts,then charts mixes with them as belowI tried option,float,Fiexed Relative to Top & firxed relative to bottom,but no effect.& How should I format field name called "month_name" which show months in crosstab? I want it to be, when month between Jan to Apr,column should be green
-
I have below query in Report query wizard of iReport
select docid_fname_pemid.*, MONTHNAME(b.ServicePeriodDate) as month_name,YEAR(b.ServicePeriodDate) as year_name , b.NonLTCMaximumSpecialPayment, b.NonLTCEnrolledPatientOutsideUseTotal, b.NonLTCAccessBonusfrom (select docid_pemid.PEMID, docid_pemid.DoctorID, b.$P!{transparency_check})from (select DoctorID,PEMID from DoctorPEMMap where PEMID in ($P{PEMID_input}) and StartDate >= $P{StartDate} and (EndDate <= $P{EndDate} or EndDate <= '0000-00-00') group by PEMID order by PEMID)docid_pemid left join Doctors b on docid_pemid.DoctorID=b.DoctorID) docid_fname_pemidleft join DoctorPayments b on docid_fname_pemid.DoctorID=b.DoctorID
[/code]& parameters,as in order (Parameter class, Prompt Yes/NO, Default value Expression)
1)
PEMID_input
--> string, prompt yes, no2)
month_year
--> .String,prompt yes, no3)
transparency_input
--> String,prompt yes, no4)
transparency_check
-->String,No prompt,($P{transparency_input}=="yes" ) ? ("FirstName") : ("AliasFirstName")
5)
StartDate
-->String,No prompt,$P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") : $P{month_year}.split("-")[1].concat("-10-01")
6)
EndDate
-->String, No prompt,$P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31")
when retrieving fields automatically,gives "Error:null"
I ignore that & proceeds further to run.
It runs when given transparency_input="yes",but when I give transparency_input="no",error occurs->Error filling print... Unknown column name : FirstName Setting up the file resolver...
I want dynamic value of transparency_check to be either "FristName" or "AliasFirstName",which depends upon transparency_input("yes"/"no") parameter (look in question in parameter section)
I think query not getting
'b.FirstName'
. So I used concat function asconcat('b.',$P{transparency_check})
, but it not works.[/code]How should I go ?
-
I have few parameters,as (Parameter class, Prompt ?, Default value Expression)
1)PEMID_input--> string, prompt yes, no
2)month_year--> .String,prompt yes, no
3)transparency_input--> String,prompt yes, no
4)month--> String, NO, $P{month_year}.split("-" )[0]
5)year-->String ,NO, $P{month_year}.split("-")[1]
6)StartDate-->String,No, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") : $P{month_year}.split("-")[1].concat("-10-01")
7) EndDate-->String, No, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31")
8)month_selector-->String, No, ($P{month_year}.split("-")[0]=="April") ? ($P{month_year}.split("-")[0].concat(",May,June,July,August,September")) : ($P{month_year}.split("-")[0].concat(",November,December,January,February,March"))
all parameters giving values in report when running with no queries(I tested them).
when I am running query by replacing parametera to values, it also works fine
but when running with paramete gives, Error:null. while retrieving fields in Report Query wizard
even though I run report,& give specified parameters it give below error
=====================================================================================================================Error filling print... Error executing SQL statement for : access_2Setting up the file resolver... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : access_2at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1073)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1253)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276)at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745)at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891)at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''FirstName'from ( select DoctorID,PEMID from DoctorPEMMap where PEMID in ('21' at line 3 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239) ... 12 morePrint not filled. Try to use an EmptyDataSource...
==================================================================================================================================================================
I have below .jrxml file attached
-
I want to check current month to many condition as below. so I take
TextField
,edit its pattern toMM
& in expression editor edit below codenew java.util.Date()>=4 && new java.util.Date() <= 7 ? "Q1" : new java.util.Date()>=8 && new java.util.Date() <=11 ? "Q2" : "Q3"
[/code]but it gives error
Error filling print... Error evaluating expression : Source text : new java.util.Date()>=4 && new java.util.Date() <= 7 ? "Q1" : new java.util.Date()>=8 && new java.util.Date() <=11 ? "Q2" : "Q3" Setting up the file resolver..
[/code]but when I give expression like
new java.util.Date()== 4 ? "Q1" : "Q2"
[/code]It works fine.
Does iReport not able to resolve multiple conditions ? or should I give different
TextField
with single condition ? -
-
-
-
I dont want to use subreport,even i used that also,it create problem of importing parameter,some fields from main report.
Any how the problem is going to same. @ajinkaya_c can u tell answers for my questions,asked in bottom ? may be logic how to proceed using any tutorials
-
@ajinkya_c sir,there is only one page to show,no next page
com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error evaluating expression :
in Products
Posted
I am using Windows platform,iReport-4.7 & Jasperserver-5
my report works fine on iReport,but gets exception on Jasperserver as below
to solve I added rt.jar (which contains java.text.SimpleDateFormat Class) into JasperServer directory--> /apache-tomcat/webapps/jasperserver/WEB-INF/lib/rt.jar
& restarted all services ,even though below error remains same
Error Message
Error Trace