I need to automate some reports and I'm looking for advice on some ways I can do that. I receive a daily csv file that I then import into an excel spreadsheet which I then generate graph reports from. I then export the graphs as PDF and email them. I would like to automate the entire process including saving the csv attachment that comes in on email to a location on the network.
I have some experience using VBA to automate and perform functions. I'm not a fan of the reporting tools built into access which is why I'm using Excel but I'm open to using crystal reports if there is a reliable solution using crystal.
Crystal could do what you want. Here is a method of running the reports using a dataset as the report source.
Feeding Crystal Reports from your application
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…