Crystal reports not updating


crystal reports not updating-3crystal reports not updating-44crystal reports not updating-37

The official Microsoft temporary solution is for us to use a different “OLEDB provider” in place of JET, but that only works if you can use OLEDB and/or choose your provider.

So I did some research and found a post from 2008 where someone was getting this error message.

number Var yr := ; // Current Year for Holidays date Var array holidays; redim holidays [12]; holidays [1] := Date (yr, 1, 1); // New Years Day holidays [2] := Date (yr, 1, 6) - Day Of Week (Date (yr, 1, 6) ) 16; //Martin Luther King Jr.

3rd Monday in Jan holidays [3] := Date (yr, 2, 6) - Day Of Week (Date (yr, 2, 6) ) 16; //Presidents Day 3rd Monday in Feb holidays [4] := Date (yr, 6, 1) - Day Of Week (Date (yr, 5, 28) 2); // Memorial Day last Monday in May holidays [5] := Date (yr, 7, 4); // Independence Day holidays [6] := Date (yr, 9, 6) - Day Of Week (Date (yr, 9, 6) ) 2; // Labor Day 1st Monday in Sept) holidays [7] := Date (yr, 10, 6) - Day Of Week (Date (yr, 10, 6) ) 9; //Columnbus Day 2nd Monday in Oct holidays [8] := Date (yr, 11, 11); //Veterans Day holidays [9] := Date (yr, 11, 3) - Day Of Week (Date (yr, 11, 3) ) 26; //Thanksgiving 4th Thursday in Nov holidays[10] := Date (yr, 12, 25); //Christmas Day holidays [11] := Date (yr 1, 1, 1); //New Years Day (next year) holidays [12] := Date (yr-1, 12, 25); //Christmas Day (last year) Local Number Var i; For i := 1 to 12 do ( if Dayof Week (holidays [i]) = 1 then holidays [i] := holidays [i] 1 else if Dayof Week (holidays [i]) = 7 then holidays [i] := holidays [i] -1 ); holidays[ 4] // Display one of the holidays You can also refer to this array when using my business days calculation, instead of using a hard coded list of holidays.

Usually the EXE and RPT are stored together in one folder, with a separate folder for each RPT file. These updates broke reports that use the ‘classic’ Microsoft JET drivers to read ‘classic’ xls spreadsheets.