Pls Help...

Hi,
I have designed crystal report using vb.net. It has two tables Orders and Customers. I have used two Group section in that report.

Group#1 orders.ShipName
Group#2 orders.ShipDate

The data type of ShipDate is DateTime. But i want to show the report ShipDate Monthly wise.
Like As Follows ,
January
<ShipName>
<orderDetails>
;
;


I am beginner to crystal report. pls help...
Thanks in Advance...

Hi,

Create a formula named month_custom_group and edit it with the following code.

monthname(month(DateTime({orders.ShipDate}))).

Now go to group expert and add group by choosing the month_custom_group formula for grouping field.

This should be your first group.

I think this will work.

Or just choose the group's options (group expert, highlight the shipdate group, press the Options button) and change the 'This section will be printed:' to 'for each month'