Steps to Create Report Items, Data Regions & Data sources - MSBI

Creating Reports

There are 3 ways to create re ports

By using report server project wizard
By using report server project
By using report model & builder

STEPS TO CREATE A REPORT:

Create a data Source
Create a data set
Take the report layout
Design the layout
Use the data set fields in the layout
Do parameterization (or) implement actions (optional)
Public the report
View the report from the report manager (or) report server (or) control from any 3rd party. Applications (or) Report viewer etc

Data Source:

It is a connection to the database
Data set: It is a logical representation of table (or ) tables.
Shared data source: It is a data source which can be used across any report in the same solution
1) Create a Report by using Report server project wizard:
Open bids → file → new project → select template as project server project wizard → assign name → click ok → new data source → type → click edit

Next → click query builder → query designer → add table → select required fields → click ok.

next → select the report type (tabular, matrix) → next → design the table → choose
Choose the Available fields into page, group and details

Remove → click next → choose the table layout → stepped (or) blocked → next → specify color → next → choose the deployment location → report server

http:// RAWAN:8080/Report server __DWH → Next → report name → finish
In Wizard → press build → click deploy option

CREATING STANDARD REPORTING (Real time creating reports)

Open BIDS → New Project → select Template as Report server project → click ok
View → solution Explorer → Shared Data sources → RT click → Add new Data Source and Create a data source for DB-MSBI
Reports → RT click → Add → New Item → Report → specify name (report _ partyard)
Add → view → Tool box → Drag the Table Region on to the layout.
View → Report data → New → Data Source → Specify any name (DST_DBMS BI) → click the option “use shared data source reference → click ok
New → Data set → specify name (DST_DBMSBI) → Data source (DS_DB_MSBI) → Query Type → click Text option → Query designer (if we do not know how to write a query)
Drag and drop Data set fields on the layout (or) Select the Fields in the Layout
Preview
View → solution Explorer → solution RT click → Properties → In “Target Server URL “Option we should enter the URL Manully http:// rawan:8080/report server _DWH → click ok
Build → deploy
Go to the manager and observer the report

Data Regions in the report

Table
Matrix
List
Chart
Sub report etc
Guage

Report Items:

a) Image
b) Pointer
c) Line
d) Text box
e) Rectangle

Enroll for Live Instructor Led Online MSBI TRAINING

Blog