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
Learn to analyze data sets, software programs and build a comprehensive bi solution by enrolling in our MSBI Online Training
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
----- Related Article: How to Create Table Report in Reporting Services - MSBI -----
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
https:// RAWAN:8080/Report server __DWH → Next → report name → finish
In Wizard → press build → click deploy option
----- Related Article: How to Setup Checkpoints in SSIS Package - MSBI -----
CREATING STANDARD REPORTING (Real time creating reports)
-
Subscribe to our youtube channel to get new updates..!
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 https:// rawan:8080/report server _DWH → click ok
-
Build → deploy
-
Go to the manager and observer the report
Frequently Asked MSBI Interview Questions & Answers
Data Regions in the report
-
Table
-
Matrix
-
List
-
Chart
-
Sub report etc
-
Guage
Report Items:
-
Image
-
Pointer
-
Line
-
Text box
-
Rectangle