|
Formula support to ReportRecordItem |
Post Reply 
|
| Author | |
mdoubson 
Senior Member 
Joined: 17 November 2008 Status: Offline Points: 1705 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Formula support to ReportRecordItemPosted: 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
 |
|
 |
|
|
mbrogdon
Groupie 
Joined: 22 March 2007 Status: Offline Points: 40 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
MNovaro
Groupie
Joined: 20 June 2006 Status: Offline Points: 71 |
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2009 at 3:57am |
|
Wow! That's very nice, for my applications at least.
Looking forward to next version.  |
|
|
|
|
Phoenix999
Newbie 
Joined: 26 June 2009 Status: Offline Points: 8 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2009 at 12:56pm |
|
Because nobody asked it yet
|
|
|
|
|
Lodep59
Senior Member
Joined: 03 April 2008 Status: Offline Points: 203 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 July 2009 at 5:48pm |
|
|
|
Product: Xtreme SuitePro (ActiveX) last version
Platform: Windows 7 Ultimate Language: VB6 SP6 (FR) |
|
|
|
|
mdoubson
Senior Member
Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options