Crystal reports updating from spread sheet
Looks like I may need to do some VBA coding to clean it up...
Thanks _____________________________________Im not sure... If I open the spreadsheet in Excel (both) there are over 64,000 lines but Crystal will only read 16,400 of them.
You can also use this feature to design your own reports (even combining data from multiple company files), personalize invoices, create mail merges, etc.
In addition, you can write your own queries using Structured Query Language (SQL).
I have found a couple other limitations in the Crystal Excel ODBC.
Through ODBC, you can create spreadsheets in Excel, tables in Access, and reports in such ad hoc report writers as Crystal Reports that reflect your real-time Quick Books data._____________________________________I have never seen that, but I have seen it where there is a blank line or field that CR is looking for and when it can't find it, it stops reading lines. I will look at that but Im really thinking it is some sort of limitation because I have two files I am trying to read.The last time it happened to me, there was blank line that was hidden, so to CR, it looked like the data 'stopped', and it quit reading lines. Attach one, run, then attach the other and both of them stop reading about the same spot. Our customer noticed the problem when I reported back incorrect dollar figures and after analyzing both i determined they stopped in this general area.When you declare meet entries either by Name or Event, the first question TEAM MANAGER asks is what team are these entries for.For example, Billy may be assigned to an Unattached team in the Athlete Browser but if you declare meet entries for the FAST team, then FOR THIS ONE MEET, Billy's entries will be assigned to team FAST.