The substitution isn't supported in reports. There're other ways to achive the result w/o it.
The question is how different are your tables report_1 - report_10. If they're totaly different then you're better of creating 10 separate reports. If the difference is only in the field names than you can use Select statements to convert them to one structure. The other option would be to put 10 layers of fields on you report with Print When condition pnReport = < n > and set private vriable pnReport in the code that executes report to the value coresponded to the curent sorce table report_1 - report_10.

>Hi! I need some assistance with a report that uses macro substitution. The form that calls the report can open a series of tables (chosen by the user). All the table structures are the same except for one. This particular table structure can range from report_1 to report_10. For this form, I have only one report designed. I wish to know if anyone knows of a good way to let me keep this one report instead of having to make 10 different ones that will reflect the one table structure. Right now I have print when expressions on the report that read like: report_1 > 0 (this needs to be true for all the reports).
>
>I assumed I could have used a global variable (gcIndex), but it did not work. Then I tried to SQL the original table into a cursor, but that did not work because it kept the original table structure. Next I tried a SCATTER GATHER method, but it did not bring over the data in the report_1 field because the field did not match. I would hate to use an array because when I try to append an array from a large table, it blows a insufficient memory error.
>
>I also tried to create a table by the SQL SELECT, but that did not work. Finally, I attempted in creating a seperate table to hold the actual table and index in it (profit.report_1). But then I realize that it would not work in the report because when you place it into a variable (gcIndex) and attempt to do a print when expression, it does not work.
>
>Any suggestions that I have not tried?? Thanks!!