Developing Crystal Reports with CSV data

Can I take a large CSV file dumped into a server and have Crystal Reports write reports off of that and if so what needs to be in place in order to do that. Anything special needs to be done. I heard I would have to convert to Excel then point to the excel file. Also I would assume I have to have a copy of MS Excel installed on the server so are there any products out there that would automatically convert the file regularly to an Excel file that Crystal could be set to run against?
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wykabryanCommented:
ummm.. well if you HAVE to work with a csv.  I would LINK it into an MS Access db.  By linking the csv, you can get it into the table format, you wont be restricted by 65K line limit, and you can then hook crystal into the table.  Furthermore, when the csv is updated (provided it is link) it will automatically update the table; provide the columns are all the same.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
You can report from the CSV file but you need to ensure the format is always the same.

Another idea would be to generate an XML file rather than a CSV and report against that.

mlmcc
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
mlmcc - Can you go back and look ( I will reward you the points ) at the open question I have stated "What is the most efficient formula for that pulls a range of numbers...." Seeing that all the account numbers and codes are on the left and account descriptions on the right (in all 3 images) and you did give me a formula solution. Can you see how if this is going to take one big formula or several ones that break up the groups into pieces and if so does that mean the best way is to group this based on the staggared columns. So if 4 staggard columns the best way is to do 4 seperate lengthy formulas. If it is a new question unrealated. I will write another question just let me know.? Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.