Bug Tracker Incident #7149

 


Summary
Project
INCDT - OpenRPT
Incident Category
Bugs
Incident Number
7149
Visibility
public


Product Version
None
Fixed In Version
3.0.0Alpha-openrpt


Summary
Simple CrossTab addition


Description

Hereby the code that implements a simple form of an CrossTab element. It has support for vertical and horizontal wrapping.

There is also some code for changing the size of the toolbar icons.

Some additional toolbar buttons are added for convenience during testing.


Details
Reporter
mstegehu
CRM Account
xTincident Default Account
Status
Closed
Assigned
cryan


Priority
Normal
Severity
Patch
Updated
09-06-12 15:40
Resolution
Fixed



Comments

DateUsernameComment
03/04/11 08:25mfgadmin

Additional Info:

Open issues are mentioned in the CrossTab render code.

1. Tables larger than 2 pages wide or hide are not tested and not likely to work.
2. In release mode the output differs in color.
3. Fonts from property edit dialog are not used in renderer.

Design issues:
1. parsexmlutils should be used both in writer and renderer.

03/04/11 08:25mfgadmin

Hereby the code that implements a simple form of an CrossTab element. It has support for vertical and horizontal wrapping.

There is also some code for changing the size of the toolbar icons.

Some additional toolbar buttons are added for convenience during testing.

03/29/10 11:26gmoskowitz

The crosstab functionality now exists but is extremely fragile.

11/06/09 16:09cryan

After reviewing the attached sample report and data I made a minor tweak to fill the image white prior to processing to prevent strange image rendering problems otherwise this is all working correctly.

11/06/09 16:08svn

Revision: 375
http://openrpt.svn.sourceforge.net/openrpt/?rev=375&view=rev
Author: cryan
Date: 2009-11-06 21:07:46 +0000 (Fri, 06 Nov 2009)

Log Message:
-----------
Uncommented line that filled image with white. Issue #7149.

Modified Paths:
--------------
openrpt/trunk/OpenRPT/renderer/orprerender.cpp

08/26/09 08:55jrogelstad

Great, thank you, we''ll take a look.

08/26/09 07:37mstegehu

jrogelstad,

I just added an archive with three files:

SimpleCrossTabTemplate.sql - Contains the MySQL Backup file of the used data.
SimpleCrossTabTemplate.xml - Contains a template that uses the Simple CrossTab.
SimpleCrossTabTemplate.pdf - A pdf with the output.

Versions used:
QT 4.5.2
OpenRPT 3.0.0rc (Sorry, just used the code I had here. Due to a firewall issue I am not able to SVN or cvs).

Please do not hesitate to contact me if you encounter another problem.

Regards,

Marcel

08/24/09 08:56jrogelstad

That would be super. Thanks!

08/24/09 02:33mstegehu

Hello,

Yes I can. Please give me a few days to anonymous a report.

Regards,

Marcel

08/21/09 15:45jrogelstad

mstegehu,

In over a year we have never been able to get this to work. Could you please supply an example report?

Regards,

John

08/20/09 15:56svn

Revision: 364
http://openrpt.svn.sourceforge.net/openrpt/?rev=364&view=rev
Author: cryan
Date: 2009-08-20 19:55:51 +0000 (Thu, 20 Aug 2009)

Log Message:
-----------
Added in a check to prevent endless loops. Issue #7149.

Modified Paths:
--------------
openrpt/trunk/OpenRPT/renderer/crosstab.cpp

08/07/09 20:07jrogelstad

It looks like nobody has ever tested this thing. I can''t make it work. Every time I try to print my machine completely locks up. I''ve attached a simple configuration for an xtuple database that only returns 20 rows.

11/26/08 12:33matherton

Could you provide sample report def and output that uses this capability?

10/27/08 16:03cryan

Revision: 272
http://openrpt.svn.sourceforge.net/openrpt/?rev=272&view=rev
Author: cryan
Date: 2008-10-27 20:02:12 +0000 (Mon, 27 Oct 2008)

Log Message:
-----------
Incorporated submitted changes for Issue #7149.

Modified Paths:
--------------
openrpt/trunk/OpenRPT/images/OpenRPTWrtembed.qrc
openrpt/trunk/OpenRPT/renderer/orprerender.cpp
openrpt/trunk/OpenRPT/renderer/renderer.pro
openrpt/trunk/OpenRPT/wrtembed/documentscene.cpp
openrpt/trunk/OpenRPT/wrtembed/graphicsitems.cpp
openrpt/trunk/OpenRPT/wrtembed/graphicsitems.h
openrpt/trunk/OpenRPT/wrtembed/graphicssection.cpp
openrpt/trunk/OpenRPT/wrtembed/reporthandler.cpp
openrpt/trunk/OpenRPT/wrtembed/reporthandler.h
openrpt/trunk/OpenRPT/wrtembed/wrtembed.pro
openrpt/trunk/common/parsexmlutils.cpp
openrpt/trunk/common/parsexmlutils.h

Added Paths:
-----------
openrpt/trunk/OpenRPT/images/icons_16x16/
openrpt/trunk/OpenRPT/images/icons_16x16/attribute_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/barcode_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/box_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/copy_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/crosstab_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/database_add_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/delete_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/diskette_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/document_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/export_database_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/field_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/files_zoom_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/font_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/image_field_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/line_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/numeric_field_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/numeric_field_ok_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/paste_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/scissors_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/statistic_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/text_field_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/viewzoomin_16x16.png
openrpt/trunk/OpenRPT/images/icons_16x16/viewzoomout_16x16.png
openrpt/trunk/OpenRPT/images/icons_24x24/
openrpt/trunk/OpenRPT/images/icons_24x24/Thumbs.db
openrpt/trunk/OpenRPT/images/icons_24x24/attribute_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/barcode_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/box_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/copy_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/crosstab_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/database_add_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/delete_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/diskette_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/document_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/export_database_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/field_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/files_zoom_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/font_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/image_field_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/line_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/numeric_field_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/numeric_field_ok_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/paste_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/scissors_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/statistic_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/text_field_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/viewzoomin_24x24.png
openrpt/trunk/OpenRPT/images/icons_24x24/viewzoomout_24x24.png
openrpt/trunk/OpenRPT/images/icons_32x32/
openrpt/trunk/OpenRPT/images/icons_32x32/attribute_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/barcode_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/box_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/copy_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/crosstab_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/database_add_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/delete_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/diskette_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/document_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/export_database_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/field_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/files_zoom_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/font_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/image_field_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/line_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/numeric_field_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/numeric_field_ok_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/paste_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/scissors_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/statistic_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/text_field_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/viewzoomin_32x32.png
openrpt/trunk/OpenRPT/images/icons_32x32/viewzoomout_32x32.png
openrpt/trunk/OpenRPT/images/icons_48x48/
openrpt/trunk/OpenRPT/images/icons_48x48/attribute_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/barcode_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/box_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/copy_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/crosstab_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/database_add_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/delete_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/diskette_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/document_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/export_database_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/field_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/files_zoom_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/font_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/image_field_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/line_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/numeric_field_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/numeric_field_ok_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/paste_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/scissors_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/statistic_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/text_field_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/viewzoomin_48x48.png
openrpt/trunk/OpenRPT/images/icons_48x48/viewzoomout_48x48.png
openrpt/trunk/OpenRPT/images/icons_64x64/
openrpt/trunk/OpenRPT/images/icons_64x64/attribute_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/barcode_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/box_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/copy_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/crosstab_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/database_add_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/delete_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/diskette_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/document_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/export_database_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/field_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/files_zoom_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/font_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/image_field_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/line_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/numeric_field_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/numeric_field_ok_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/paste_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/scissors_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/statistic_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/text_field_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/viewzoomin_64x64.png
openrpt/trunk/OpenRPT/images/icons_64x64/viewzoomout_64x64.png
openrpt/trunk/OpenRPT/renderer/crosstab.cpp
openrpt/trunk/OpenRPT/renderer/crosstab.h
openrpt/trunk/OpenRPT/renderer/orcrosstab.h
openrpt/trunk/OpenRPT/wrtembed/crosstabeditor.cpp
openrpt/trunk/OpenRPT/wrtembed/crosstabeditor.h
openrpt/trunk/OpenRPT/wrtembed/crosstabeditor.ui

08/20/08 13:40cryan

I was unable to find an attached file for the code and did not see any separate emails as well. Could you please reattach the files for this patch?

08/15/08 07:08mstegehu

Information about open issues:

Open issue 1:
Tables larger dan 2 pages wide and / or hide are tested and working.

Due to wrongly usage of image size the table is not displayed correctly.



Characteristics

Operating System
 
Doc Flag
False
Copyright Assigned
Yes
HaxTuple
No

Files

Filename
archive.zip
crosstab2.xm
SimpleCrossTabTemplate.zip


Related Documents

TypeNumberDescriptionRelationshipRemove
Incident355Customer w/ multiple invoice addressesParentx
Incident3700Problems with certain SymbolsRelated tox
Incident4469Search box inoperative in Pricing Schedules MaintenanceRelated tox
Incident4500Delete Planned Order – Deletes Child When Not CheckedRelated tox
ProjectOPENRPTPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
12/16/10 09:12acdrupalNewIncident Added