Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to link Excel tabs so data shows up in one report

I have a huge excel file with 16 tabs (sheets) of data. Each tab has an excel speadsheet filled. I have the data in Crystal. Each tab shows up as a separate table. I've tried to link each in different ways but can only get one table to show up in the report. I want all the data in one report. If that's possible. It would be very large.

Former Member
replied

David,

Linking the tables just ensures that related data is returned. If you want to display all of the data from all tables you willneed to put the fields from each table on the report or create a formula that adds them together.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question