Custom Total Column in CrossTab

[RyanSF]

Hi all,

I am programming a C# Windows Forms application in .NET8.0.
I have a report where I need to show gas concentration readings by time and by gas type.
So each row will be an hour of the day (1...2...3...) and each column will be whatever number of gas types the user selects.
Like this:


This is easy, I pull the data from my database and fill a CrossTab with the DateTime and GasName information.
What I need now is an extra column on the far right side to display the Operational Mode, like the "Total" column we have by default that sums up the values in that row.
Each gas type has its own operational mode but in this column I only display the most important mode, following a pre-set priority list.
Like this:


I was able to do it in Microsoft SQL Server Report Builder using Tablix, I just insert one column to the right and write my expression.
How can I do that in Stimulsoft?

Thank you!

[Lech Kulikowski]

Hello,

Depends of the data structure. Could you send us test data, we will try to prepare a sample report for you.

Thank you.

[RyanSF]

Hello,

Depends of the data structure. Could you send us test data, we will try to prepare a sample report for you.

Thank you.

Thank you so much for your quick response.
I was not sure how to send you the test data so I put it in an CSV.

TestData.csv

(14.02 KiB) Downloaded 194 times

We use DateTime for the rows, ParameterName for the columns, ValueDisplay for the value (Summary), and the extra column will be OpModeDisplay.

[Lech Kulikowski]

Hello,

Sorry, but the sent data does not fit with the attached screenshot, please explain what should be output where.

Thank you.