[Create Crosstab]

Hello,

 

I want to create a crosstab, I know that it is possible and I already created crosstabs with iReport, but I absolutely cannot find the Function for the creation of a Crosstab.

 

Could you please tell me where I have to look?

[three textfields in a row]

Put them in one textfield and add the strings with +

like "justSomeText " + $F{Stringfield} + " " + $F{anotherStringfield}

[Subreport Return Value]

I switched my Database from Access to mySQL and the Chart (XY-Chart) works.. the Timechart not.

Unfortunately I don't know WHY it works now, but at least we know that it is possible.

[Make connection expression]

I read that you posted a feature request about this, and that you posted, that you created a subreport from a different datasource than the master report. Please tell me how to do this.

[doubt in sub report]

First of all, 0.4.0 is totally outdated, actual Version is 1.2.5, go and get it from http://jasperforge.org/sf/projects/ireport

 

Then you can use subreport return values, like I wrote in the last post.

[setting backcolor at runtime for a text]

I think that rajesh thought of setting the background color at runtime.

I have an idea for this: take 2 fields, one for each background color, and let the two field be displayed in change by setting the "display when expression" in a way that it is true every second time.

[how to conditionally display a field value?]

the FIELD is Double, so put a "new Double()" around the whole sentence and it will work.

If you just dont want to DISPLAY something,use the "print when expression" in "common" of any field.

[Overlapping Subreports]

Don't forget to check if you really need so much subreports- maybe you can do the same thing by using Groups? It is really seldom neccessary to use a bigger amount of subreports and most Reports don't need subreports at all.

[Make connection expression]

I found out that it is possible to set a connection expression for subreports that does not have to be the connection expression of the main report.

But how do i make a new connection expression? I even cannot read the connection expression of the main report because iReport does not let me.

Maybe I only need to know the syntax of a Report Connection.

 

I need this Information because this seems a way to have more than one Datasource in a Report. I have to use several Databases and if I do not find a way to do this with iReport, or a simple Way to put everything in one Database, I may be forced to use Crystal Reports. I would prefer to stay using iReport.

[doubt in sub report]

make a Variable in the main report for each of both values. make a subreport return value and connect the value from the subreport with the Variable of the main report. add the variables and display them in time= "band".

In subreport(others) you can set the subreport return value.

[Fields that only show up on the last page]

Fields you put in the "summary" area will be displayed at the end of the report, fields you put in the "last page footer" will be displayed at the end of the last page and fields you put in the "page footer" area will be displayed at the end of each page.

[doubt in sub report]

Ok, that is possible. What is working now, and what is still to do?

[Subreports in different data sources]

I read about subdatasets, but i think that they are only for Charts and Crosstabs, not for Main or Subreport. But maybe something has changed since iReport 1.1.0?

 

I also need to know if it is possible to use more than one Datasource in a Report or if I have to design and build a special Database just for Reporting.

[Use Subreport return value for charts?]

Ok, its working.

I changed the x-values to

 

new Double

(

(new Double(0).valueOf($F{Uhrzeit}.substring(0,2))).doubleValue()+

new Double(new Double(new Integer($F{Uhrzeit}.substring(3,5)).intValue()).doubleValue()/60.0).doubleValue()

)

 

and get Minutes.

 

I still do not know how to get the time-chart working, but thats not urgent anymore.

 

Thanks for your help!

[Use Subreport return value for charts?]

I changed the Database from Access to mySQL and now the Charts do display something. The XY-chart displays the number of Telephone lines per hour and the Time-Chart displays only a dot at 00:00:00 and 0..

but i would like to have a chart of time and the used telephone lines per minute.

 

The X-Value is calculated by:

 

new Double

((new Double(0).valueOf($F{Uhrzeit}.substring(0,2))).doubleValue()+

(new Double(new Integer($F{Uhrzeit}.substring(3,5)).intValue()/60)).doubleValue())

 

$F{Uhrzeit} is the time as a String in Format '23:59'.

 

the Y-Value is just the number of Lines (Integer).

 

This Chart displays the number of Lines per hour, but should display per minute.

 

The Times Series Dataset seems to display a null-value.

 

It gets its time-value from this:

new SimpleDateFormat("HH:mm").parse($F{Uhrzeit})

 

Both charts have Reset Type="Report" and Increment when expression = "new Boolean(true)"

 

Do you have any ideas?

[Passing parameters between subreports]

Thats working! I set calculation=system and resettype=report (Variables in master report), and now I get the variable from the subreport to the mainreport and back to the subreport in the next row. Thank you.

[Passing parameters between subreports]

I understand the first solution, but not the second one. Could you describe what you mean with a holder?

 

i cannot use the first solution (and maybe not even the second) because I have only one Subreport in the Detail Band, that gives a return value back.

I want to take a value from the subreport and give it to the (same) subreport in the "next" detail value.

I want to use this to start calculating values in the Subreport from a startpoint I know from the last Subreport. I want to use this for faster Report generation.

[Passing parameters between subreports]

I also have a Subreport in detail Area, and I am able to get return Values from the Subreport, but it seems impossible to give the Subreport return Value to a Subreport as parameter.

Is it possible to pass Values between Subreports?

[Passing parameters between subreports]

I also have a Subreport in detail Area, and I am able to get return Values from the Subreport, but it seems impossible to give the Subreport return Value to a Subreport as parameter.

Is it possible to pass Values between Subreports?

["Bericht1" of type NMTOKEN must be a name token.]

Try it with a Report Name without blanks (Leerzeichen).

[Use Subreport return value for charts?]

Is it possible to use return Values of a Subreport for generating a chart?

I have a Subreport in the detail Area that returns a number. I want to use these Numbers, generated in each detail Area, in a Chart.

Do you know if this is possible?

[Migrating from IReport 1.2.1 to 1.2.5]

You can use more than one version of iReport at the same Time, so migratng should be easy. In earlier Versions the were Problems with forward-compatibility (i.e. you can use crosstabs in newer Versions, if you open these Reports with a older Version of iReport like 0.5.2, the Code for the Crosstab will be deleted).

[Subreport Return Value]

If you know a way to use a subreport return value for charts, please tell me..

[chart from integer and date?]

I want to use Integer for the Y-Axis and a Time for the X-Axis, but it looks like the charts do not accept Time values. Is the a way to use Time Values and display them as Time Values?

[Subreport Return Value]

I also want to use the return values of the subreport for a chart, but the chart does not display anything. I use the workaround for the 1.2.5.-Chart-Bug and if I set a fix Number, a chart is Displayed.