Removing rows with columns zeroed (TOTAL = 0)

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

Removing rows with columns zeroed (TOTAL = 0)

Postby henriqueberaldo » Mon Jan 03, 2011 4:51 pm

Alex, hello. I need the pivotcube not show rows in which all columns are cleared. Depending on the filter that the user makes the cube in run time, a ranking of clients, when you sort in descending order of sales, customers who do not participate in the filter also appear, displaying rows with zero total unnecessarily.
Note: Instructions SQL (SELECT) performs the query and shows only the customers related to the filter, not returning zero values (= 0)
Thanks!
henriqueberaldo
Guest
 
Posts: 3
Joined: Mon Nov 29, 2010 10:32 am

Re: Removing rows with columns zeroed (TOTAL = 0)

Postby AlexZencovich » Fri Jan 07, 2011 9:40 pm

Probably you may set TPivotMap.HideEmptyRows/Columns to control if totally empty row/coolumn still visible after filtering
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 8 guests

cron