Mixing Tables

[TEM3]

I am using Crystal Reports 8.5 and Oracle Tables.....

I have not tried this, but before I waste my time (if it is not to be)......

My report data is in Oracle Tables on a remote server that I have limited access to. While, if very careful, I can modify the data in the Oracle Tables, I cannot create new tables or new fields.

From time to time I would like to have data/information available to a report that does not exist in the Oracle Tables. Since it is information that I would probably use again and again, it would be nice to have it in a suplimental table.

Can I create, say, an Access table with the information I need and mix it in a report with the Oracle tables?

 

[TEM3]

I am going ahead with creating my table. I am going to add a field for the number of holidays in each month (up through 2009). The only two problem holidays I can see are New Years and Good Friday. If January 1st if a Saturday (like it was this year) we are off December 31st. Therefore that would bump December up 1 (from 1 to 2) and January down 1 (from 2 to 1, since we are off MLK Day). I think I can figure out that formula (to populate my table), but if someone has suggestions, please post.

What I need is a formula to determine which month (March or April) Good Friday falls in in any given year?????

 

[Madawc]

The date of Easter depends on the phases of the moon. There probably is a way to do it in Crystal, but I'd suggest checking the web for 'Date of Easter'. Then feed them in manually.

Madawc Williams (East Anglia, UK)