YaswanthManikanta_Module7_HandsOn_Assignment[1]

docx

School

Trine University *

*We aren’t endorsed by this school

Course

5003

Subject

Information Systems

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by AmbassadorPencilRedPanda44

1 Module 7 - Hands On – Assignment Yaswanth Manikanta Campbellsville University Advanced Database Dr. Amir Afzal

2 Module 7 - Hands On – Assignment Using the Microsoft SQL Server Report builder to generate reports. Following the steps outlined in the sample, we begin by downloading and installing the MS SQL server Report Builder.

3 Proceed by clicking the "Next" button to commence the installation procedure. Select the option adjacent to the "Agree" button to indicate your acceptance of the terms and conditions. Install.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

4 Choose your default target server.

5 Click install button to begin the installation process. It may take some time. Now launch the report builder after installation is over

6 The next step is to establish a connection to a data source. Click File, then new, then finally new report. Then choose Chart Wizard. Choose create dataset then click next.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

7 Give your dataset a preferred name. And on the connection string click build

8 Enter the server name and authentication type. You may also connect to a database by selecting it from the dropdown menu. And then click OK. Clickick test connection then click ok.

9 Choose the tables to work with then click next.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

11 Select the data points that will serve as rows and columns in the chart in the following box. In addition to selecting Next, then Finish.

12 Add a title and Run to generate the report. Repeat the processes for other reports.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

14 Challenges faced Several obstacles were encountered during the process of constructing the reports above.  The topic of concern is data quality. During the report construction process, it was observed that specific data present in the database was not being incorporated in the report output post- execution.  The process of combining and harmonizing data from multiple sources to provide a unified view is called data integration. The method of generating a report from disparate tables in a database lacking any inherent relationship proved to be a challenging task during establishing the data source connection.  The issue of establishing a connection to the data source for each report was a significant challenge.

YaswanthManikanta_Module7_HandsOn_Assignment[1]

Related Documents