on 09-06-2008 10:59 PM
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.
David,
Each worksheet should appear as a table in CR and if there are linkable fields then you should be able to set up the links in the Links tab of the database expert. If you are unable to see the tables/sheets in the database expert or links tab then you might want to try defining the workseets in Excel. Highlight the column headers and data > Insert > Name > Define. Enter in the sheet name or the name you want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Graham,
Thanks for answering,
Yes I have the tables and can link them (have tried a couple of different ways) One has all the data fields linked between tables and the other way was to run them in series with just one field linked. Either way the Field Explorer on the right side of the screen shows each table and each table lists all the fields. But the problem is that the report only shows data from one table, not all the tables or all the data. The data that it shows is only from the table that I selected the fields from.
Hope this makes sense. Thanks
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.