[How to read VARIABLES of subreport in main report?]

I have never done this but there is a return variables tab in the properties of the sub report.

High leve I think you have to setup variables in both reports and set the caculation type to system.

[Can 2 backgrounds be placed for a jrxml]

Use the print when statement

 

[Error passing date-parameter into subreport increm]

Make sure you are not assigning $P{von} to $F{some value} under the parameter settings.

Post Edited by Chris Collins at 01/30/09 22:30

[iReports -- Four Condition Statements]

For number 3 this may work

Not Tested

new Boolean($F{amount}.intValue() > 1000 || $F{amount}.intValue() < 10 : "true" ? "false")

[Passing Parameters using XML datasource..how?]

Not sure if this is it but you must have the $P{name} setup in the master and sub report.

If I am creating a variablel parameter I set the value with a statement like the one below.

 

 

Code:

($F{varname}.equals("ups")?"Today's Ups":$F{varname}.equals("avg")?"Today's Avg ":"NOTHING")

[Creating Multi page pdf in jasper]

Use SELECT 1

It should work to fire off the report

[Line Charting hourly values]

I see what you are saying.  I think you will need to do this in the query with some case statements.

Checkout this site for help with that http://www.artfulsoftware.com/infotree/queries.php?&bw=1280

 

Or you could do a variable with an if statement where you use the value

($F{hour1}?$F{hour1}
:$F{hour2}?"$F{hour2}
etc

:"")

But , really what you want to do is change the db to use relational db.  the code below is what I would do.

 and then your query would be like this which would give you what you want.

select h.hour,c.name from data_table

join hour_table as h on h.ref = c.hour_ref
 

Code:

Post Edited by Chris Collins at 01/27/09 17:56

[open report in linux]

Be specific about what you are running and what the problem is.

[Creating a report with dates as columns]

Edit the report properties edit->report properties.

click on the more tab

set the print order to horiz

[Line Charting hourly values]

I usually do this. select name,date,value from table where date = curdate()

• Draw a chart of type line in the summary band

• Edit the properties of the chart

Click on the chart tab

Click on edit chart properties

Click on the chart data tab.

Click on details tab.

Click on add.

• For series expression use $F{name}

• for category expression use $F{date}

• for value expression use $F{value}

• Run the report

Post Edited by Chris Collins at 01/23/09 20:21

[syntax error on token "49" delete this token]

Seemed to be the preset size of a4. A letter size works fine.

[urgent]

You need to be specific in your title, and question.

 

ALWAYS check the docs and search the forums before asking a question

[report with two different datasource(without subre]

You will have a write your own datasource if you want that.

 

[Check parameter value]

Google java date subtraction.

 

[query and tablename]

I have never gotten that to work.

[TimeSeries Chart: Null Period argument error]

You may need to cast the field as date type.

In the past I used CAST(date_format(date , '%Y-%m-%d' ) as DATETIME) as date

but that is MySql

[Alignment of elements when using many subreports]

I have had success setting the "print if first whole band" to true in my first sub report

[Subreports Crashing Master Report]

I usually use a simple query to at least get the details band to print so my subreports will get called.

" select 1 "  should get you going

[Display value on each category of piechart? Urgent]

set the label expression

new String("something " + $F{value}.toString())

[Dynamic Column(Urgent)]

What you are asking should be easy by setting up the column in the report settings.

 

 

 

Post Edited by Chris Collins at 01/20/09 21:20

[I need the details band to repeat, regardless...]

do this in your query..

not tested and There are much better ways to do it but this is simple and readable.

(SELECT site,"1" as n FROM site_table LIMIT 1,1)union(SELECT site,"2" as n FROM site_table LIMIT 2,1)union(SELECT site,"3" as n FROM site_table LIMIT 3,1)etc[/code]

or build your own data source but that is a big topic.

Post Edited by Chris Collins at 01/20/09 21:14

Post Edited by Chris Collins at 01/20/09 21:15

[syntax error on token "49" delete this token]

So, I have this simple query

which will return two rows and one column

I keep getting the above error on the compile of the report but unlike normal errors it does not tell me where this token is.

I have been useing this query for a couple of years on several reports so I must have done something.

 

Has anyone seen this before?

Code:

select type FROM node_ref_table where type = 'OPRA' or type = 'IDN_RDF'group by type

[How to handle dynamic fieldsets in a report?]

Maybe this will help...

Use a print when function and make sure your fields are named the same.

select a,b,c,"nothing" as d from db

select a,b,"n" as c,"nothing" as d from db

Then do a print when expression

new Boolean($F{c}.equals("n") ? "False" : "True")

[Anyone else have prob with functionality in forum?]

It is to the point I can not answer or post.... and it is not my machine it happens on linux and xp

[iReport is not saving 'Connections/Datasources"]

Then I think the settings are saved in the following c:/documents and settings/username/.ireport/config.xml Make sure it is writeable.

 

notice the (dot) in front of ireport

Post Edited by Chris Collins at 12/17/08 21:57