...

#2.Add Dataset and parameters as per the use case

#3.Add the tables/visuals

#4.Add storing/grouping as and when required

5.2 Deployment of new report

#1 Deploy RDL file to report server

#2 Create statement an entry for new report in OperationalReport  table

IF NOT EXISTS (SELECT * FROM OperationalReport WHERE ReportName = 'WIOAMasterReport' AND CategoryId = 12)

BEGIN

INSERT OperationalReport (ReportName, DisplayName, ShowReport, CategoryId)

VALUES('WIOAMasterReport', 'ETA9173', 1, 12)

END

GO

Note: Need tp get the details (ReportName, DisplayName, ShowReport, CategoryId) from business requirement

#3 Mark has to do the assignment of report for positioning

...

6.1 Steps involved for modification of existing reports

#1.

6.2 Deployment of existing report

...

#5 Post review , change the target settings for that particular project and deploy it to production. Note: This required approval from Mark and permission from Vinayak

11. List of DB Tables

Note: Above list may have more tables . Need to update

...