I am new user to SSRS. I have created four different reports in SSRS 2008 R2 with single parameter in each report. Each report gets it result from executing different procedure. Is this possible to create a report with parameter field, when parameter is given then depending on the parameter it decide which report is to be generated e.g. if parameter given starts with A it passes the parameter and generate report 1 or  if parameter given starts with B it passes the parameter and generate report 2 and

Hi Muhammad, 

According to your description, you want to display different report based on the report parameter value, right? 

In Reporting Services, we can add a report parameter to dataset query so that the dataset will return the records based on our requirement. In your scenario, you can use a report parameter to control the displayed records instead of creating four tablixes. Please refer to the following steps: 

1. Modify your dataset query like below: 
   Select * from table_1 where UGdate > @date
2. And then the parameter date will automatically be created.

The result is like below: 

For more detail information, please refer to this blog: Adding Query Parameters to SQL Server 2008 Reporting Services Reports. 

Reference: 

Report Parameters

If you have any other question, please feel free to ask. 

Regards,
Shrek Li