Codejock Developer Community : about formula property http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 30 Apr 2026 12:11:23 +0000 Sat, 15 Aug 2009 01:34:46 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14837 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[about formula property : You don&#039;t need it at all...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=52016&title=about-formula-property#52016 Author: mdoubson
Subject: 14837
Posted: 15 August 2009 at 1:34am

You don't need it at all - see my comment from code to recalc for GroupRow:

//CODE FOR RECALC - pattern SUMSUB(R#C#:R#C#) or * instead of # - means all row or column

//ROW range ignored as used dynamic based on group row childs

so you can use formula as SUMSUB(R*C2:R*C3)
]]> Sat, 15 Aug 2009 01:34:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=52016&title=about-formula-property#52016 <![CDATA[about formula property : jpbro :ur replynot completely...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=52015&title=about-formula-property#52015 Author: dailyblog
Subject: 14837
Posted: 15 August 2009 at 12:09am

jpbro :ur reply not completely correct,but thank u anyway ,because u have explained the differences between RC and VSflexgrid,and these are all my needs.
My point is :i get grouped records from database but do not know the counts of child rows in each group(except using "select count(*)" in SQL),so how can i get the number 4 in formula SUM(r1*c2:r4*c3).
i think RC can meet my needs,but it needs more Codes than Vsflexgrid.
 
 
if you do not understand me ,i have to translate the reply above into Chinese:
 你说的不完全正确。但还是要谢谢你的回复，因为你说出了RC跟Vsflexgrid差异点。而这些也是我想在RC中实现的。
 
我的主要意思是：我从数据库是得到分组记录，但我却不知道每一组记录里包含多少子记录，所以在我用公式 SUM(r1*c2:r4*c3) 时，如何知道 4 是多少？
我想RC是可以做到的，但可能会更多的代码才能实现我的需求。
]]> Sat, 15 Aug 2009 00:09:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=52015&title=about-formula-property#52015 <![CDATA[about formula property : As all you know our group...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51999&title=about-formula-property#51999 Author: mdoubson
Subject: 14837
Posted: 14 August 2009 at 12:41pm

 
As all you know our group concept - childs follows the group - so group as parent should be above - no way to change it
 
btw - Formula in Group Row is very fresh code I am working right now - e.g. need to extend it for cascade case (several columns in Group Box) 
 
You can see on snapshot today's version result with 2 columns in GroupBox - and subtotal now show in cascade way
Get fresh ocx https://forum.codejock.com/uploads/DemoVersion/ReportControlUpdated.rar
and your can use same VB sample I attached yesterday
]]> Fri, 14 Aug 2009 12:41:18 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51999&title=about-formula-property#51999 <![CDATA[about formula property : If I may interject - I think what...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51997&title=about-formula-property#51997 Author: jpbro
Subject: 14837
Posted: 14 August 2009 at 12:26pm

If I may interject - I think what daily blog is looking for is subtotals & groups to appear *below* the list of grouped items. If you look closely at the screenshot, you will see that the groups open upwards instead of downwards.

Also, I know that the VSFlexGrid allows for multiple columns to be subtotalled onto a row, so this may be another requirement (in dailyblog's screenshot, there are 3 subtotalled columns per row).

The point about skins is irrelevant except in the sense that dailyblog would prefer to use the CodeJock ReportControl over the VsFlexGrid if it supports his grouping/subtotalling requirements because the RC supports skins (and will therefore look better). But functionality trumps aesthetics.

Maybe dailyblog confirm if my interpretation is correct?
]]> Fri, 14 Aug 2009 12:26:18 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51997&title=about-formula-property#51997 <![CDATA[about formula property : misunderstanding. please look...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51990&title=about-formula-property#51990 Author: dailyblog
Subject: 14837
Posted: 14 August 2009 at 10:41am

misunderstanding.
please look at the reply on 7th Floor.
 
]]> Fri, 14 Aug 2009 10:41:47 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51990&title=about-formula-property#51990 <![CDATA[about formula property : RC SUPPORTS skin but it does not...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51989&title=about-formula-property#51989 Author: mdoubson
Subject: 14837
Posted: 14 August 2009 at 10:16am

RC SUPPORTS skin but it does not mean RC NEED to use skin]]> Fri, 14 Aug 2009 10:16:08 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51989&title=about-formula-property#51989 <![CDATA[about formula property : it is pity that it does not meet...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51988&title=about-formula-property#51988 Author: dailyblog
Subject: 14837
Posted: 14 August 2009 at 10:11am

it is pity that it does not meet my needs. thanks anyway!]]> Fri, 14 Aug 2009 10:11:00 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51988&title=about-formula-property#51988 <![CDATA[about formula property : I guess so. Try it ]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51985&title=about-formula-property#51985 Author: mdoubson
Subject: 14837
Posted: 14 August 2009 at 10:06am

I guess so. Try it]]> Fri, 14 Aug 2009 10:06:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51985&title=about-formula-property#51985 <![CDATA[about formula property : sorry,my wrong.vsflexgrid does...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51983&title=about-formula-property#51983 Author: dailyblog
Subject: 14837
Posted: 14 August 2009 at 9:55am

sorry,my wrong.vsflexgrid does not surport skin.
can reportcontrol   meet  my needs?(my English is poor)
 
waiting on line...
]]> Fri, 14 Aug 2009 09:55:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51983&title=about-formula-property#51983 <![CDATA[about formula property : How itrelate to skin? ReportControl...]]> http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51978&title=about-formula-property#51978 Author: mdoubson
Subject: 14837
Posted: 14 August 2009 at 8:40am

How it relate to skin? ReportControl support skins]]> Fri, 14 Aug 2009 08:40:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=14837&PID=51978&title=about-formula-property#51978