[Collection in Iframe]

if you use just 1 id instead of 3?

[How do I create this report]

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

[Collection in Iframe]

still on the idTurno? or not working on other variables?

[Print Report Automatically from Command Line in Batch File.]

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.

[Collection in Iframe]

replace the idTurno=1,2,3

with

idTurno=1%2C2%2C3

[How to MS Word sheet margin]

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.

["com.jaspersoft.jasperserver.api.JSException: Error filling report" and "net.sf.jasperreports.engine.JRException: Resource not found"]

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.

[Jaspersoft reporting server running extremely slow when viewing an adhoc or even creating a domain]

Could it be a Java problem? Is there enough memory allocated for Java Heapspace etc.?

[Chart display wrong value from dataset]

What does your Query look like? The one you use to retrieve the data from the database?

[Average calculated in Crosstab]

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.

[Moving elements with cursor keys - broken?]

I only have iReport Designer but it still works.

Product Version: Jaspersoft iReport Designer 5.1.0       

 

[Tables/Populate database ireport]

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 ;)

[Average calculated in Crosstab]

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	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	95.8	75	75	75						96,95
100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	97.9	87.5	87.5	87.5	100	100	100	100	100	98,61

 

[Enlarge detail band, for line break in textfield]

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

 

 

[Custom COUNT in crosstab]

(if $V{variable} <= 10) "" ? $F{variable}[/code]

somethink like this?

 

[Paramteter Question]

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?

[Paramteter Question]

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.

[is it possible to display "detail" band dynamincally, if so how to do?]

great that it works now!

(could you upvote my answer please?)

[Paramteter Question]

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.

[is it possible to display "detail" band dynamincally, if so how to do?]

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 ;) )

[Paramteter Question]

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

[FTP Output doesnt work]

Hmm, i think that setting would be somewhere in an XML under webappsjasperserver

[[XML] Import multiple rows per attibute]

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]

[FTP Output doesnt work]

are you sure its the program that calls for ssl? And not your plugin trying to send ssl?

[bar3DChart/barChart itemHyperlink problem]

are you sure it accepts "http://google.com" or should it be  "http://www.google.com"