_____ _____ _____   _____   ____        _       _     
  / ____/ ____|  __ \ / ____| |  _ \      | |     | |    
 | (___| (___ | |__) | (___   | |_) | __ _| |_ ___| |__  
  \___ \\___ \|  _  / \___ \  |  _ < / _` | __/ __| '_ \ 
  ____) |___) | | \ \ ____) | | |_) | (_| | || (__| | | |
 |_____/_____/|_|  \_\_____/  |____/ \__,_|\__\___|_| |_|

SSRS Batch

Overview

This script takes in a configuration file and username/password to download reports from SQL Reporting Services to a shared location

This project came about because I often have people ask me for a bunch of reports. Rather than run each one by hand, which involves a lot of clicking, I created this script to iterate through a list of parameters and run the reports for me.

How to Use

To run this script:

python ssrs_batch.py [username] [optional: config file] [optional: password]

if you don't input a configuration file path it will default to "config.json". If you don't input a password, you will be prompted to enter it securely (no terminal echo)

To compile this script (e.g. using py2win or cx_freeze):

You need the Microsoft Visual C++ Runtime installed on the build machine. The necessary DLL is copied to the output.

For installed python:

1. Type the build command (below)

If running from WinPython 3.4 Zero

(https://sourceforge.net/projects/winpython/files/WinPython_3.4/3.4.4.6/)

1. Open the winpython folder.
2. Start the command prompt from the WinPython folder shortcut "WinPython Command Prompt.exe"
3. Type the build command (below)

Build command:

To build this project into an Executable (.exe)

python setup.py build