TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
see go
NA
1
0
do record count on crystal report on the fly
Aug 17 2008 2:00 AM
Hi All,
This is how my data loos like and this is what I need to do. I need to create a chart with where the x-axis has months and I nee dto show the count of open records for each month.
for ex: for month i need to create the open records so for month of april there will be 0 records as no data before that, for month of may there will be 1 open, for month of june there will be 5 open that is 4 of may and 1 of april.
so basically for each month i need the count of all previous month records. How can I achiece this. I am not gouping on anything, am placing the data in my report header. I have created a formula for Month but how do i get this count? Pls help
no Date_created status
1 4/30/2008 3:24:02 PM Risk / RAC Update Required
2 5/13/2008 6:25:56 PM Opened DI Complaint
3 5/14/2008 6:31:55 PM Investigation Lunar
4 5/19/2008 5:48:47 PM Complaint Summary
5 5/19/2008 8:08:00 PM Opened Complaint
6 6/19/2008 8:08:01 PM Opened DI Complaint
7 6/19/2008 8:08:01 PM Opened Complaint
8 6/19/2008 8:08:01 PM Opened Complaint
9 6/19/2008 8:08:02 PM Opened Complaint
10 7/19/2008 8:08:02 PM Opened Complaint
11 7/19/2008 8:08:03 PM Opened Complaint
12 7/19/2008 8:08:03 PM Opened Complaint
13 7/19/2008 8:08:03 PM Opened Complaint
14 7/19/2008 8:08:04 PM Opened Complaint
Reply
Answers (
0
)
How can i show summary in crytal report (VS)
using/calling/executing oracle packages/stored procedures in crystal reports without the use of .net