Hi All
I have report in which i have a container holding 5 reports,displaying them as tabs .I have cloned one of those reports and made few conditions changes and added it back to same container as a new table with a diff name.But now i don' t see the object ID of new table in the list under sheet properties, but strangely i see the object Id's of other tables in the same container in sheet properties.
i have macro in the same report which exports all the reports in container to excel,i modified the macro to export this new table along with others as well,but it fails while copying new table contents.
When i will be on the tab of new table (Active) then it will export but if i go on to a diff tab it will again fail while trying to export new table added.
Also, if i keep a copy of the new table outside the container then also it is able to export the report along with others.
Please help if i am missing anything here.
My aim here is i should be able to export all the reports to excel
