Is it possible to get the snapshot of data displayed in a report. For example i want the data displayed in a straight chart table or pivot table . I know i can export it to excel but i want to automate this process of exporting to excel. I don't want to use macros. Is this possible?
