[two separate lists in one report?]

Hi, I have to generate a report which includes two different lists (the datasource is the same, so that's no problem).

 

It should look something like this:

 

 

(ColumnHeader)

Name Adress CustomerId

(DATA)

 

 

(second ColumnHeader)

Surname Lastname Birthdate Income ...

(DATA)

 

is something like this possible without using subreports or do i have to use them? (i wanted to know this before i start realizing it)

 

I hope someone has a hint for me, because i can't yet imagine how to realize that report as required ;-)

 

thanks in advance

[oracle instead of mysql]

hey Sherman,

thanks a lot for your answer!!! that was exactly the information i was looking for ;-)

Post edited by: wegnerk, at: 2007/05/11 07:49

[oracle instead of mysql]

Hi, i am a newby to jasperserver and i have to evaluate some possibilties for our new project...

 

so, is it possible to use an oracle database for metadata / users and so on instead of a mysql database? When installing JasperServer, i can only choose to install mysql or to use an existing mysql db.

 

Thanks in advance for your answers...

[strange behavior when generating csv file]

Hi, thats not a strange behavior, because the export to csv is gridbased... so you have to watch the alignment of the fields...

 

 

look here for more information:

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=23618#23618

 

[JasperReports on Struts Help..!!!..got an error.]

is that really wanted?

 

Code:

 
InputStream reportStream = getServlet().getServletConfig().getServletContext().
   getResourceAsStream( "/jrxmls/jasperreports_demo.jasper.jasper" );

 

seems not to find the correct file or did you get the output of

Code:

[code] System.out.println("Done Reading jrxml file !!!"«»);

Post edited by: wegnerk, at: 2007/04/17 13:47

[JR with other Programming Languages]

Hi alltogether...

 

i have to make an overview over the possibilities that JR offers for Reporting and the question arose, if there is any possibility to use JR not with Java, but with other languages such as .Net or Ruby or something.

 

Does anyone has experiences with this or ideas/meanings... and can share them with me?

 

That would be great!

Post edited by: wegnerk, at: 2007/04/17 13:56

[Conditional display of fields]

You can use the printWhenExpression of the textfield. In IReport, go to the properties of the field and under "common", you can find it... the printWhenExpression needs a boolean value.

 

for example: if you only want the field to be print when it is empty you could write something like:

 

($F{field} != null) (depends on the datatype, what you have to write exactly...)

[User Interface for Report Design]

look for IReport under projects...

[Operating System Support]

linux and windows are both no problem, it is completely implemented in java...

i don't know aix and as400, so i can't say anything about that.

[Open new browser for the report!]

you could set the response like this:

 

Code:

response.setContentType("application/pdf");
response.addHeader("Content-Disposition", "attachment;filename=report.pdf");

 

the bold part is the important thing, so you get a popup window which asks if you want to open or save the file. But it opens the pdf in the appropriate application, adobe reader for example.

 

of course you can choose another filename...

 

Don't know, how to open it in a new browser window... are you working with jsp or what? perhaps you could give the button a target="new" or something...

 

hope this helps...

Post edited by: wegnerk, at: 2007/02/07 13:39

[Report more than one page]

it would be easier to understand your problem, when you post some code or more information here.

 

do you get an error or something? if you have enough data, the report should not stop at 5 or 6 pages, i had some reports with more than 30 pages without problems...

[Solved -variable "before" data is there?]

We solved it by changing the sql-view itself, not the report...

____________________________________________________

 

Hi all...

my problem is a bit complex, but i try to explain it, so i could be understood.

 

I have three reports (monthly, quarter, yearly) which displays data for some forecasts. The structure is obvious; so in the quarter report the months are taken together in quarters; and in the year report, the data for the whole year is displayed (grouped).

 

Now, it could be, that a month has a specific value, like "no forecast entered", which should be displayed in the monthly report like all the other values.

But in the quarter or year report, it should only be displayed, when there does not exist another dataset for that quarter or year. If there are datasets for that quarter/year, the dataset "no forecast entered" should NOT be displayed.

 

I tried it with a variable, which counts the real datasets in one year, but that does not work properly, because it is set too late for me.

 

does anyone has an idea of how i could define that variable or something?

 

i use jr 1.3.0 and a hibernate connection in a java web application.

Post edited by: wegnerk, at: 2007/02/07 13:53

[Choose Printer]

i also had that problem and for me, it worked like this:

 

Code:

PrinterJob job = PrinterJob.getPrinterJob();
PrintService service = job.getPrintService();
PrintRequestAttributeSet printRequestAttributeSet = 
  new HashPrintRequestAttributeSet();
printRequestAttributeSet.add(MediaSizeName.ISO_A4);
JRPrintServiceExporter exporter = new 
  JRPrintServiceExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, 
  jasperPrint);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_REQUEST_ATTRIBUTE_SET, 
  printRequestAttributeSet);
exporter.setParameter(JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET,  
  service.getAttributes());
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PAGE_DIALOG,
  Boolean.FALSE);
exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG,
  Boolean.TRUE);
exporter.exportReport();

[Hi, I'm new in JasperForge - beginner question]

the jrxml file is necessary, because this is where you define, what your report looks like.

You can open IReport and generate a new report, where you can set your fields (database fields) and variables and parameter as you like.

 

in java, that jrxml template is compiled and filled with data.

 

If you really want to work a lot with jasper, it would be very good to buy the documentation or a book about it, because at the beginning it could be quite tricky...

[Hi, I'm new in JasperForge - beginner question]

Hi Yael,

 

if you want to use jasperreports in your java-application, download JasperReports (the newest Version is 1.3.0), take the project.zip. the jar is in the DIST/subfolder.

 

under demo/samples, you find some example reports with java classes and jrxml files, where you can see how to use jasperreports in java.

 

For creating a report, install IReport, there you can visually design a report, create a database connection and query and test the report.

 

hope, this helps a bit

[Default detail record when no details found]

I solved this for my report like this:

 

first, i defined a parameter "noData" with a default text like "Sorry, no values" and placed a textfield with that parameter in the summary band.

 

then i used the printWhenExpression of this field like this

Code:

 Boolean.valueOf($V{REPORT_COUNT}.intValue() == 0)

 

and i didn't want the detailband to be printed empty, i just set the report property whenNoDataType to AllSectionsNoDetail.

 

Like this, my NoData is only printed when the report_count is 0 and detailband is not shown.

 

Hope this helps...

[Repeating column headers in excel]

I had a similar problem and i solved it by a parameter fileformat and the pagenumber.

 

the fileformat is a parameter which comes from my java application and contains pdf, xls or something.

 

Now, i used the printWhenExpression for the bands pageheader/columnheader. So, if the fileformat is xls and the pagenumber is higher than 1, don't print these bands. For pdf, print it always.

 

When exporting to xls, i also used the

Code:

(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE)

 

I hope this helps a bit

[export using specified delimeter]

yes, you can set the delimiter in your java-method when exporting to csv.

 

Code:

JRExporter csvExporter = new JRCsvExporter();  
csvExporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, ";");        
csvExporter.setParameter(JRCsvExporterParameter.RECORD_DELIMITER, "n");

 

the parameter FIELD_DELIMITER is especially for separating the fields...

 

 

hope this helps

Post edited by: wegnerk, at: 2007/01/31 06:39

[bug : extra columns in excel export]

it is a problem of exporting in xls, which you can only fix by rearrange your columns like it is described here:

 

http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ9

 

[How to change SQL of subreport]

How does your SQL-Statement looks like? Perhaps you can give the subreport a parameter which contains the query or some dynamic information.

 

but it would be easier if one could see your query.

[parameter problem]

How is your parameter defined? did you tried:

 

select * from countries

where CountryID=$P{ValueID}.intValue()

 

The problem is, that your parameter is an Integer, but the CountryID from the DB is only int.

 

Don't know, if that can help a bit...

[Print When expression doesnt work]

First, there is an error in that code, you write ${Remark}, but it has to be a field or variable or parameter like the first one $F{Remark}.

 

there exists another property, removeLineWhenBlank. If you use IReport, you can check that property.

i didn't use subreports so far, so i don't know, if that works in that combination.

[Replace boolean with yes or no]

if your field is of type String, you have to take the .equals() function,

 

so

 

Code:

$F{loggedIn}.equals("true"«») 

and so on. Or, if you are not sure, if its lowCase or not, you can take equalsIgnoreCase("")...

 

Hope this helps a bit...

[Replace boolean with yes or no]

you could use the PrintWhenExpression of that textfield.

 

I don't know, how it looks like, so it is a bit speculation...

 

so, try it like

 

$F{DBField}==true : "yes" ? "no"

 

or something similar. For that, the textfield has to be a String - field.

 

hope this helps a bit

[background color issue]

Hi, i am not sure if this is a bug. Don't know exactly how html-export works, but it is possible to set a parameter while exporting, where you can set some html-background true or false. Perhaps it has something to do with this point.

 

Code:

(JRHtmlExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE)

 

So, perhaps you have to look in that direction.