VB .NET Making Reports / Printing Data


My Application generates a lot of data in CSV (& some ASCII text) format. My Goal is to post process this Data & generate printable reports. I would like some suggestions with small samples or links. It would be really good if I could do some graphs also. I am prepared to use Crystal Reports as a solution but I cannot transform my data into Access or SQL server database. The data has to be read & saved always as CSV (I am short on resources and other parts of my application use this data so I cannot change the format)


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.

If you can import the data into a Dataset from the CSV file, then you can associate the dataset to a Crystal Report. I think this is totally possible.
y1381Author Commented:
Can you tell me how to do it ?


That would be a lot of steps and code...maybe let me know what you are capable of?

Do you know how to design a dataset?
Do you know how to read a CSV file's contents in code?
Do you know how to fill a dataset?
Do you know how to design a crystal report?
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

y1381Author Commented:

Do you know how to design a dataset? NO

Do you know how to read a CSV file's contents in code? Yes

Do you know how to fill a dataset? Yes but only from a OleDbDataReader and SqlDataReader

Do you know how to design a crystal report? Yes


'Variables and objects
Dim oDs As new DataSet("dsCSVReporting")
Dim oConn As OleDbConnection
Dim oComm As OleDbDataAdapter

oConn = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=C:\temp\file.txt; Extended Properties=Text;HDR=No;FMT=Delimited") ---> Something like this...not sure if perfect, but you probably know...;)

oComm = New OleDbDataAdapter("select * from file.txt", oConn) ---> Syntax may be slightly off...;)
oComm.TableMappings.Add("Table", "Import")

---Now you can fill the dataset
oComm.Fill(oDs, "Import")

Me.rptViewer.ReportSource = rptTest

I have not worked with CSV myself directly, but Excel....so the OleDbDataAdapter Line for oComm and the connection string you will need to figure out...basically once you have created the Dataset and filled it...you should then be able to attach it to a Crystal Report (within your Crystal Report you would need to create it based on a defined dataset)

The dataset would have to be manually created by Adding a DATASET to your project, and designing a table with elements to match the columns of your CSV file...

Hopefully you make use of this.


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
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
Visual Basic.NET

From novice to tech pro — start learning today.