Tips and Tricks: pulling data based on "months" reports

Print Page | Close Window

pulling data based on "months" reports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14615
Printed Date: 16 May 2024 at 4:40pm

Topic: pulling data based on "months" reports

Posted By: poppy
Subject: pulling data based on "months" reports
Date Posted: 07 Oct 2011 at 3:56am

Hi, I am having a trouble with a report I am trying generate. I have some experiences with crystal reports, but this report I am trying to pull has gotten me stump. Any help/advice is very much appreciated.

We have a database that data gets enter on a daily basis. I connect to crystal reports through OLE DB (ADO). The following fields are fields that I need to show in the report.

Table name: FEES

LastName_

FirstName_

State_

Month_

Date_Created

A total of 646 people are in the database.

The field name "Date_created" (located in the same FEES table) which records the date and time that the record was recorded.

The report that I need to generate needs to pull data (lastname, firstname, state, and month, Date_Created) that did not report at the end of the month.

So, if John Smith did not reported his data for the month of October, I need his information (lastname, firstname, state, month, Date_Created) to pull from the data.