How do I obtain reports on a secure webserver
I should probably read the reams and reams on the BO/SAP site, but hopefully one of you experienced guys can point me in the right direction.
- I have a remote webserver that currently only accepts remote desktop from a chosen list of static IPs. The server is a couple of hours drive away.
- I have currently purchased CR2008
- The webserver is running WIndows Server 2003 and SQL Server 2005 and a public website.
- I have created some reports that work fine in CR2008 using a local copy of the data running on SQL server on my PC, with data taken from the nightly backup and imported into my local SQL server. This is a fairly - cumbersome procedure at the moment!
I want to be able to create a VB.Net (2005) application that allows a report to be selected and printed. Ideally my app would cycle through the list of reports, refresh the data, convert to PDF and attach to an email.
What is the best way to do this? I dont need help with the programming, just how to do the data connections / topology or what options I have. The data needs to be kept secure and ideally wouldnt compromise the security of our server. I am very experienced with .Net, but not very with ASP.Net.
Many thanks for your time!