Problem with sorting in the detail level

[danikuper]

I have a report that is based on a query that gives me the following data:

Campaign Name, CampaignID, Campaign Activity, ActivityID, Activity results, ResultID.

In my query I have ResultID in ascending order. In my report, I have a header for CampaignID, another for ActivityID and in the details section I have the Results and ResultID.

The problem is that my ResultID are not in order... the details section is being sorted alphabetically by Results and what I want is to follow the ResultID (numeric).

How can I change the field that is being used for sorting in the details section??

Thanks!!

 

[jfgambit]

Use the Sorting and Grouping button:

 

[danikuper]

I tried that.

I have the following in my sorting/grouping button:

Campaign: Ascending
Activity: Ascending

It is sorting by the alpha field (Result), not the numeric one (ResultID).

What else could it be?

 

[jfgambit]

Add rhe resultID to the Sorting grouping after Activity and set it to Ascending...

 

[danikuper]

Duh!

That was a really silly thing... yes, having the ResultID in the sorting list works!!!

Sometimes the solution is right under your nose and still you can't smell it...

thanks a bunch!

 

[jfgambit]

it's 12:30...

all I smell is lunch!