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?
ruavol2Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

wykabryanConnect With a Mentor Commented:
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.
mlmccConnect With a Mentor Commented:
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.

ruavol2Tableau 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.
All Courses

From novice to tech pro — start learning today.