sjoerd.jump
-
Posts
74 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by sjoerd.jump
-
if you use just 1 id instead of 3?
-
Fo that i would use a crosstab. Google iRerpot Crosstab and "add measures to crosstab" Rows for "Sr No. " and columns for type, categrory slab paf min innvoice
-
still on the idTurno? or not working on other variables?
-
Print Report Automatically from Command Line in Batch File.
sjoerd.jump replied to y2k2h's topic in Products
Im going to give a very short answer because I'm doing other stuff, see if you can follow it trough. If not, please let me know here and I'll type some longer answer :) First. Scedule a job for your report and write down the JobID. Make sure it's sceduled somewhere in the distant future. Install Jaspersoft ETL and create a new job. In this job, add a tREST element Your tREST element sends a call to your jasperserver to execute a certain JOB id My code for the tREST is: URL: "http://localhost:8080/jasperserver/rest_v2/jobs/restart/?j_username=jasperadmin&j_password=jasperadmin"First.[/code]The body element has. "<jobIdList><jobId>1287</jobId></jobIdList>"[/code] HExport the tREST project, extract the zip, find the BATCH file and add that location to your own BATCHFILE. -
replace the idTurno=1,2,3 with idTurno=1%2C2%2C3
-
Is your page in iReport the same size as the A4 format? default settings of the iReport page are: 842 x 595 default margins are 20 20 20 20. Cross check this with your Word. There might be a conflict there.
-
At a first glance this looks like a path issue Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : ////reports////subreports////report8_subreport1.jrxml[/code]I'd say, check your path. I encounterd a similair issue when running a report with subreports in iReport Designer while the report was on the Jasperserver (imported via the repositorybroweser) Later i figured i only could preview the report through the Japserserver.
-
Could it be a Java problem? Is there enough memory allocated for Java Heapspace etc.?
-
What does your Query look like? The one you use to retrieve the data from the database?
-
Right now I use a workaround have added a variable to my report that calculates an average availablity over the 2 systems. In the crosstab i have added a new measure with my new variable as expression, set to average again. This is now an "average average" just what i was looking for.
-
I only have iReport Designer but it still works. Product Version: Jaspersoft iReport Designer 5.1.0
-
Hi d.kanhar Yes you can. You have to add the new database as an datasource in iReport to be able to work with it. This is how I work with my data. I have created a database in Postgresql, created the tables and such, loaded it with some test-data. Made the connection in iReport to the database and correct table. Created my report based on the test-data Set up jaspersoft ETL to load data to my database Set up jaspersoft Server to send me a report on a daily basis based on the data loaded by Jaspersoft ETL. easy does it ;)
-
Hi Guys (and girls) Im struggling with the following problem in iReport: I have a crosstab with uptimes for 2 systems. (the top 2 rows) over the past month.Now 1 system went down somewhere during the month (decreasing uptime percentage) and our supplier made arrangements to have the problem fixed. This would take some days to fix so we agree to _not count_ the system availability (does this make sense?) Anyway. After evaluating the availability KPI I run into a disagreement with my supplier. Jasperreport says the Availability is 98.61% but Excel thinks it's 98.72%This is caused by Jaspersoft calculating the Average based on ALL the cells in the first 2 rows where Excel calculates it based on the AVERAGES per day.Is there any way to change the calculation inside Jasperreport from cell to average per day? Cheers, Sjoerd 100 10010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010010095.8 757575 96,9510010010010010010010010010010010010010010010010010010010010010010097.987.587.587.510010010010010098,61
-
Enlarge detail band, for line break in textfield
sjoerd.jump replied to schorsch262's topic in Products
since this is the first hit on google (and i was looking for the same answer). ad a <br> where you need the break and set "markup" for your textfield to html. Easy does it :) http://community.jaspersoft.com/questions/538132/can-i-place-carriage-return-text-field-within-ireport -
(if $V{variable} <= 10) "" ? $F{variable}[/code]somethink like this?
-
thanks, thats it indeed :) The problem was that i tried to send the parameter to a crosstab and had to add the parameter to the list of the crosstab. Do you happen to know how to export the entire report including sub-datasets to jasperserver?
-
Solved it: I was using a crosstab and never thought of passing the Parameter to the crosstab! So, in crosstab data, go to Parameters. Add parameter with the value of the parameter you have set up in the main report.
-
great that it works now! (could you upvote my answer please?)
-
hmm, thats not working. Have tried to shorten the query (since im only intresed in a month) to where $P!{parameter1} = extract (month from datum) If I subsitute $P(parameter1) for '5' than i see the data in my table im looking for. I have set parameter1 to java.lang.double since thats the format of an extracted part of a timestamp.
-
From the top of my head: Click on "detail band" and at the properties where you read "prin when" add a code like : $V{REMAKRS} != null (or search for detail band print property ;) )
-
Hello, I have a question about paramaters: What i want to do is extract the MONTH from a date. and use this in a query. So far I did the following: Creacte parameter1 Set -> java.util.date In query: select datefrom tablewhere extract(year from date) = extract(year from current_date) and extract(month from date) = extract(month from $P{parameter1})[/code] Date in my databse is formatted as yyy-MM-dd What am i doing wrong? Can someone help? thanks sjoerd
-
Hmm, i think that setting would be somewhere in an XML under webappsjasperserver
-
Hey Guys, i have a question about importing more than 1 row per XML field. Im trying to import an XML file into a PostgresQL datbase. For the life of me, i cant figure it out. Jasper ETL seems to only extract 1 row per field. For instance; [ROOT] [FIELD1.1] [ROW 1] [ROW 2] [/FIELD 1.1] [FIELD1.2] [ROW 1] [ROW 2] [/FIELD 1.2] [/ROOT]
-
are you sure its the program that calls for ssl? And not your plugin trying to send ssl?
-
are you sure it accepts "http://google.com" or should it be "http://www.google.com"
