CustomSort in macro

[ssudha]

Hi,
If i place the below statement in macro where i am building my query....what should happen...

busobj.ActiveDocument.DataProviders.Item("Query 1 with lead").Columns(1).CustomSort ("Descending")


I don't see any change, i want the data to be sorted in descending order and should be handled in a macro only.
I am actually working on dynamically accepting the criteria(Column) on which the sort should be done in the report and sort the data on that particular column accordingly.

Any help regarding this is appreciated.

Thanks in advance.

 

[synapsevampire]

Any idea what version of Crystal you're using?

Did you mean to post in a VBA forum?

Crystal doesn't have macros, nor could it process this statement.

To dynamically sort, most use a parameter and then use a formula to sort on, such as:

if {?SortParm} = "Title" then
{table.title"
else
if {?SortParm} = "Last Name" then
{table.lname"
etc...

-k

 

[Crystal110]

In this formula, how can I specify that I need to sort in a Descending order for {table.title}?

I am working in Crystal 10 using SQL Server database.

Thanks!

if {?SortParm} = "Title" then
{table.title"
else
if {?SortParm} = "Last Name" then
{table.lname"

 

[lbass]

Make this into two formulas:

//{@Title}:
if {?SortParm} = "Title" then {table.title} else ""

//{@LastName}:
if {?SortParm} = "Last Name" then {table.lname} else ""

Add each to the record sort area and check descending for {@Title} and ascending for "Last Name".

-LB