Ordering a dataset
Hello!
I have a query linked to a grid that allows ordering the dataset just
clicking on the column headers I must build a report linked to the grid's
dataset, but this report must have a default order and cannot be changed .
For this reason I have to execute another query with the right order. I am
wondering if there's a way to tell report builder to use a dataset but
ordering it in a different way whithout considering the dataset ordering, so
I wouldn't have to execute two different queries that can be differs by the
order. Pratically a different view of the same dataset.
Thanks
marco
I have a query linked to a grid that allows ordering the dataset just
clicking on the column headers I must build a report linked to the grid's
dataset, but this report must have a default order and cannot be changed .
For this reason I have to execute another query with the right order. I am
wondering if there's a way to tell report builder to use a dataset but
ordering it in a different way whithout considering the dataset ordering, so
I wouldn't have to execute two different queries that can be differs by the
order. Pratically a different view of the same dataset.
Thanks
marco
This discussion has been closed.
Comments
Unfortunately, there is no built in way to do re-order a dataset without
preprocessing the data in another dataset as ReportBuilder does not support
Views. You could possibly sort your data and place it in an object such as
a TStringList, then access it from a JITPipeline. Also, you could use an
in-memory dataset to temporarily store the sorted data before showing it in
a report. Check out
http://www.components4programmers.com/products/kbmmemtable/ for more
information on an in-memory dataset.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com