Formula support to ReportRecordItem
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=13977
Printed Date: 21 July 2025 at 7:56pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Formula support to ReportRecordItem
Posted By: mdoubson
Subject: Formula support to ReportRecordItem
Date Posted: 10 April 2009 at 2:01pm
|
I added Formula support to ReportRecordItem. If presented - Item Caption will show result of calculations based on given Formula.
Examples -
SUM(R2C3:R8C4) - given range
SUM(R*C3:R*C4) - means all rows (parent rows only in case of hierarhy)
SUM(R2C*:R8C*) - means all columns
SUM(R*C*:R*C*) - means all
given item always excluded from the loop - no circular refs
similar for child records
SUMSUB(R2C3:R8C4) - given range for childs
SUMSUB(R*C3:R*C4) - means all childs rows
SUMSUB(R2C*:R8C*) - means all columns
SUMSUB(R*C*:R*C*) - means all
so parent item chan show subtotal
and bottom item can show total by all
It also works in VB (ActiveX)
If user is doing data entry run-time in interactive way - he need to press F5 to call Recalc in the end and will see results
 ------------- Mark Doubson, Ph.D. |
Replies:
Posted By: mbrogdon
Date Posted: 14 April 2009 at 5:54am
|
I would like to test this. Where can I get this version, as there are no new customer downloads available?
thx ------------- Xtreme SuitePro ActiveX 13.2.0 - Windows XP SP3 - VB6/Ingres Openroad 2006 |
Posted By: mdoubson
Date Posted: 14 April 2009 at 7:50am
|
Do you have valid license for 2009? If yes - I can give you pre-release ActiveX to try - please open Issue and ask about this and also provide needed type of control - unicoded or not. If not - I can make simple static app and publish it ------------- Mark Doubson, Ph.D. |
Posted By: MNovaro
Date Posted: 15 April 2009 at 3:57am
|
Wow! That's very nice, for my applications at least. Looking forward to next version.  |
Posted By: Phoenix999
Date Posted: 02 July 2009 at 1:34am
|
Hi Mark What formulas does this support only SUm or others such as mean Min Max etc? ------------- Product: Xtreme SuitePro (ActiveX) version 13.0.0 Platform: Windows XP and Vista (32bit) - SP 2 Language: Visual DataFlex 15 |
Posted By: mdoubson
Date Posted: 03 July 2009 at 12:56pm
|
Because nobody asked it yet ------------- Mark Doubson, Ph.D. |
Posted By: Lodep59
Date Posted: 03 July 2009 at 5:48pm
 ------------- Product: Xtreme SuitePro (ActiveX) last version Platform: Windows 7 Ultimate Language: VB6 SP6 (FR) |
Posted By: mdoubson
Date Posted: 03 July 2009 at 5:50pm
|
Of course we can implement any common sense function here - I just propose most used and expect some feedback ------------- Mark Doubson, Ph.D. |