196
214 517

SSRS Report with like parameter | Part 5

10:12

SSRS Report with parameter using shared data source and shared datasets | Part 4

20:30

SSRS Report with Shared data source and Shared datasets | Part 3

14:00

What is SSRS(SQL Server Reporting Services) | Part 2

4:38

Installation of SQL Server Reporting Service (SSRS) | Part 1

10:25

Constants in Excel VBA | Part 7

4:12

SSRS Report with SQL Procedure | Part 6

SSRS Report with SQL Procedure:
Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015.
Steps:
1. Add a Shared Data Source and established the connection to SQL server using the credential with database name.
2. Create a Dataset: We define the SQL queries, and if any parameters are required, we write the SQL query with parameters.
3. Create a Report and Design the Report: Drag the dataset fields (e.g., empid, emp_name and etc.) from the Report Data pane to the report design surface and Format the report as needed (e.g., tables, matrices, charts, etc.).
SQL Procedure in SSRS:
Procedure name: sp_emp_detail

มุมมอง: 42

วีดีโอ

SSRS Report with like parameter | Part 5

10:12

SSRS Report with like parameter | Part 5

มุมมอง 46วันที่ผ่านมา

SSRS Report with like parameter: Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015. Steps: 1. Add a Shared Data Source and established the connection to SQL server using the credential with database name. 2. Create a Dataset: We define the SQL queries, and if any parameters are required, we write the SQL query with parameters. 3. Design the Report: Drag the datas...

SSRS Report with parameter using shared data source and shared datasets | Part 4

20:30

SSRS Report with parameter using shared data source and shared datasets | Part 4

มุมมอง 94วันที่ผ่านมา

SSRS Report with parameter using shared data source and shared datasets: Requirments: SQL SERVER 2012, SSDT tool installed for SSRS and visual studio 2015. In SQL Server Reporting Services (SSRS), shared data sources and shared datasets are used to manage data and queries for reports. Steps: 1. Create a New Report though SSDT or visual studio under business intelligence. 2. Add a Shared Data So...

SSRS Report with Shared data source and Shared datasets | Part 3

14:00

SSRS Report with Shared data source and Shared datasets | Part 3

มุมมอง 6714 วันที่ผ่านมา

SSRS Report with shared data source and shared datasets: Requirements: SQL SERVER 2012 AND SSDT tool for SSRS. In SQL Server Reporting Services (SSRS), shared data sources and shared datasets are used to manage data and queries for reports. Shared data source: A set of connection properties that can be used by multiple reports, models, and subscriptions. Shared data sources are optional for rep...

What is SSRS(SQL Server Reporting Services) | Part 2

4:38

What is SSRS(SQL Server Reporting Services) | Part 2

มุมมอง 3914 วันที่ผ่านมา

What is SSRS: SSRS stands for SQL Server Reporting Services, which is a server-based reporting platform from Microsoft. It's part of the Microsoft SQL Server suite of tools and is primarily used to design, deploy, and manage reports in a business environment. SSRS enables users to create a wide variety of reports, including tabular, graphical, and interactive reports, which can be accessed via ...

Installation of SQL Server Reporting Service (SSRS) | Part 1

10:25

Installation of SQL Server Reporting Service (SSRS) | Part 1

มุมมอง 9921 วันที่ผ่านมา

To install this, we need to Install SQL Server Data Tools (SSDT) for Visual Studio. If you need to download the SQL Server Data Tools for Visual Studio 2015, the following link will be useful. www.sqlshack.com/sql-server-data-tools-for-visual-studio-2015/ learn.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-ver15#ssdt-for-visual-studio-v...

4:12

Constants in Excel VBA | Part 7

มุมมอง 5221 วันที่ผ่านมา

Constants in Excel VBA: Requirement: Microsoft Excel 2019 Constants are the fixed value that cannot be changed during the execution of the program. Syntax: Const ConstantName As DataType = Value Example: Const PI As Double = 3.14159 Types of Constants: Numeric Constants: Direct numerical values (e.g., 10, 3.14). String Constants: Text values enclosed in quotes (e.g., "Hello"). Boolean Constants...

4:53

Variable in Excel VBA | Part 6

มุมมอง 4428 วันที่ผ่านมา

Variable in Excel VBA: Requirement: Microsoft Excel 2019 In VBA (Visual Basic for Applications) for Excel, variables are used to store data that can be manipulated during program execution. Here's a quick overview of how to declare and use variables in VBA: Declaring Variables: You can declare variables using the Dim statement. You can specify the type of variable (e.g., Integer, String, Double...

7:10

Input Box in Excel VBA | Part 5

มุมมอง 7728 วันที่ผ่านมา

Input Box in Excel VBA: Requirement: Microsoft Excel 2019 The InputBox function prompts the users to enter values. After entering the values, if the user clicks the OK button or presses ENTER on the keyboard, the InputBox function will return the text in the text box. If the user clicks the Cancel button, the function will return an empty string (""). Syntax: InputBox(prompt[,title][,default][,...

13:12

Message Box in Excel VBA | Part 4

มุมมอง 96หลายเดือนก่อน

Message Box in Excel VBA: Requirement: Microsoft Excel 2019 The VBA MsgBox function is used to display messages to the user in the form of a message box. Syntax: MsgBox( prompt [, buttons ] [, title ] [, helpfile, context ] ) prompt - This is a required argument. It displays the message that you see in the MsgBox. In our example, the text “Welcome to VBA Message Box” is the ‘prompt’. You can us...

10:53

Procedure in Excel VBA | Part 3

มุมมอง 131หลายเดือนก่อน

Procedure in Excel VBA: Requirement: Microsoft Excel 2019 In Excel VBA, a procedure is a block of code that performs a specific task. Procedures help organize code into manageable sections and can be called from other parts of your program or triggered by events (like opening a workbook or clicking a button). There are two main types of procedures: 1. Sub Procedures: These are defined with the ...

15:41

Macros in Excel | Part 2

มุมมอง 191หลายเดือนก่อน

Macros in Excel: Requirement: Microsoft Excel 2019 In Excel, a macro is a sequence of instructions that automate the tasks. Macros are written in VBA (Visual Basic for Applications) and can be used to perform repetitive tasks, manipulate data, or create complex calculations without manual input. You can always run a macro by clicking the Macros command on the Developer tab on the ribbon. What a...

4:40

What is Excel VBA | Part 1

มุมมอง 119หลายเดือนก่อน

Excel VBA: Requirement: Microsoft Excel VBA (Visual Basic for Applications), is a programming language developed by Microsoft. It's primarily used for automating tasks in Microsoft Office applications like Excel, Word, Access, and Outlook. Some common uses for VBA: Automation: VBA can automate repetitive tasks, such as data entry, formatting documents, or generating reports. Customization: User...

Consume WCF Rest Web Service of Post method in C# using Console | Part 12

10:34

Consume WCF Rest Web Service of Post method in C# using Console | Part 12

มุมมอง 1372 หลายเดือนก่อน

static void Main(string[] args) { // Your XML object string xmlData = @""; // URL of the WCF REST service string url = "localhost:58153/EmployeeService.svc/getempbyid"; // Create a new HttpClient instance using (var client = new HttpClient()) { // Set the content type to XML var content = new StringContent(xmlData, Encoding.UTF8, "application/xml"); // Send the POST request and get the response...

Consume WCF Rest Web Service of Get method in C# using Console | Part 11

11:53

Consume WCF Rest Web Service of Get method in C# using Console | Part 11

มุมมอง 1192 หลายเดือนก่อน

Consume WCF Rest Web Service of Get method in C# using Console: static void Main(string[] args) { // Example URL for the WCF RESTful service string url = "localhost:63530/EmployeeService.svc/getemp"; // Create a new HttpClient instance using (HttpClient client = new HttpClient()) { // Send a synchronous GET request HttpResponseMessage response = client.GetAsync(url).Result; // Ensure we get a s...

Pass the Parameters different way in Restful WCF web service in ASP.NET C# | Part 10

24:19

Pass the Parameters different way in Restful WCF web service in ASP.NET C# | Part 10

มุมมอง 1322 หลายเดือนก่อน

Pass the Parameters different way in Restful WCF web service in ASP.NET C# | Part 10

Create a Restful WCF Web Service with POST method using ASP.NET C# | Part 8

30:53

Create a Restful WCF Web Service with POST method using ASP.NET C# | Part 8

มุมมอง 1562 หลายเดือนก่อน

Create a Restful WCF Web Service with POST method using ASP.NET C# | Part 8

Create a RESTful WCF Web Service using ASP.NET C#

38:24

Create a RESTful WCF Web Service using ASP.NET C#

มุมมอง 1702 หลายเดือนก่อน

Create a RESTful WCF Web Service using ASP.NET C#

Convert Web service/ Web API XML string into data table in C# | Part 6

14:33

Convert Web service/ Web API XML string into data table in C# | Part 6

มุมมอง 812 หลายเดือนก่อน

Convert Web service/ Web API XML string into data table in C# | Part 6

7:34

Convert data set to XML | Part 5

มุมมอง 1173 หลายเดือนก่อน

Convert data set to XML | Part 5

Add the attribute in XML which are created from Database using C# | Part 4

12:42

Add the attribute in XML which are created from Database using C# | Part 4

มุมมอง 1313 หลายเดือนก่อน

Add the attribute in XML which are created from Database using C# | Part 4

Create an XML from Database using C sharp | Part 3

16:28

Create an XML from Database using C sharp | Part 3

มุมมอง 1193 หลายเดือนก่อน

Create an XML from Database using C sharp | Part 3

21:02

Create an XML in C# | Part 2

มุมมอง 1153 หลายเดือนก่อน

Create an XML in C# | Part 2

13:33

What is XML | Part 1

มุมมอง 823 หลายเดือนก่อน

What is XML | Part 1

Delete a Node at a specific position in Linked List in C program | Part 31

19:23

Delete a Node at a specific position in Linked List in C program | Part 31

มุมมอง 193 หลายเดือนก่อน

Delete a Node at a specific position in Linked List in C program | Part 31

Delete a Node from beginning in Linked List in C program | Part 30

10:44

Delete a Node from beginning in Linked List in C program | Part 30

มุมมอง 254 หลายเดือนก่อน

Delete a Node from beginning in Linked List in C program | Part 30

Insert a New Node after a specified position in Linked List in C program | Part 29

15:51

Insert a New Node after a specified position in Linked List in C program | Part 29

มุมมอง 544 หลายเดือนก่อน

Insert a New Node after a specified position in Linked List in C program | Part 29

Insert a Node at End in Linked List in C | Part 28

20:21

Insert a Node at End in Linked List in C | Part 28

มุมมอง 526 หลายเดือนก่อน

Insert a Node at End in Linked List in C | Part 28

Insert a Node at Beginning in Linked List List in C program

17:14

Insert a Node at Beginning in Linked List List in C program

มุมมอง 496 หลายเดือนก่อน

Insert a Node at Beginning in Linked List List in C program

Implementation of a Singly Linked List in C | Part 27

13:48

Implementation of a Singly Linked List in C | Part 27

มุมมอง 656 หลายเดือนก่อน

Implementation of a Singly Linked List in C | Part 27

Syed Ali