FastCube 2.7 Hide Totals in code

volkan

Hello

I am reposting this question again. Is there anyone who could help me with this problem?

I am using Delphi 7 and FastCube 2.7

I need to hide the total for one measure via code. How do I do it? Thank you!

YaroslavFilippenko

Hello!

Please show the desired result on the screenshot.

volkan

Hello Yaroslav,

Thank you for your reply. Here is the example screenshot. I marked totals in one column with arrows. And I erased totals in Photoshop. It should be empty. Total makes no sense for this column.

The other column is ok, it should have totals.

But, I need to do it via code, so that every time a user starts the Cube report, it remains hidden.

I tried even this piece of code, but it isnt working:

 fcxSlice1.MeasuresContainer.Measures[fcxSlice1.MeasuresContainer.MeasureFields.IndexByName['FIELD_NAME']].DefaultTotalPosition := fctp_Hide;

Here is the example. Thank you very much in advance

V.

YaroslavFilippenko

Hello.

Please try this trick:

1.Open measure properties.

2. Switch to Totals tab

3. Click "Use different aggregate for totals"

4. In the Aggregate combo choose "Calculation"

5. In the expression field please write Null

Best regards