Hello. I was wondering if this was possible:
The first report (rpt A) has an sql database field that has a number 1 and number 0. 1 refers to reports to be scheduled and 0 means no reports are scheduled or have been scheduled already.
I want my report to go and check this database field, so when it equals 1 it will trigger an event to schedule a second report (rpt B). Once scheduled, rpt A flags the database field to zero.
Is this possible? Please help.
Best regardsI am not sure what you meant
Add rpt B as a subreport in rpt A
Then goto format section where rpt B located and in the suppress option write this code
{rpt A Field}=0
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment