Divide all values of a column by a factor
Hi,
We would like divide all values of a certain detail-column by a factor (10,
100, 1000 ...) to increase readability and limit space used, but this factor
is, of course, dependent on all the values of that field in the pipeline.
I would rather not have to travel all values of the pipeline before starting
the report, so i was wondering if there is another possibility of achieving
this ...
greetings
bas
We would like divide all values of a certain detail-column by a factor (10,
100, 1000 ...) to increase readability and limit space used, but this factor
is, of course, dependent on all the values of that field in the pipeline.
I would rather not have to travel all values of the pipeline before starting
the report, so i was wondering if there is another possibility of achieving
this ...
greetings
bas
This discussion has been closed.
Comments
ReportBuilder takes the data as-is in the order the dataset is presented.
If you would like to look ahead at the data being displayed, you might
consider taking a peek at it during the first pass of the report, then
changing the display format based on the values during the second pass.
DetailBand.BeforePrint would be an ideal place to try this.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com