There are 3 ways to create reports
|If you want to enrich your career and become a professional in MSBI, then enroll in "MSBI Training" - This course will help you to achieve excellence in this domain.|
|Related Article: How to Create Table Report in Reporting Services - MSBI|
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 the 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 → adds 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|
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 the name (report _ part yard)
Add → view → Toolbox → Drag the Table Region onto 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
View → solution Explorer → solution RT click → Properties → In “Target Server URL “Option we should enter the URL Manually https:// rawan:8080/report server _DWH → click ok
Build → deploy
Go to the manager and observer the report
|Related Article: Msbi Interview Questions|
|Explore MSBI Sample Resumes Download & Edit, Get Noticed by Top Employers!|
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.