[How to repeat values in crosstabColumnHeader?]

Ok, I solved this dilemma.

 

Basically, I introduced one extra group. This group should be leading and this group is invisible (i.e. has 0 size for all elements). And bucket expression for this group combines all id's for subsequent groups... So, the crosstab will always have unique values in leading group and it will forse repeat values in subsequent groups... Voila...

Regards,

Serge

[Crosstabs in 3.7.*]

Same here. It was my mistake in template.

Regards,

Serge

[How to repeat values in crosstabColumnHeader?]

That's not exactly that we are looking for. We have srtict requirements from customer... Is there another way? Flag? Parameter?

Regards,

Serge

[Crosstabs in 3.7.*]

I noticed the same behavior in 3.7.3 as well.

Regards,

Serge

[How to repeat values in crosstabColumnHeader?]

Hello!

I need help with crosstabColumnHeader. I have to repeat values there in CSV and XLS output. Currently JasperReports is goupping same values into one column. Is there any properties on parameter to disable this behavior?

Thanks!

Regards,

Serge

[Print repeating values in Crosstab]

Anyone?

Regards,

Serge

[Print repeating values in Crosstab]

 

Hopefully there will be simple solution for my issue.

I'm having troubles when I'm creating CSV or XLS out of Crosstb. My customer would like to have repeating values in columnGroup and rowGroup, but I can't find any option that will allow me to display repeating values there. My values is always grouped. I tried to set  isPrintRepeatedValues to true for textField, but it didn’t help.

Ideally I would like to see following:

                                Group1,Group1,Group1

                                                Group2,Group2

                                                                Group3

Row1                     Data       Data       Data

Row1,Row2        Data       Data       Data

But Instead I'm getting:

                                Group1

                                                Group2

                                                                Group3

Row1                     Data       Data       Data

Row2     Data       Data       Data

Regards,

Serge

Post Edited by sergeleo at 06/02/2010 06:40 PM

[[solved]Report-creation in application: no data...]

Take a look http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=63316&page=2#63791

Regards,

Serge

[[solved]Report-creation in application: no data...]

I'm using JRDataSource implementation for my application as well. The difference is that I'm passing data to CrossTab. There was a lot of hickups.

Anyway, I don't see any groups defined in your report. Could you please try to create empty group for your field and see if it helps. If not, try to put it into summary section.

Regards,

Serge

[[solved]Report-creation in application: no data...]

Since there is no SQL query involved, there is no need for queryString tag. Just remove it.

Regards, 

Serge

[[solved]Report-creation in application: no data...]

Also, in your test sample I don't see where are you setting data for your datasource. I can see empty constructors. Looks like data isn't present.

Regards,

Serge

[[solved]Report-creation in application: no data...]

Could you please attach your report template as well?

Regards,

Serge

[Blank report generated.]

Or pass JREmptyDataSource object.

Regards,

Serge

[Generating PDF report in browser]

In your HTTPResponse object set ContentType as "application/pdf". Browser will call Adobe plugin to open your document. Make sure that Adobe plugin is installed.

Also I would reccomend to add followin in HTTPResponse Header:

addHEader("Content-Disposition",  "inline;filename=YourPDFFileName.pdf");

It will predefine file name if user will click "Save As"

Regards,

Serge

[Can I modify a field alignment at Runtime ?]

 

Please consider Apache Velocity engine for altering your template before you will call JasperFillManager.

Regards,

Serge

[Modifying page orientation]

r3n4n
Wrote:

I'm trying modify the page orientation at runtime, but the following code doesnt work. Any idea ? Code:

It's not going to work. You have to change pageWidth, pageHeight, columnWidth in your jasperReport template.

[Jasper and a Matrix as a data source]

r3n4n
Wrote:

I have a class Matrix defined by an ArrayList of String[ ]. How can I have the Matrix as a table in my report?

Take a look on JRDataSource implementations. Like:

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/data/JRMapArrayDataSource.html

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/data/JRMapCollectionDataSource.html

[exporting entire data to a single page with CSV]

Please refer to http://jasperforge.org/website/jasperreportswebsite/trunk/config.reference.html?group_id=252

You can filter out content by setting up net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name} property.

More info here:

http://stackoverflow.com/questions/665412/jasper-report-using-same-template-to-render-in-csv-and-pdf-formats

Regards,

Serge

[JRDataSource and Crosstab]

All,

I finally  resolved my issue with placing Crosstab into Detail section. Maybe my workaround can go to FAQ ot Exmaples...

 

1. I switched my code to use JasperFillManager.fillReport(JasperReport jasperReport, Map parameters ) method. I'm not passing DataSource through the method parameter.
2. I'm passing my implementation of JRDataSource as a parameter JRParameter.REPORT_DATA_SOURCE.
3. Also I created custom parameter "DynamicDataSource" and I'm passing same JRDataSource there.
4. Inside of my template I defined subDataset and parameter for DynamicDataSource defined by class="net.sf.jasperreports.engine.JRDataSource"
5. My crosstab placed into Detail section and datasetRun refering to pre-defined subDataset with dataSourceExpression referring to custom parameter "DynamicDataSource"

So, now my reports displays data in Detail section, and I can get advantage of  use pageHeader, pageFooter and all other sections.

 

Regards,

Serge

Code:

	protected JasperPrint fillJasperTemplate(JasperReport jasperReport,			JRDataSource dataSource) throws JRException {		// Preparing parameters		// Setting up virtualizer to have only 2 pages in memory and		// rest on file system		JRFileVirtualizer virtualizer = new JRFileVirtualizer(2, System				.getProperty("java.io.tmpdir"));		Map<String, Object> parameters = new HashMap<String, Object>();		parameters.put(JRParameter.REPORT_VIRTUALIZER, virtualizer);		parameters.put(JRParameter.REPORT_DATA_SOURCE, dataSource);		parameters.put("DynamicDataSource", dataSource);		return JasperFillManager.fillReport(jasperReport, parameters);	}

[JRDataSource and Crosstab]

Lucian,

Thank you!!!
 

I'll set debug for Jasper in my Log4j.

I'm trying something else for my Crosstab /tools/fckeditor/editor/images/smiley/msn/shades_smile.gif. I'll keep you posted /tools/fckeditor/editor/images/smiley/msn/thumbs_up.gif

Regards,

Serge

[Dynamic Column]

There is two ways to acheve it.

#1 Use JasperDesign to build your report in Java.

#2 (I prefer this) Use Apache Velocity template engine to add columns into your template...

Regards,

Serge

[JRDataSource and Crosstab]

Lucian,

How I can enable debugging for Jasper Reports?

Regards,

Serge

[JRDataSource and Crosstab]

I made suggested change and now I have 15 blank pages /tools/fckeditor/editor/images/smiley/msn/whatchutalkingabout_smile.gif

 

((net.sf.jasperreports.engine.data.JRBeanCollectionDataSource)$P{REPORT_DATA_SOURCE}).cloneDataSource()

Regards,

Serge

Post Edited by sergeleo at 09/10/2009 07:01 PM

[JRDataSource and Crosstab]

Same report, but Crosstab in Summary.

[JRDataSource and Crosstab]

Lucian,

 

Please see JRXML and PDF attached.