• Forums
• Home

Search Rate this topic:   Comments (optional) Sort Posts:  Oldest to newest Newest to oldest

04-16-2009, 5:27 AM Zotya.kovacs Joined on 04-16-2009 Posts 2 GroupFooter and SummaryExpr in DCube 3 Attachment: dcGroupFooters.zip Hi All, We start to use DCube 3 instead of 2.5. We have used calculated field in v.2.5 and used aggregate functions.They have to be applied through the SummaryExpr. In the v. 3 we try to use the GroupSum and GroupAvg in the GroupFooterExpression, but the result very different, because the groupfooter add 3 more colums to the spread and the right sum apear only the groupfooter, but we need this in the calculated colums.(Let see the attachment.)  In the sample provided we want only 3 column: Data1, Data2 and GroupFooter' s last column. (Let see the picture in the attachment ) Could you please help us how to achieve this. Thank you, Zotya K.    Report

04-16-2009, 6:29 AM Andrey - DD Joined on 08-01-2007 Russia, Novosibirsk Posts 671 Re: GroupFooter and SummaryExpr in DCube 3 Attachment: dcGroupFootersUpd.zip Zotya, Please note that there are some differences between DynamiCube 2 and DynamiCube 3 syntax / features, especially: GroupFooterType / Expression defined differently in 3.0 Calculated fields in 3.0 defined differently in 3.0 You can find the list of changes here: http://www.datadynamics.com/forums/59193/ShowPost.aspx The GroupFooterType functionality in DynamiCube 3 has been changed and improved from DynamiCube 2.5. When a GroupFooterType("x") = DCFCalculated you can supply your own formula using GroupFooterExpression("x"). If you do not specify a GroupFooterType for an intersection, DynamiCube will use the default setting depending on the AggregateFunc of the associated DataField. See also: http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~GroupFooterExpression.html http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~GroupFooterType.html HOWTO: Create a calculated group footer for a field: http://www.datadynamics.com/forums/87243/ShowPost.aspx INFO: GroupFooterType Property in DynamiCube 3: http://www.datadynamics.com/forums/64794/ShowPost.aspx INFO: Calculated Fields in DynamiCube 3.0: http://www.datadynamics.com/forums/63838/ShowPost.aspx I've modified your sample to achieve desired result. Please see the attachment. Thank you, Andrey T.    Report

04-16-2009, 7:33 AM Zotya.kovacs Joined on 04-16-2009 Posts 2 Re: GroupFooter and SummaryExpr in DCube 3 Thanks for the fast help!    Report

GrapeCity » Product Support » DynamiCube Supp... » GroupFooter and SummaryExpr in DCube 3

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Announcements |- ActiveBar Announcements |- ActiveReports Announcements |- ActiveReports for .NET Announcements |- ActiveSizer Announcements |- Data Dynamics WebSite Announcements |- DynamiCube Announcements |- SharpGraph for .NET Announcements |- SharpGrid Announcements |- SharpUI for .NET Announcements |- Data Dynamics Reports Announcements |- GrapeCity ActiveAnalysis Announcements Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ Product Support |- ActiveBar Support |- Data Dynamics Analysis Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports for .NET 3.0 Support |- ActiveReports for .NET 2.0 Support |- ActiveReports for .NET Support |- ActiveReports 2.0 (Visual Basic 6.0) Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Knowledge Base |- KnowledgeBase for SharpUI for .NET |- KnowledgeBase for ActiveCube |- KnowledgeBase for ActiveReports |- KnowledgeBase for ActiveBar |- KnowledgeBase for ActiveReports for .NET |- KnowledgeBase for SharpGrid |- KnowledgeBase for ActiveSizer |- KnowledgeBase for DynamiCube |- KnowledgeBase for SharpGraph for .NET |- KnowledgeBase for Data Dynamics Reports Forum Archives |- ActiveReports for .NET 2.0 Visual Studio .NET 2005 Support |- ActiveBar 3.0 Beta Support |- support.activebar2.general |- support.activereports.general |- support.activereports.net |- support.activereports2.stdedition |- support.activereports2.proedition |- support.activesizer.general |- support.announcements |- support.dcube.c++ |- support.dcube.delphi |- support.dcube.ie |- support.dcube.misc |- support.dcube.vb |- support.dcube.vfp |- support.sharpgrid.general Product Downloads |- ActiveSizer Downloads |- SharpUI for .NET Downloads |- ActiveReports for .NET Downloads |- ActiveCube Downloads |- ActiveReports Downloads |- ActiveBar Downloads |- SharpGrid Downloads |- ActiveReports for .NET 2.0 Downloads |- SharpGraph for .NET Downloads |- DynamiCube Downloads |- ActiveReports for .NET 3.0 Downloads |- ActiveReports 6 Downloads |- Data Dynamics Reports Downloads Web Site Feedback |- Web Site Feedback Employment Opportunities |- Employment Opportunities