SSRS - How to add a Data Source & Dataset

 



SSRS - How to add a Data Source & Dataset

By: Naomi A.

This article covers:

  1. HOW TO ADD A DATA SOURCE
  2. HOW TO ADD A DATASET

Prerequisites:

Have Report Builder downloaded (you can download from Microsoft)

TUTORIAL:

HOW TO ADD A DATA SOURCE:

1. Have SSRS open, you can find it using the windows search bar

2.Right-click on data source and select “Add Data Source…”


3. The Data Source Properties dialog box opens.

  • Select Use a shared connection or report model. 
  • If you have recently connected to shared data sources and report models, it will appear in the box below.
  • To select one from a report server, click Browse and browse to the folder on the report server where shared data sources are available.

-- In this article I am showing how to connect to a shared data source in Report Builder --

1.     The "Select Data Source window" will pop up  

4. Select the shared data source and then click Open.

5. Select OK.

5. Test the connection
        • Select “Test Connection”
        • If it runs successfully, keep going, if not then retrace the previous steps.

HOW TO ADD A DATASET:

1. Right-click dataset and then “Add dataset”

2. Make sure “Use a dataset embedded in my report” is selected
3. Select the data source you just added from the dropdown
4. Query type is “Text” by default + Paste your code



Comments

Post a Comment

Popular posts from this blog

Run Queries in SQL Server Using Python!

Run Queries in SQL Server Using Python! By Naomi A. This is a fairly quick one - all of the info needed on how the script works is in the comments! The full script is ready for download on GitHub: (LINK) # Import the pyodbc module. #This module allows Python to connect to an ODBC database, like SQL Server. import pyodbc # The variables hold the server name, database name, username, and password. # This is necessary in order to connect to the SQL Server database. server = 'ServerName' database = 'DBName' username = 'user' password = 'password' # Connection string: # This is a formatted string that the ODBC driver uses to know who is connecting (username and password), # where they are connecting to (server and database), # and what driver they are using to make the connection (ODBC Driver 17 for SQL Server). connection_string = f 'DRIVER= {{ ODBC Driver 17 for SQL Server }} ;SERVER= { server } ;DATABASE= { database } ;UID= { username } ;PWD...
Read more

How to Create a Neural Network for Recognizing Hand-Drawn Shapes

Image
How to Create a Neural Network for Recognizing Hand-Drawn Shapes by Naomi A. In this guide, we will walk through the process of developing a neural network that identifies hand-drawn shapes. The tutorial is broken down into three main sections: Preprocessing the hand-drawn shapes. Training a neural network to recognize these shapes. Creating a simple user interface to predict the drawn shapes. All code is available on github under the MIT License. (LINK TO REPO)    1. MNIST Maker: Preprocessing Hand-Drawn Shapes Objective : Convert the images of hand-drawn shapes into a standardized format for machine learning. Steps: Load the images from a specified directory. Convert them to grayscale and resize them to 28x28 pixels. Normalize the pixel values. Label the images based on their filenames. Shuffle and split the data for training, validation, and testing.  SCRIPT for creating the MNIST Dataset: import cv2 import numpy as np import os import random # Path to the shapes dir...
Read more

Teaching Computers to Play Tic Tac Toe: A Reinforcement Learning Approach

Image
Teaching Computers to Play Tic Tac Toe: A Reinforcement Learning Approach by Naomi A.  You can see the full code on GitHub: https://github.com/SQLNoggin/Smart-TicTacToe-RL_NaomiA.git This Python script implements a reinforcement learning agent to play the game of Tic Tac Toe. The agent is trained through Q-learning, a type of model-free reinforcement learning that uses a Q-table to estimate the value of taking specific actions in particular states. Let's break down the key aspects:   Overview The script uses the Tkinter library to create a graphical user interface (GUI) where the Tic Tac Toe game can be played. NumPy is used for numerical operations, and the pickle library is used to save and load the Q-table to/from a file. Constant and Hyperparameter Definitions PLAYER_X and PLAYER_O : Constants representing the two players (1 for X and -1 for O). EMPTY : Constant representing an empty cell on the Tic Tac Toe board. ALPHA : The learning rate used in the Q-learning updates. G...
Read more