Changing backcolor in textbox in crosstab

[c e]

Hello,

I have created a new report using the CrossTab Wizard.
I have a datasource where two of its columns have the backcolor and forecolor html values for a group name (in another column).
Is it possible assign this color to the textbox showing the group name?

Thanks in advance
Carlos

[IvanDT]

Hello Carlos,

We've reviewed your question and here are some suggestions what to do in order to successfully assign color to the textbox showing the group name.

I've attached a sample report with a textbox using our Bindings for setting in run time the Style properties(background and text color). Just like you presented, I've made a class Report2Data to bind the report with data which is similar to the described situation. In the definition of the report I'd set user function which is translating html color to System.Drawing.Color because of type with which the Style.BackgroundColor and Style.Color are working with. After that I'm using the user function in the Bindings expressions.

Best wishes,
IvanDT
the Telerik team

[c e]

Hi Ivan, thanks for your reply. It worked excellent.
Now, I have another question: 
In  my crosstab, I have two cells by column group, and the correspondant two totals at the end. It works ok.
Is it possible to add one more column with the sum of both totals after the standard total columns?
for example:

                                   Col1                     col2                       Total
                            current   grow        current    grow     current   grow          total <- this is the column I need to add
row 1                        1           2              3             4           4           6              10 <- this is the column I need to add

Thanks in advance

Carlos

[IvanDT]

Hello Carlos,

It is possible to do what you ask for. We prepared a sample in which you can see that we add another static group to the right of the two totals which represent the grand total column.

All the best,
IvanDT
the Telerik team