Dynamically does SORT ORDER in CRXI

[karnd]

Hi,

The requirement is like this:

I have front end application which allows to do Sort Order on AccountTypeName for the Users.So whenever they hit the button "Update" it updates in the Databases.So AccountTypeName sorts accordingly. so since my report accessing that field(which has grouped) from the database "in-directly"(means created View for the report creation) it has to take that into effective SORT ORDER when i refresh it from the report.

so i should not have to hardcode by using Change Group Option in the Crystal.
should any kind of functions work for this scenarion?

Thanks a lot
Regards

 

[karnd]

Hi,

Small change:

Basically,the requirement got changed:

there are fields AcctTypeName & Sort Order

But in the report i need to display AcctTypename(which is NOT grouped by) but it has to do Sorting using SortOrder field.
Note:Sorting has to taken care at the report level ONLY.

Thanks a lot,
Regards,

 

[karnd]

Hi all,

Any ideas would be appreciated .

Thanks alot