Saturday, July 1, 2023

SSRS - How to create a report with "Enter Data" connection type

 1) Objective: The objective of this article is to provide a way of developing report without connnecting any data source like SQL Server, Oracle, Excel etc. Ideally this type of data source is used to show some master data or configurable data in some section of the report. Here we are showing creation of simple report with Enter data provider.

2)  Create Data Source: Create data source with connection type as "Enter Data" 

3) Create DataSet: Create new dataset and select the data source "DataSource1" created in previous step. Click on Query data. It will open the grid for data entry. 

4) Enter data into the grid and click ok

5) It will show entered data in the XML format. Click ok

6) Report Creation: Now Create a sample report with Report Builder or Visual Studio

No comments:

Post a Comment