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:
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
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!
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.
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)
Ratings & Comments
5 Comments
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!
OK, it's not your blog. It's Jaroslaw Staniek: http://www.kdedevelopers.org/node/3077 sorry.
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.
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)
Scrap this with version 0.0.4 :)