Codejock Developer Community : GroupFormula http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:30:19 +0000 Mon, 20 Apr 2015 12:47:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18987 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[GroupFormula : Thank you for bringing this to...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=73268&title=groupformula#73268 Author: mcmastl
Subject: 18987
Posted: 20 April 2015 at 12:47pm

Thank you for bringing this to our attention, we have informed our development team and we will be looking into the issue.  If the matter has been resolved please let us know.  ]]> Mon, 20 Apr 2015 12:47:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=73268&title=groupformula#73268 <![CDATA[GroupFormula : Hi everyone,I&#039;ve fixed this...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=72487&title=groupformula#72487 Author: mihey
Subject: 18987
Posted: 12 May 2014 at 4:06am

Hi everyone,

I've fixed this issue in my case by patching the method StringToDouble of the CXTPReportRecordItem.

double CXTPReportRecordItem::StringToDouble(CString strText)
{

        TCHAR chSep[4];
        GetLocaleInfo(LOCALE_USER_DEFAULT, LOCALE_STHOUSAND, chSep, 4);
     strText.Replace(chSep, "");

     TCHAR* locale = _tsetlocale(LC_NUMERIC, NULL);

     if (locale == NULL || _tcscmp(locale, _T("C")) == 0) // Not set
     {
          strText.Replace(',', '.');
     }

     double res = atof(XTP_CT2CA(strText));

     return res;
}

Maybe CJ could take it over into their next release.
Best regards, Mikhail]]> Mon, 12 May 2014 04:06:32 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=72487&title=groupformula#72487 <![CDATA[GroupFormula : I have this same problem ---...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67622&title=groupformula#67622 Author: Andrew666
Subject: 18987
Posted: 16 February 2012 at 9:00am

I have this same problem --- it appears that SUMSUB uses the Caption of the item, not its Value property - so if I format the Caption in any way, the SUMSUB gives the wrong number.  Surely this is a bug?
 
Also, the SUMSUB behaviour doesn't appear to be as documented.  If I use SUMSUB(C3:C6) for example, this appears to cause the total to be displayed in column 3 of the GroupRow, and sums the column 6 values.
 
Using v15.2.1
]]> Thu, 16 Feb 2012 09:00:48 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67622&title=groupformula#67622 <![CDATA[GroupFormula : In the BeforeDrawRow event the...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67056&title=groupformula#67056 Author: Willowmaster
Subject: 18987
Posted: 06 December 2011 at 9:41am

In the BeforeDrawRow event the Grouprows are excluded from formatting. That's why the grouprow is not showing the right formatting.
This is some very bad programming and it has a small bug in it. But i shows it is possible to fix the formatting.
 
Private Sub wndReportControl_BeforeDrawRow(ByVal Row As XtremeReportControl.IReportRow, ByVal Item As XtremeReportControl.IReportRecordItem, ByVal Metrics As XtremeReportControl.IReportRecordItemMetrics)
Dim lngGroupOrder       As Long
Dim lngStartPos         As Long
    If Not Row.groupRow Then
        Metrics.Text = Format(Item.Caption, "### ### ###")
    Else
        lngStartPos = InStr(1, Metrics.Text, "[" & wndReportControl.GroupsOrder.Count & "]")
        If lngStartPos > 0 Then
            Metrics.Text = wndReportControl.GroupsOrder.Column(wndReportControl.GroupsOrder.Count - 1).Caption & ": " & Format(Mid(Metrics.Text, Len(wndReportControl.GroupsOrder.Column(wndReportControl.GroupsOrder.Count - 1).Caption) + 2, lngStartPos - Len(wndReportControl.GroupsOrder.Column(wndReportControl.GroupsOrder.Count - 1).Caption) - 2), "### ### ###") & " [" & wndReportControl.GroupsOrder.Count & "]" & Format(Mid(Metrics.Text, (lngStartPos + Len("[" & wndReportControl.GroupsOrder.Count & "]"))), "### ### ###")
        Else
            Metrics.Text = wndReportControl.GroupsOrder.Column(wndReportControl.GroupsOrder.Count - 1).Caption & ": " & Format(Mid(Metrics.Text, Len(wndReportControl.GroupsOrder.Column(wndReportControl.GroupsOrder.Count - 1).Caption) + 2), "### ### ###")
        End If
    End If
End Sub
]]> Tue, 06 Dec 2011 09:41:17 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67056&title=groupformula#67056 <![CDATA[GroupFormula : Hi, I don&#039;t see problem......]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67055&title=groupformula#67055 Author: Aaron
Subject: 18987
Posted: 06 December 2011 at 9:28am

Hi,
 
I don't see problem... Can you be more specific?
 
Thanks
 
]]> Tue, 06 Dec 2011 09:28:11 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=67055&title=groupformula#67055 <![CDATA[GroupFormula : Thank you for your answer! I looked...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66971&title=groupformula#66971 Author: flado
Subject: 18987
Posted: 30 November 2011 at 6:49am

Thank you for your answer! I looked at your test project, but it seems that even there the formats of the totals are not correct:

]]> Wed, 30 Nov 2011 06:49:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66971&title=groupformula#66971 <![CDATA[GroupFormula : Hi, I don&#039;t see problem.... Here&#039;s...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66733&title=groupformula#66733 Author: Aaron
Subject: 18987
Posted: 04 November 2011 at 9:18am

Hi,
 
I don't see problem....
 
Here's test project, maybe it will help you:   uploads/3701/Formulas.zip
 
Good luck Wink
 
 
]]> Fri, 04 Nov 2011 09:18:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66733&title=groupformula#66733 <![CDATA[GroupFormula : Anyone?Thanks.... ]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66651&title=groupformula#66651 Author: flado
Subject: 18987
Posted: 20 October 2011 at 10:16am

Anyone?
Thanks....
]]> Thu, 20 Oct 2011 10:16:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66651&title=groupformula#66651 <![CDATA[GroupFormula : I recently updated to 15.1.3 thinking...]]> http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66431&title=groupformula#66431 Author: flado
Subject: 18987
Posted: 26 September 2011 at 4:58pm

I recently updated to 15.1.3 thinking that it would solve my groupformula problems, but I can't seem to figure it out...

Here are my problems:
1. I use space as thousand separator - ie 1,000 becomes 1 000  - the control doesn't seem to be able to calculate this. Or is there a sepcial formula I should use?
2. I have a report in which I want to show the subsums of up to 12 columns in the group row. It seems I can't show more than 6 columns. Is this a limitation?

Please help as I have been struggling with this for a LOOONG time now...

using VDF 151 and CJ15.1.3 ActiveX COM

thanks
/Leif

]]> Mon, 26 Sep 2011 16:58:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=18987&PID=66431&title=groupformula#66431