how can i group the record in crystalreport.......

 

in count() function i want to group the records by month wise of dates

 

ex.

 

count({License.srno},{License.payment_date},group condition);

 

now i want to group the records in Month({License.payment_date})

 

how can it's possible in crystal report..

else

please contact on this id

 

because i can't be able to do it my group problem...

please reply me...

Saroop

For various reasons I don't give out my email address on-line - sorry!

 

Which version of Crystal are you using?

 

In XI and 2008 when you create a group on a date type field, at the bottom of the screen where you select the the field to group on, there is a section with the lable "This section will be printed" and a drop-down list to select when it will be printed.  In the drop-down list, select "for each month".

 

If this is not available, it means that the field in the database is not a "date" but probably a "string".  In this case, you need to create a formula to convert the string to a date (look at the Date(), Left(), Right(), and Mid() functions in Help) and then group on the formula instead of the field.

 

-Dell 

 

What you'll have to do is create a subreport to get the counts.  The subreport will use the same tables as your main report, but it will be grouped by date and then by fee type.  Place the subreport where you want the counts to appear.

 

-Dell