.::: Create Report SQL Server Using SSRS (Sample Lab ) :::.

A. Check Table SQL Server
select * from barang;

B. Install & Enable SSRS Service

C. Create New Project Using Report Wizard
1. Create Data Source from Report Wizard (example) 

2. change Datasets (change to Example Data Barang)
3. additional Formula (example sum) & Click Preview
=Sum(Fields!STOK_BARANG.Value, "DataSet1"
or
=Sum(Fields!STOK_BARANG.Value, "Data Barang"

4. Additional Datasets example (DataCustomer) & Click Preview

 

5. Reports -> Select report & Run
 

 

6. Check Report http://localhost/ReportServer