Openbravo Forum End of Life Notice

Dear Openbravo Forum User,

Because of continued very low usage we decided to stop the forums on 31st of August 2017

In case of questions: webmaster "at" openbravo.com

Pie Chart Sales by Category Products

<<

Andrej Svininykh

Posts: 213

Joined: Wed Mar 18, 2009 7:25 pm

Post Sun Apr 04, 2010 7:34 am

Pie Chart Sales by Category Products

Hello Ronny,


please add this report into you project. I hope in the future reports from this project include into main release Openbravo POS.


For this report needs update JasperReport libraries (in this moment stable version 3.7.1).

 


Best regards,


Andrej Svininykh.


Project Openbravo POS ru

Attachments
pie-chart-sales-by-category-products.png
pie-chart-sales-by-category-products.png (974 Bytes) Viewed 6497 times

[The extension bs has been deactivated and can no longer be displayed.]

[The extension jrxml has been deactivated and can no longer be displayed.]

[The extension properties has been deactivated and can no longer be displayed.]

--
The best regards,
Andrey Svininykh
Project nordpos.mobi
Hire Me!
<<

Ronny _G

Posts: 910

Joined: Wed Mar 18, 2009 7:26 pm

Post Thu Apr 08, 2010 10:41 pm

RE:Pie Chart Sales by Category Products

Package added to downloads (Sales by Category-Pie[jerdna]).



 


Thanks for sharing again.


Kind Regards,


Ronny G


----------------------------------------------------------


OBPOS 2.30 (upgraded), Windows & MySQL 5.0

<<

Andrej Svininykh

Posts: 213

Joined: Wed Mar 18, 2009 7:25 pm

Post Sun Apr 11, 2010 8:12 am

RE:Pie Chart Sales by Category Products



Hello,


In attachment I include correction report for import into PDF (see also).


Best regards,


Andrej Svininykh.


Project Openbravo POS ru

Attachments

[The extension jrxml has been deactivated and can no longer be displayed.]

--
The best regards,
Andrey Svininykh
Project nordpos.mobi
Hire Me!
<<

Ronny _G

Posts: 910

Joined: Wed Mar 18, 2009 7:26 pm

Post Sun Apr 11, 2010 11:13 am

RE:Pie Chart Sales by Category Products

I have updated piesalescat[jerdna].zip though users please note that as advised, it will not run with default iReports 3.0.0 and you need to update library.



 


Kind Regards,


Ronny G


----------------------------------------------------------


OBPOS 2.30 (upgraded), Windows & MySQL 5.0


Openbravo POS Reports, Openbravo POS au

<<

NET52 Jeff

Posts: 6

Joined: Mon Mar 30, 2009 4:28 pm

Post Sun Aug 15, 2010 6:41 pm

RE:Pie Chart Sales by Category Products

Is it possible to display price with taxe included in this report?

Jeff-net52

<<

anonymous

Posts: 4

Joined: Mon Jun 09, 2008 7:04 am

Post Fri Aug 26, 2011 8:08 am

Re: Pie Chart Sales by Category Products

I was looking everywhere how to update jasperreports to the last version, but the only clue seems to modify the openbravo pos sources and compiling it. Am I right or there another way to update the libraries?
<<

Sir GENIUS

Posts: 55

Joined: Fri Nov 13, 2009 2:57 pm

Post Fri Aug 26, 2011 8:26 am

Re: Pie Chart Sales by Category Products

The Libraries you can find in the folder program files\openbravopos-2.30.2\lib (Windows version)

the simple way to update is:
1. to find the new version of files from Libraries folder.
2. To rename the new files with the name of old files
3. to rewrite the new files with the old files.
4. Restart the OpenbravoPos

good luck!
<<

Edwin Obando

Posts: 2

Joined: Fri Aug 26, 2011 6:04 pm

Post Fri Aug 26, 2011 7:47 pm

Re: Pie Chart Sales by Category Products

Thanks for the feedback. Actually I already did that renaming jasperreports 4.1.1 to 3.1.4, this way I can access to the report window but when I press "execute report" I receive this error message:
-----------------------------------------------------------------------------------------------
com.openbravo.basic.BasicException:
java.sql.SQLSyntaxErrorException: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.

java.sql.SQLSyntaxErrorException:
The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.

org.apache.derby.impl.jdbc.EmbedSQLException:
The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.

org.apache.derby.iapi.error.StandardException:
The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
-----------------------------------------------------------------------------------------
In anyone knows how to solve this, Ill appreciate any help.
I need this because I want reports to tell me the sales by category and subcategory. For example:
I have a category called "WALK IN SALE" inside this I have a subcategory "CHOCO CAKE" then inside this subcategory I have products like "8 Portions", "10 portions", "15 portions" etc.

WALK IN SALE -> CATEGORY
--Chococake -> SUBCATEGORY
--8 PORTIONS -> PRODUCT
--10 PORTIONS -> PRODUCT
--15 PORTIONS -> PRODUCT
--Bavaria Cake -> SUBCATEGORY
--8 PORTIONS -> PRODUCT
--10 PORTIONS -> PRODUCT
--15 PORTIONS -> PRODUCT
ORDER SALE -> CATEGORY
--ChocoCake -> SUBCATEGORY
--8 PORTIONS -> PRODUCT
--10 PORTIONS -> PRODUCT
--15 PORTIONS -> PRODUCT
--Bavaria Cake -> SUBCATEGORY
--8 PORTIONS -> PRODUCT
--10 PORTIONS -> PRODUCT
--15 PORTIONS -> PRODUCT

This work very fine inside sales window, but I want to know through reports how many chococakes and Bavaria were sell to "walk in sale" or "order sale".

Thanks in Advance...
<<

anonymous

Posts: 4

Joined: Mon Jun 09, 2008 7:04 am

Post Fri Aug 26, 2011 9:31 pm

Re: Pie Chart Sales by Category Products

your problem seem on your syntax. you supply agregate column but not include group by clause.u can run your query first, and make sure its valid
<<

Sir GENIUS

Posts: 55

Joined: Fri Nov 13, 2009 2:57 pm

Post Fri Aug 26, 2011 10:47 pm

Re: Pie Chart Sales by Category Products

I think you need to update some additional files from Libraries.

see this link: viewtopic.php?group_id=304&f=886558&t=7012043
Next

Return to Submit a Report

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Website Terms


Designed by ST Software for PTF.