Passing invoice number into a Summary SSRS report as parameter. Auto download ALL generated PDF reports into a window folder with a special file name format i.e. _.pdf Any clue how to achieve this via SSRS, Store Procedure or Power Shell?
Hi there, before I start please note I have little/no VBA experience so please be kind Relatively speaking, I've got a pretty simple database. The presenters at our community radio station fill out a form of what song they play and this (along with the system time) is stored in a table. I have a wildcard query to bring up all entries from a certain date and at present, I export a report of this by hand on a Saturday for everyday of the previous week - but I want to automate this?! I can change the query to be a standard one to just bring up entries for today. I then, somehow, need to automatically export a report of this query as a PDF at midnight every night into a certain folder with the file name being today's date.
This is where my knowledge starts to fizzle out so any help would be greatly appreciated and I'll of course give you a shout out on air! You've lost me sorry I took the combination of your code and put it into a class module but nothing happened.
So I put the code behind a button and clicked it - nothing. I then took the date bit out and just gave it a fixed file name and all it does it output a file called 0 to the specified directory I'm probably doing very wrong but my lack of VBA is holding me back so apologies. As the main database is often closed by presenters, could I make another one and link the tables, query and report to the data in the main one. Then do the fancy stuff to export the PDF when the database is opened and then schedule it to open at midnight, do the export when open then close?
![Automatically Export Report As PDF Automatically Export Report As PDF](https://docs.wialon.com/en/hosting/_media/reports/export.png)
Thanks for all your help - much appreciated Adam.