Page 1 of 1
Crosstab Enhancement requests
Posted: Wed Sep 07, 2011 3:23 pm
by jmiller
I am not sure of the proper procedure to request enhancements but I figure Iwould start here.
I would like to see more flexibility with the total summary cells in a cross tab. When a crosstab is created there is a "cell" for header in which properties can be modified. It would be beneficial to be able to do the same for the total summary.
- be able to supply conditional formats: e.g. make the text red if the value is negative
- be able to include text with the total: e.g. something like IIF( summary total < 50, "Poor", "Fair" ) - Format( summary total, "##0" )
Crosstab Enhancement requests
Posted: Thu Sep 08, 2011 7:54 am
by Alex K.
Hello,
Unfortunately, but at this moment the cross-tab component works "as is". Some things can be done using Conditions or additional scripts. We have plans to complete the task of redesigning the cross-tab engine, but we cannot say when it be implemented.
Thank you.
Crosstab Enhancement requests
Posted: Thu Sep 08, 2011 8:15 am
by HighAley
We found a workaround for your case.
Please, use a Process Cell event for Totals.
Code: Select all
if (e.Cell.SummaryIndex == 2 && e.Value < 500)
{
e.Text = "Poor: " + e.Value;
}
else if (e.Cell.SummaryIndex == 2 && e.Value < 750)
{
e.Cell.Field.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Blue);
Stimulsoft.Report.Components.StiConditionHelper.ApplyFont(e.Cell.Field, new System.Drawing.Font("Arial", 8F, System.Drawing.FontStyle.Bold), Stimulsoft.Report.Components.StiConditionPermissions.All);
e.Text = "Fair: " + e.Value;
}
else if (e.Cell.SummaryIndex == 2)
{
e.Text = "Good: " + e.Value;
}
See attached report template.
Thank you.
Crosstab Enhancement requests
Posted: Fri Sep 09, 2011 9:39 am
by jmiller
Thanks for the workaround, I will give it a try.
I wasn't looking for any time frame. I just wanted to submit an enhancement request - when and if you do it, that is your decision. I still like the product and will continue to use it and I appreciate your effort in finding a workaround.
Crosstab Enhancement requests
Posted: Mon Sep 12, 2011 1:36 am
by Alex K.
Hello,
We are very glad that our product meets your needs.
Let us know if you need any additional help.
Thank you.
Re: Crosstab Enhancement requests
Posted: Wed Mar 15, 2017 7:42 pm
by Alum89
Hi, I also have the same issue with my report. I would like to make the values red for the total columns/rows. Can you please assist? I've attached the report I am using.
Re: Crosstab Enhancement requests
Posted: Thu Mar 16, 2017 8:34 pm
by Alex K.
Hello,
Please try to use the following expression for the Total:
value < 100
Thank you.