Solved

Monthly report

Posted on 2004-08-03
3
208 Views
Last Modified: 2010-04-05
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
0
Comment
Question by:joshfly
3 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 11702897
what database (if one)?
0
 

Author Comment

by:joshfly
ID: 11703457
hello,...im using MSSQL database. The report im using the delphi reportbuilder to do it...

any comment?

0
 
LVL 2

Accepted Solution

by:
DarkCore_ earned 50 total points
ID: 11712853
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now