Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I have a procedure (script) that generates reports. It selects time span and individual Sales People and generates a report which I later send automatically, via a 3rd party engine, to the individual recipients.
Occasionally there is no data to report for an individual.
Is there a way to determine if there is no data in a chart so to skip the report?
Thanks
Josh
It depends what 3rd party engine you use.
In my experience in Macros I count the number of rows in the table that will be send:
SET obj = ActiveDocument.GetSheetObject("info1") control = obj.GetRowCount IF control> 1 THEN send_report vTO, vCC, reportFile, vName END IF
It depends what 3rd party engine you use.
In my experience in Macros I count the number of rows in the table that will be send:
SET obj = ActiveDocument.GetSheetObject("info1") control = obj.GetRowCount IF control> 1 THEN send_report vTO, vCC, reportFile, vName END IF
That worked !!!
Thanks