Creating Generic SSRS Report - 1

• End User will have direct access to Master Report. Master Report will show links for accessing list of reports coming from “Report Metadata” & “Pattern Metadata” tables.  

•  When user clicks on any link. He is now redirected to specific “Generic Report” based on Pattern ID in “Report Metadata” table and which is stored in “Pattern Metadata” Table. 

• Now, This generic reports makes call to two different stored procedures, viz:
• spReportMetedata: For getting Label Names based on Report ID from tblReportMetadata.
• spReportData: For getting data records based on Report ID from respective data tables.