Quarterly Schedule Fails

My data driven report has been scheduled to send last quarters data on the
fifth day of a new quarter.
I set the schedule to send:
Monthly for: Jan, April, July, Oct and on
Calendar Day: 5 at 2am.
For some reason I received the report today, which happens to be May 5.
What am I doing wrong?I also check the system date on the Reporting Services Server, so that's not
the problem. Is there another way to schedule Quarterly report delivery?
"John Broomfield" wrote:
> My data driven report has been scheduled to send last quarters data on the
> fifth day of a new quarter.
> I set the schedule to send:
> Monthly for: Jan, April, July, Oct and on
> Calendar Day: 5 at 2am.
> For some reason I received the report today, which happens to be May 5.
> What am I doing wrong?
>

Qry with "OR" keyword assistance...

Is there a better more reliable or eaiser way to get what I'm looking for?
I want anything that was created after Jan. 1, 2003 that was declined, the
declined letter codes are as indicated, and created after Jan 1, 2003
Or, I want anything that was rated and created after Jan 1, 2003
Or, I want anything that was paid and created after Jan 1, 2005 and
(redundently) created after Jan 1, 2003
Or that was recently created in the most recent campaign occuring Sept 1, 20
05
and (redundently) created after Jan 1, 2003
where (c2.ltrcode in('4','13,'16')
or (c2.rated > '0')
or (isdate(c2.upremrecd = 1 and c1.createdt > '20050101')
or c1.createdt > '20050901')
and c1.createdt > '20030101'
TIA
JeffP...if you find this running slowly, you can use UNIONs to pull them all
together, e.g.
select <colum list>
from <tables>
where c1.createdt > '20030101'
and c2.ltrcode in ('4','13','16')
union
select <colum list>
from <tables>
where c1.createdt > '20030101'
and c2.rated > '0'
union
<etc>
JDP@.Work wrote:
> Is there a better more reliable or eaiser way to get what I'm looking for?
> I want anything that was created after Jan. 1, 2003 that was declined, the
> declined letter codes are as indicated, and created after Jan 1, 2003
> Or, I want anything that was rated and created after Jan 1, 2003
> Or, I want anything that was paid and created after Jan 1, 2005 and
> (redundently) created after Jan 1, 2003
> Or that was recently created in the most recent campaign occuring Sept 1,
2005
> and (redundently) created after Jan 1, 2003
> where (c2.ltrcode in('4','13,'16')
> or (c2.rated > '0')
> or (isdate(c2.upremrecd = 1 and c1.createdt > '20050101')
> or c1.createdt > '20050901')
> and c1.createdt > '20030101'
> TIA
> JeffP...
>