Solved

Monthly report

Posted on 2004-08-03
3
207 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

896 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

15 Experts available now in Live!

Get 1:1 Help Now