I need to sort by a calculated field in the dataset, this can't be done, the caluclation is to complex to embed in the SQL. Therefore, I would like to know if its possible to sort somewhere in RB, either directly, through pipeline, variable etc..
If you are unable to make the calculations in SQL, you have two options...
1. Make your calculations in Delphi and output the data to a built in Delphi object such as a TStringList. Then pull the pre-sorted data from the StringList as well as the rest of your data using a JITPipeline and output it to your report.
2. The easiest way would be to use an in-memory dataset such as the kbmMemTable to add your calculated field and sort using their built in methods. There is currently a DADE plugin for ReportBuilder that works with kbmMemTables. http://www.components4programmers.com
Comments
caluclation is to complex to embed in the SQL. Therefore, I would like to
know if its possible to sort somewhere in RB, either directly, through
pipeline, variable etc..
Roger
If you are unable to make the calculations in SQL, you have two options...
1. Make your calculations in Delphi and output the data to a built in
Delphi object such as a TStringList. Then pull the pre-sorted data from the
StringList as well as the rest of your data using a JITPipeline and output
it to your report.
2. The easiest way would be to use an in-memory dataset such as the
kbmMemTable to add your calculated field and sort using their built in
methods. There is currently a DADE plugin for ReportBuilder that works with
kbmMemTables. http://www.components4programmers.com
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
R