Kexi Report Part

Database

Source (link to git-repo or to original if based on someone elses unmodified work): Add the source-code for this project on opencode.net

0
5.0
Available as/for: -
Description:

A reporting component for Kexi 1.6 based on OpenRPT 1.2 (http://www.openrpt.com).

See INSTALL for installation instructions and README for general information.

Features include
A report viewer for Kexi
An external report designer (KexiReportWriter) based on the OpenRPT 'writer' program

Known Working Features
----------------------
Page Header
Page Footer
Report Header
Report Footer
Detail section
Labels
Lines
Fields
Page Browser
Printing
Images

Known Not Working Features
--------------------------
Totaling
Graphs

Untested
--------
Group Headers/Footers
Barcodes
Kexi databases held on servers (postgresql/mysql)

Main differences with OpenRPT
-----------------------------

Works only with Kexi databases
Reports are based on a single query to make things simpler
Report writer retrieves field list
Report renderer allows a single page ot be rendered
Replaced as much code as possible with equivalent from KexiDB

How To Create Report
---------------------
1. Install the component following the instructions in INSTALL
2. Run KexiReportWriter to start designing a report
3. Select Database->Connect to DB
4. Browse to an existing Kexi Database and open it
5. Create a new report (File->New)
6. Assign a data source to the report (Document->Properties)
7. Create the report using labels/fields/lines
8. Assign columns to the field objects (Double click for properties)
9. Save the report. (Database->Save to DB)
10. Load the database in Kexi and double click the report to view it

See the included 'Simple_Database.kexi' for an example.
Last changelog:

13 years ago

Version 0.0.6
01-Feb-2008
Fixed build system
Removed useless dialog
Made it possible to move items using arrow keys
REQUIRES kexi from svn due to a bug fix in the sqlite driver

Version 0.0.5
28-Jan-2008
Fixed crash if no datasource is set Group headers work so long as a new enough kexi is used (maybe from svn)

Version 0.0.4
16-Jun-2006
Removed requirement to have kexi source available to install the plugin.Done this by including the needed kexi headers in the package. Only downside is that kexi 1.1.3 (from koffice 1.6.3) is required.

Version 0.0.3
BIG Speedup when scrolling
Added Foreground/Background colours to
labels and fields
Added Icon and .Desktop so that the designer appears in the 'office' menu

Version 0.0.2
Added - Printing (See print icon in lower right corner)
Images (dynamic and static)
Fixed build on upcoming Kexi 1.1.3
Included Simple_Database.kexi in the package

Version 0.0.1
Initial Release

illinux

13 years ago

Hi there,

1. In your blog I've seen a screenshot diplaying charts in kexi. Will this really great feature be integrated in kexi2?

2. When I try to compile Kexi Report Part I get this errors:

parsexmlutils.cpp: In function 'bool parseReportTextStyleData(const QDomElement&, ORTextStyleData&)':
parsexmlutils.cpp:205: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportFont(const QDomElement&, QFont&)':
parsexmlutils.cpp:237: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:253: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:260: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportData(const QDomElement&, ORDataData&)':
parsexmlutils.cpp:291: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportKey(const QDomElement&, ORKeyData&)':
parsexmlutils.cpp:323: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportLine(const QDomElement&, ORLineData&)':
parsexmlutils.cpp:365: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportLabel(const QDomElement&, ORLabelData&)':
parsexmlutils.cpp:411: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportField(const QDomElement&, ORFieldData&)':
parsexmlutils.cpp:463: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportText(const QDomElement&, ORTextData&)':
parsexmlutils.cpp:504: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportBarcode(const QDomElement&, ORBarcodeData&)':
parsexmlutils.cpp:538: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportImage(const QDomElement&, ORImageData&)':
parsexmlutils.cpp:572: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportColorDefData(const QDomElement&, ORColorDefData&)':
parsexmlutils.cpp:601: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportTitleData(const QDomElement&, ORTitleData&)':
parsexmlutils.cpp:625: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportStyleData(const QDomElement&, ORStyleData&)':
parsexmlutils.cpp:649: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportDataAxisData(const QDomElement&, ORDataAxisData&)':
parsexmlutils.cpp:679: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportValueAxisData(const QDomElement&, ORValueAxisData&)':
parsexmlutils.cpp:729: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportSeriesData(const QDomElement&, ORSeriesData&)':
parsexmlutils.cpp:767: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportGraphData(const QDomElement&, ORGraphData&)':
parsexmlutils.cpp:846: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportBackground(const QDomElement&, ORBackgroundData&)':
parsexmlutils.cpp:910: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportWatermark(const QDomElement&, ORWatermarkData&)':
parsexmlutils.cpp:955: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportSection(const QDomElement&, ORSectionData&)':
parsexmlutils.cpp:1076: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReportDetailSection(const QDomElement&, ORDetailSectionData&)':
parsexmlutils.cpp:1187: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp: In function 'bool parseReport(const QDomElement&, ORReportData&)':
parsexmlutils.cpp:1270: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1280: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1290: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1300: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1352: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1377: error: invalid cast from type 'QString' to type 'const char*'
parsexmlutils.cpp:1406: error: invalid cast from type 'QString' to type 'const char*'
make[5]: *** [parsexmlutils.lo] Fehler 1
make[5]: Verlasse Verzeichnis '/home/bjoern/Desktop/KexiReportPart/src/backend/kexirpt/common'
make[4]: *** [all-recursive] Fehler 1
make[4]: Verlasse Verzeichnis '/home/bjoern/Desktop/KexiReportPart/src/backend/kexirpt'
make[3]: *** [all-recursive] Fehler 1
make[3]: Verlasse Verzeichnis '/home/bjoern/Desktop/KexiReportPart/src/backend'
make[2]: *** [all-recursive] Fehler 1
make[2]: Verlasse Verzeichnis '/home/bjoern/Desktop/KexiReportPart/src'
make[1]: *** [all-recursive] Fehler 1
make[1]: Verlasse Verzeichnis '/home/bjoern/Desktop/KexiReportPart'
make: *** [all] Fehler 2


Thanks!

Report

C

piggz

13 years ago

Hi, yes, ive had this error reported aswell.... What you need to do is (atleast until i get another version out) use the configure.in.in from the 0.0.4 release and rerun 'make -f Makefile.cvs' etc.

It will probably also be nescessary to use the version of Kexi from the 1.6 svn branch as it has some fixes that are nescessary to prevent a crash.

Report

illinux

13 years ago

OK, it's not your blog. It's Jaroslaw Staniek:
http://www.kdedevelopers.org/node/3077

sorry.

Report

C

piggz

13 years ago

Hi

Firstly. thanks for all the +ve feedback....

Secondly, this may provide a better build experience.

Instead of editing src/Makefile.am (which may require rebuilding configure), try the --with-extra-includes paramter to configure to specify the path to the kexi source.

Eg:
./configure --prefix=`kde-config --prefix1 --with-extra-includes=/path/to/kexi_source

Check ./configure --help for other parameters (and the syntax)

Report

C

piggz

13 years ago

Scrap this with version 0.0.4 :)

Report

13 years ago

Version 0.0.6
01-Feb-2008
Fixed build system
Removed useless dialog
Made it possible to move items using arrow keys
REQUIRES kexi from svn due to a bug fix in the sqlite driver

Version 0.0.5
28-Jan-2008
Fixed crash if no datasource is set Group headers work so long as a new enough kexi is used (maybe from svn)

Version 0.0.4
16-Jun-2006
Removed requirement to have kexi source available to install the plugin.Done this by including the needed kexi headers in the package. Only downside is that kexi 1.1.3 (from koffice 1.6.3) is required.

Version 0.0.3
BIG Speedup when scrolling
Added Foreground/Background colours to
labels and fields
Added Icon and .Desktop so that the designer appears in the 'office' menu

Version 0.0.2
Added - Printing (See print icon in lower right corner)
Images (dynamic and static)
Fixed build on upcoming Kexi 1.1.3
Included Simple_Database.kexi in the package

Version 0.0.1
Initial Release

12345678910
Be the first to comment
File (click to download) Version Description PackagetypeArchitectureRelease ChannelDevices Downloads Date Filesize DL OCS-Install MD5SUM
*Needs pling-store or ocs-url to install things
Pling
0 Affiliates
Details
license
version
0.0.6
updated Feb 03 2008
added May 13 2007
downloads 24h
0
mediaviews 24h 0
pageviews 24h 0
System Tags app software