Using String Variablein Report Object Reference

[Alan Z. Scharf]

I wnat to use a string variable, strReportName, in the reference below
instead of the hardcoded current actual report name of 'rptGraph'.


Reports!rptGraphs![PerfGraph].Object.Application.Chart.Axes(1).TickLabelSpac
ing = 2

Can someone give an example of the syntax for that?

Thanks.

Alan

 

[John Spencer]

Perhaps the following option will work for you.

Reports("rptGraphs")!PerfGraph.Object.Application.Chart.Axes(1).TickLabelSpac

 

[Alan Z. Scharf]

John,

Thanks very much.

That may well work with a string variable in first paren.

I wasn't aware of that alternative format.

Regards,

Alan

Perhaps the following option will work for you.

Reports("rptGraphs")!PerfGraph.Object.Application.Chart.Axes(1).TickLabelSpa
c

I wnat to use a string variable, strReportName, in the reference below
instead of the hardcoded current actual report name of 'rptGraph'.


Reports!rptGraphs![PerfGraph].Object.Application.Chart.Axes(1).TickLabelSpac
ing = 2

Can someone give an example of the syntax for that?

Thanks.

Alan