There are 2 sections here for SSRS report.
- Configuring SSRS report
- Deploying the SSRS file to report server URL for scheduling report
Section 1: Configuring SSRS report
Step1: open Visual studio from All Program
At Run prompt – type devenv and enter.
Step2: Click CREATE project as shown
Step 3: Select Report server project wizard & enter your own project name as shown.
Step 5: create a data source.
- Step 5.1) click Edit.. to add server details etc
- Step 5.2) click credentials.. to add login details etc
Step 6) Paste the data fetching query here as shown and press Next >
Check the report format & spacing for your requirements as per above picture.
Section 2: Deploying SSRS reports:
Open internet browser with admin permission as shown.
Step 3: save the SSRS config as a .rdl file as shown.
Step 5: you can also open any existing folder & upload the .rdl as shown.
Once the .rdl file is uploaded, click the drop down button & click Manage option as shown
Schedule the report in subscription section as shown.