Highest week of sales/usage

I'm working with Crystal Reports 10 with a Sql Server 2000 database. I've got a table which stores the details of items including the saletimes (a date/time field). I need to calculate the sales figure for the highest week of sales. In other words I need to find out what the highest amount of sales recorded in any given week. How can I do this?Quickest way would be to create a group based on date, and in the group options select "for each week" as the required grouping.
Create Sum(sigma sysmbol) fields for the data.
Suppress your details section.
In the group footer you will have Totals based on weekly aggregates.
In the Report menu, select TopN/Sort Group Expert.
Select the Tab for your weekly group (if you have more than one group that is).
In"for This Group Sort" change All to TopN.
Enter 1 in the "Where N is" field.
Remove the tick from the "Show others" checkbox.
OK that dialog.
Run you report. Should see only highest weeks.
May want to format the Date Field in your group to show start end end date of the week that finished top........

Hope this helps

dave|||re above - this is all client-side in Crystal.
would be quicker if could achieve it in SQL on server-side, but above solution is quick-ish, because Crystal's query to SQL Server will include an SQL-compliant "TopN" modifier.

dave

Hiding Tooltip text displayed when mouse is over a Crystal Report Field

I want to Hide the Tooltip kind of text
which is displayed when mouse is over a
Crystal Report Field be it a parameter field
or database field in Crsytal Report with
VB.Net.
Thanks in adv.
RitamI am also facing the same problem is there any one available for help??|||I'm using CR 10. Under File -> Options -> Layout Tab there is a checkbox option for Tool tips both in design and preview. Hope that helps.|||You need to put a code in the tag fields... Sorry but thats the only way..

Put Chr(9) in every tag.

FredjeV|||Hi:

How can I put the tag fields with vb6 and crviewer?

Thanks

Hiding A Field

HI,

On a label generated using Crystal, I have added a use by date based on todays date. However if the product id field is blank, then I wish the use by date to also be blank. At the moment I am using an If...Then...Else statement.

I.e.

If ProductID <> "" Then
CurrentDate + 730
Else
CDate(0);

But, this yields the date 30/12/1899 if the productid is blank. Any ideas?

ps I'm using CrystalReports8.5right click on the field and goto suppress ,there write down

is null(Product_ID)

pracalus.