user input (other than where clause)

rbuser

Hi,
I am trying to figure out how to get user input into parts of the sql
statement other than the where clause. Is this possible?

Matt

digitalmetaphors

RB doesn't provide any built in capability to change something like the
ORDER BY, because that would imply that you would need to change the groups
defined in the report layout. However, since you are using DADE, you can
show a custom dialog to setup the ordering for the report and then change
the ORDER BY defined in the dataview. This tip shows how to reverse the
ORDER BY fields and then you'll need to change the groups defined in the
layout as well. Use the Report.Groups[] array property at runtime to
reconfigure the groups. You'll also need to move the controls in the group
bands from one band to another. There is a Report Object Loop in the
Tech-Tips newsgroup you can use to loop through the objects in a given band.

http://www.digital-metaphors.com/tips/ReverseOrderBys.zip


Cheers,

Jim Bennett
Digital Metaphors