printout to include info prior to today

[okuser]

I will explain this as best as I can. I am using CR8.5 and am trying to manipulate a report that was written by my software manufacturer. It is a time and attendance report for a specific date range. The report has already been written and is fully functioning. I am only trying to do 2 things to the report to customize it the way I need.

1. Pull only a specific Division ID
2. Pull the report but only show the information up through the day before today. For example: the payperiod starts 2/6/04 and ends 2/19/04. Today is 2/17/04 so I only want to show the times from 2/6/04 to 2/16/04. The remainder of the report will show the dates but no information on those days. This is a report that is generated and sent to a client.

I have set a select expert condition for #1 and have it working. #2 is the problem, I am not sure how to approach this. I was trying to do a record selection of periodstart <= currentdate -1 but it does not work. I am not sure if I am doing it wrong or if there is inteference with how they wrote the report or if it is because there is already a record selection criteria. I am not sure if this is enough explaination but hopefully it will be. Any advise would be helpful.

Thanks in advance.

Gayla
CR8.5 newbie

 

[LidoDeJesolo]

Instructions for CR 8.5:

Right-click your date field.
Click Select Expert...
In the drop-down select &quot;is between&quot;
now in the top box put in your start date/time &quot;02/06/2004 00:00:00&quot;
now in the bottom box enter &quot;currentdate-1&quot;
Click OK

This will produce the report from 02/06/2004 to yesterday. However do bear in mind that it will be 00:00:00 time yesterday...

To ensure you are getting the results you require, I would enable both date and time in your report temporarily as a check.

Hope this helps.


Lido
Developement Engineer
Manchester, UK

 

[lbass]

I think you should share the existing record selection statement, so we can see if there is in fact a conflict. Go to report->edit selection formula->record and copy the statement and then paste it into your post. Also, check edit selection formula->group and see if there is a group select.

-LB

 

[synapsevampire]

Rows returned might be altered by 2 means in the report:

Record selection formula for record and group (the above posts)

Directly modifying the SQL (Database Show SQL Query)

If the latter, then you'll want to assure that there isn't anything hardcoded that might cause problems.

They might also base the report on Stored Procedures or a View which could conceivably preclude your request, the Database->Set Location will tell you the source of the report.

The overall request is fairly simple, but you may want to learn what the data source is and it's connectivity if you experience difficulties.

-k

 

[okuser]

As requested, here is my record selection.

{RptAttendance.DivisionID} = &quot;00000006&quot;

There is nothing in the group selection.

I will try the suggestion given by Lido and see if I can get it to work.

Thanks for the help
Gayla