Monthly report

hello,
can any expert here tell me how to print a monthly report?
i got a salesmaster table contains SalesNo, SalesAmt and SalesDate

i want to print a report by month...which the report layout will have january, february, march.....december.

how can i print the month from the SalesDate acoording to month? example salesdate : 01/12/2004 (dd/mm/yyyy)

Thanks
joshflyAsked:
Who is Participating?
 
DarkCore_Connect With a Mentor Commented:
If you use Report builder then you can use something like that

In your SQL Statment add a field like this " SELECT ...., MONTH( date ) As my_month FROM ...... ORDER BY MONTH( date )"

Once ordered by month, in ReportBuilder you can create a Group using this field

Edu
0
 
kretzschmarCommented:
what database (if one)?
0
 
joshflyAuthor Commented:
hello,...im using MSSQL database. The report im using the delphi reportbuilder to do it...

any comment?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.