Have been trying this out for sometime with no success. I want to be able to use pdf printing application like pdfprinter to print my vb reports to and then save the reports to a particular location on my computer.
I'm not sure if this is the solution you are looking for, but PDFCreator (which is free) has a feature to save PDFs that get send to it's virtual printer to a specific location.
On it's site (http://sourceforge.net/projects/pdfcreator/ )it says under features:
AutoSave files to folders and filenames based on Tags like Username, Computername, Date, Time etc.
My company has been using it for the last 4-5 years without any problems
Dim Adapter As New OleDbDataAdapter
Dim Command As New OleDbCommand
Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))
Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))
sqlQuery = MainQuery ...