Run Report on particular date

[pinkpoppy]

Hello,

I am new to crystal reports and working on one that requires some reports to run on a particular date. We enter numberous information everday and need a report to show which applicants are missing for a specific month. I need the report generated every 20th of the month.

I have the following fields that are going to use:
LastName_
FirstName_
Monthly_Meeting
Year_
Month_
Date_Created - Date Created shows the date and time the information was entered. eg, 10/3/2011 8:50 am

 

[lbass]

You need to identify the tables you are using, how they are linked, and also identify the table for each field, as in {table.field}. What is your record selection formula currently?

-LB

 

[hilfy]

How are you accessing/running your reports? Do you have BO Enterprise, Crystal Enterprise, or Crystal Reports Server? Those tools provide you the means to schedule your report to run at a specific time.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[pinkpoppy]

Thanks for the replies guys.

The table is Meeting_Main. It is the main table. The fields are as followed:
{Meeting_Main.LastName}{Meeting_Main.FirstName}{Meeting_Main.Monthly_Meeting}{Meeting_Main.Month}{Meeting_Main.Year}{Meeting_Main.Create_Date}

I am accessing the data through OLD BD (ADO).

 

[pinkpoppy]

I'm sorry, I might need to explain the citeria a little more.

Some applicants can not make it to the monthly meeting, and we need to know who does not attend so that we can send out a 2nd monthly meeting day for them to attend. The names of the person who did not attend the meeting are recorded. I need the report to show who did not attend the meeting after the 20th day of the month.

LastName_ ""
FirstName_ ""
Monthly_Meeting - varchar (yes/no)
Year_ -4 digit number for year
Month_ - numeric 1 – 12 – month of data
Date_Created - Date Created shows the date and time the information was entered. eg, 10/3/2011 8:50 am

 

[lbass]

If you run this on the 20th of the month, the following selection would pick up those who didn't attend the meeting earlier in the same month.

{Meeting_Main.Month}=month(currentdate) and
{Meeting_Main.Year}=year(currentdate) and
{Meeting_Main.Monthly_Meeting} = 'no'

This assumes that Month and Year datatypes are numbers, not strings.

-LB

 

[pinkpoppy]

Thanks so much! it works great!