Question reReports

[jduenyas]

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

[MindaugasBacius · Accepted solution]

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

[jduenyas]

That worked !!!

Thanks