• Forums
• Home

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

09-14-2010, 8:25 AM giangian Joined on 06-16-2010 Posts 4 DynamiCube 2.0 calculated I'm using this unbound version with VB6 bur I don't understand how Cube works (or how I have to work...) with group totals (average for example). Is there some examples for me? Thanks    Report

09-15-2010, 12:57 AM Andrey - DD Joined on 08-01-2007 Russia, Novosibirsk Posts 671 Re: DynamiCube 2.0 calculated Attachment: dc2Average.zip Hello. You can set GroupFooterType of Row/Column field to DCFAverage to display average for data fields instead of sum. I've attached a sample which demonstrates this behaviour. Thank you, Andrey T.    Report

09-15-2010, 9:07 AM giangian Joined on 06-16-2010 Posts 4 Re: DynamiCube 2.0 calculated Thanks for help. I have another "little" question for you. Using GroupFooterType = DCFAverage i do the average of alla DCData fields. Can I decide to do the average for some DCData fields and the sum or nothing for others? Can I sort DCData field ? And can I sort DCData with a click on column name? Thanks.    Report

09-16-2010, 12:18 AM Andrey - DD Joined on 08-01-2007 Russia, Novosibirsk Posts 671 Re: DynamiCube 2.0 calculated Attachment: dc2AverageRankOn.zip Hello. 1. Yes you can. You can use GroupFooterTypeEx instead of GroopFooterType and specify name of the data field. For example, this code snippet: rowField.GroupFooterTypeEx("CustomerID") = DCFAverage will set average group footer of the Row field for "CustomerID" data field and leave sum group footer of the Row field for other data fields. 2. You can Rank data items by using RankOn and RankStyle properties of the row field. Also you can switch ranking style by clicking column header by using HitRecord object. http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~RankOn.html http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~Field~RankStyle.html http://www.datadynamics.com/Help/DynamiCube3/DynamiCubeLib~HitRecord.html I've attached a sample which demonstrates this. Note that for first data field group footer is average, for other fields its sum. Click on the "Number of Orders" field header to rank items based on the "Second field" row field. Thank you, Andrey T.    Report

09-25-2010, 1:42 AM giangian Joined on 06-16-2010 Posts 4 Re: DynamiCube 2.0 calculated Attachment: Example.txt Thanks for time you lose for me.... Attached You find some VB6 row because I can order only first column but not second or other ones.... What happen when I move a page field in row field? Thanks    Report

09-26-2010, 11:21 PM Andrey - DD Joined on 08-01-2007 Russia, Novosibirsk Posts 671 Re: DynamiCube 2.0 calculated Hello. RankOn property sets the data field index which grand total value is used in ranking the data items for this (Row) field. You cannot sort data fields directly. Thank you, Andrey T.    Report

GrapeCity » Product Support » DynamiCube Supp... » Re: DynamiCube 2.0 calculated

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Product Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports Developer 7 Beta Support |- Data Dynamics Analysis 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 |- ActiveBar Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ 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 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.activereports2.stdedition |- support.activereports.net |- support.activereports2.proedition |- support.activesizer.general |- support.dcube.c++ |- support.announcements |- 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