Crosstab Enhancement requests

[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" )

[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.

[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.

[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.

[Alex K.]

Hello,

We are very glad that our product meets your needs.
Let us know if you need any additional help.

Thank you.

[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.

[Alex K.]

Hello,

Please try to use the following expression for the Total:
value < 100

Thank you.