Moving from Access to SQL db

I have a program that users do plain data entry into, and the data is stored in an Access database.  I am going to redesign the program to store the data in SQL server.  After the data has been entered, the next day a user double clicks on a batch file that opens access and runs a macro that prints the data from a report that was created in access.  I want the users to able to enter the data into the program the same way (I can handle that)  and the other user to click on a batch file or somthing similar to what they have now that will generate documents for them to print.  Basicly I need help with creating, and automating the reports from the data in SQL Server. I hope that makes sense.  If you can point me in the right direction I would appreciate it.

Thanks,
WolfManBN25Asked:
Who is Participating?
 
dqmqCommented:
You can keep reports in Access, but I sense that is probably not what you want. Sql Sever has a reporting services component that you can also use to generate and deploy reports on a webserver.   Make sure to include reporting services in your install and you will get a Visual Studio interface for Reporting
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
If you don't have VS Express or Standard versions you can choose Crystal Reports for your reporting solution.
0
 
WolfManBN25Author Commented:
Is there a website that explains how to do this using the reporting services, or Crystal Reports.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.