is there a possibility for the user to change the fieldalias for a crosstab report? If i'm right it's only possible for a crosstab with the code designer, which is not really user friendly.
Take a look at CrossTab demo 127 located in the \RBuilder\Demos\2. CrossTabs\... directory. This shows how you can manually alter the value of any cell in a crosstab component without the need to use the crosstab designer.
tks for the quick answers but there are still some questions...
1. When I change the rowname (left-below) in the demo, the columnname (fieldalias) stays the same. What do I do wrong?
2. When I change the fieldalias of a calculated field only the name of the field change. Is there a possibility to also change the formula.Example: Standaard: 'Sum(Total)' - change field alias from Total to total -> 'Sum(total)' Possible?: 'Sum(Total)' - ??-> 'sum(total)'
3. Can u confirm that if I want the end-user to change the fieldalias without code designer, it's needed to write a custom tool which edits the FieldAliases of an crosstab?
If you take a look at the TppElement topic in the ReportBuilder help it gives you a diagram of each object inside a CrossTab. This will allow you to use the correct events to change the values you want. For instance, you are looking for the ValueDef.CaptionDef property if you want to change the caption of the formula.
If you would like to give your users the ability to change these values you will need to write some event code for them to do so. Unfortuately the crosstab component is not very customizable. This is something on our todo list to enhance for a later release of ReportBuilder.
Comments
Take a look at CrossTab demo 127 located in the \RBuilder\Demos\2.
CrossTabs\... directory. This shows how you can manually alter the value of
any cell in a crosstab component without the need to use the crosstab
designer.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
tks for the quick answers but there are still some questions...
1. When I change the rowname (left-below) in the demo, the columnname
(fieldalias) stays the same. What do I do wrong?
2. When I change the fieldalias of a calculated field only the name of the
field change. Is there a possibility to also change the formula.Example:
Standaard: 'Sum(Total)' - change field alias from Total to total ->
'Sum(total)'
Possible?: 'Sum(Total)' - ??-> 'sum(total)'
3. Can u confirm that if I want the end-user to change the fieldalias
without code designer, it's needed to write a custom tool which edits the
FieldAliases of an crosstab?
Which event are you using to change the row name?
If you take a look at the TppElement topic in the ReportBuilder help it
gives you a diagram of each object inside a CrossTab. This will allow you
to use the correct events to change the values you want. For instance, you
are looking for the ValueDef.CaptionDef property if you want to change the
caption of the formula.
If you would like to give your users the ability to change these values you
will need to write some event code for them to do so. Unfortuately the
crosstab component is not very customizable. This is something on our todo
list to enhance for a later release of ReportBuilder.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com