Report is generated with data from the database using Stored Procedure
The very first and fundamental step is to create a Stored Procedure.
In order to do that, it needs to be understood which fields are to be presented in a report.
That is more contextual, but here, let me focus on procedures.
(1) Create a Stored Procedure(.sql) on SQL Management Studio:
Select one that has already existed and do Right Click
> Choose “Script Stored Procedure as” : type a new name of the stored procedure
> “CREATE TO”
> “New Query Editor Window”
Then, the selected stored procedure will be copied with “CREATE [table]”in the script.
Firstly, “Execute” the procedure with “CREATE [table]”, then, this copied stored procedure will be automatically saved/added in the Stored Procedure>Programmability.
Next, change “CREATE [table]” into “ALTER [table]”.
(2)Create a schema (.xml) on Visual Studio
(3)Create a report(.rpt) on Visual Studio
“Set Database Location”
(4)Create a usercontrol(.ascx) on Visual Studio
(5)Modify/Create a .net file-C#(.aspx)