Sorting of Date Field and Displaying Total and Grand Total

[shetami]

Hi,
I am developing reports for "TimeShareWare" Application

Am developing report on "Scheduled Tours By day"
I have added 2 Group - one is by Tour day and other is by Tour wave ie(Time)
User can select 2 parameters while refreshing the report, one is he can select "Date range" and other is "Tour Status" and see the report accordingly.

1 ) Am unable to sort Tour Day, when I go to Record Sort Expert and select field Tour day from the table, its not allowing me to choose any of the sorting options ie ascending or desending. Both th ebuttons are disabled.

2) I have to find the total number of people who have gone to tour for each Tour wave and each Tour Date and have to also display Grand Total.
Am unable to do this, have tried using Running Total fields, but am not successful in that. PLease come out with your suggestions

Fields in my report are as follows:
Guest name
Spouse Name
Phone
Email
Premium
Quantity
Tour Status
Tour ID
Tour Date
Tour Wave

Please suggest me some solution on above 2 problems
Its urgent.

[JaganEllis]

Problem 1 is because you have grouped on the field, so you need to use the GROUP expect to specify sort order, not the sort expert.

Problem 2 - why are summaries / running totals giving the wrong result? i.e. how have you configured them / what's wrong about them? examples?

[shetami]

Problem 1 ) Well am through with problem 1 ,
In Change Group Options -> Options
I ticked the check box - Keep Group together and
in Common tab i selected the option "for each day" for seection to be printed
My problem got solved there.


Problem 2 ) In Running Total Field have taken written formula accordingly,

Field to Summarize : GuestFullName
Summary : Count

Evaluate
On Change of Field: Tour.TourDate (Tour is a table name and TourDate is fieldname)

Reset
On Change of Group : Tour.TourDate

But am still not getting Total properly yet.

Thanks for your reply...

[JaganEllis]

We'll wait and see if Bill's answer to your question in another forum solves it for you...

[shetami]

Problem 2)
Have got through the Total and Grand total part

In report detail section, right click the "guest" field and "Insert" > "Summary". Select "count" and place it in group footer 1. Then copy and past the count into group footer 2 and report footer.