SSRS - Create batch executing function for the reports which cannot use Data-driven Subscription functionality - V2 (...reviewing, V3 is coming soon.)

Please note that there is a more powerful method I have developed, the new function can meet concurrent requirement while the existing one only allows single-user to execute it. I will update this article as soon as possible.

Here is the scenario:
Users manually run the specific report by using a set of predefined parameters to export reports with different purposes/results. Instead of manually running the report one by one, users want to automatically run it by maintaining those parameters in the table.

The first thought came to my mind is Data-driven Subscription functionality in Reporting Services, unfortunately, the specific report uses too complex dynamic design, which means it use many user-defined parameters to dynamically control report's interface. When I was trying to use the function, I received the following error message:

SSRS - Line Chart - Create stacked line and start from 0

Stakeholders want a Stacked Line Chart to illustrate the difference of accumulative value between Actual and Forecast, unfortunately, SSRS doesn't provide this type of chart. There are 5 columns in original dataset: ProjectID, Project_Name, Category(Actual or Forecast), Transaction_Period, and Amount.

First of all, I need to check initial result of graph from original dataset, so I drag a Line Chart in the report, in Values section, add field Amount; in Category Groups, add field Transaction_Period; in Series Groups, add field Category.

SSRS - Column Chart - Provide enough space for parent category group

There is a Column chart, in the Values section: Sales, and there are two Category Groups: Project and Quarter. Here is the situation, the chart doesn't provide enough space for some Quarter groups which they don't have enough projects displayed in the chart, see the following initial graph:

SSRS - Stacked Column Chart - Place label outside column

When I create a normal Column Chart, go to Series\Properties\Label\Position, and select which position I want to place the label. Once I create Stacked Column Chart, this attribute seems doesn't work, neither does the SmartLabels section, after I searched relevant articles about this issue, there is a way to enable SmartLabels function by shrinking column width: Series\Properties\CustomeAttributes\PointWidth.

SSRS - Scatter Chart - Create bound line

There is a scatter chart made with 75th, average and 25th bound line in Excel (chart type: Scatter with Straight Lines), the problem is I need to execute some manual steps to illustrate this chart. First of all, refresh two data sources which come from SQL Server, then modify criteria for identifying plots and modify calculation for those line.