Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting from Excel

Status
Not open for further replies.
VE

VE

Technical User
Oct 25, 2000
220
US

I'm trying this again becuase my last question wasn't very clear.

Is it possible to run a report from an excel file that is very large (26 meg) and is linked to many many other excel files?

I've tried but I'm not getting all of the data. Any suggestions?

Thank you
 
Sort by date Sort by votes
What problems are you experiecing? Not all of the columns or not all of the rows of data, or not the data linked from other spreadsheets? What?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Upvote 0 Downvote

I think not all of the records. For instance, I know that I have records for codes 34014 and 34013 (I know this by either opening the spredsheet and filtering it, or saving it as test and importing it into Access).

If I connect to it with CR and select 34014 I get 2 records. If I select 31013 I get no records.

If I do the same thing in Access on the imported txt (I haven't been successfull getting access to link to the live spreadsheet) I get 5 records for 34013 and 55 for 34014.

Thank you
 
Upvote 0 Downvote
Have you tried using the Crystal Reports Excel add-in for this?

If not have a look at the Tools >> Add-ins menu and look for Crystal Report control

Add this and you will get an icon on your toolbar.

You can then use this to lasoo the data you want to report from the XL spreadsheet. I have used this a few times and it is pretty handy.


Cheers,

SurfingGecko
Home of Crystal Ease
 
Upvote 0 Downvote

OK, I found that and installed it. When I tried to use it it said not enough memory. It also said something about a paradox table which I have no idea why it would be associated with this, but I didn't create the excel spreadsheets, so nothing would surprize me at this point.

Kind of OT, but does anyone know how to find out how many things an excel spreadsheet is linked too?

Thank you
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
757
hilfy
hilfy
PaulWiersma
  • Locked
  • Question
Failed to retrieve data from database
Replies
1
Views
196
kray4660
kray4660
0sprey
  • Locked
  • Question
CR11 - Reading data from multiple Tabs within a single Excel file
Replies
4
Views
145
kenhamady
kenhamady
earljgray
  • Locked
  • Question
Missing Columns Excel -> Crystal Reports
Replies
6
Views
142
earljgray
earljgray
Tstegen
  • Locked
  • Question
Crystal Report - Failed to retreive data from the database
Replies
1
Views
99
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top