Hi,
I'm using CR XI and CR Server.
What I need to do is email an Excel report out if the report has some data in it. Don't email it if no data is in the file. In order to do this I'm doing the following via CR Server in the following order:
1)
Running the report and outputting to disk a .txt version.
Runs weekly on Mondays at 8 AM.
2)
Running a second instance of the report that emails out an Excel version of the file. This report is scheduled to run at 8:05 AM on Mondays and its also dependent upon a file event having been triggered in CR Server.
3)
At 8:10 on Mondays a .bat batch file greps the .txt file (created in step 1) for certain info that would be present if the report did output data. If it finds this info it creates a .event file (the file event flag file). This should satisfy the event I have setup in CR which the report in step 2 is dependent upon.
The report in step 1 works fine.
The report in step 2 is scheduled fine but it never takes off after the file event is triggered (or maybe it isn't being triggered) in step 3. I don't even know how to tell if it is being triggered or not.
When scheduling everything I did it in this order... First I scheduled the .txt output report. Second I scheduled the file event second (made sure no .event flag files existed when I did this). Third I scheduled the Excel version of the report. Fourth I scheduled the .bat file.
I figured the report that emails out the Excel file would start and check to see if the event was triggered and that it would run if the event was triggered anytime between the 8:05 report start time and the following Monday's 8:05 report start time.
I attempted to reschedule so the file event occurs before the Excel report starts and that didn't work either.
Anyone have any ideas?
Thanks in advance!
I'm using CR XI and CR Server.
What I need to do is email an Excel report out if the report has some data in it. Don't email it if no data is in the file. In order to do this I'm doing the following via CR Server in the following order:
1)
Running the report and outputting to disk a .txt version.
Runs weekly on Mondays at 8 AM.
2)
Running a second instance of the report that emails out an Excel version of the file. This report is scheduled to run at 8:05 AM on Mondays and its also dependent upon a file event having been triggered in CR Server.
3)
At 8:10 on Mondays a .bat batch file greps the .txt file (created in step 1) for certain info that would be present if the report did output data. If it finds this info it creates a .event file (the file event flag file). This should satisfy the event I have setup in CR which the report in step 2 is dependent upon.
The report in step 1 works fine.
The report in step 2 is scheduled fine but it never takes off after the file event is triggered (or maybe it isn't being triggered) in step 3. I don't even know how to tell if it is being triggered or not.
When scheduling everything I did it in this order... First I scheduled the .txt output report. Second I scheduled the file event second (made sure no .event flag files existed when I did this). Third I scheduled the Excel version of the report. Fourth I scheduled the .bat file.
I figured the report that emails out the Excel file would start and check to see if the event was triggered and that it would run if the event was triggered anytime between the 8:05 report start time and the following Monday's 8:05 report start time.
I attempted to reschedule so the file event occurs before the Excel report starts and that didn't work either.
Anyone have any ideas?
Thanks in advance!