how to create SSRS report using parameter in visual studio.

Step 1:- Open the visual studio and create a new project.

Step 2:- Click on Project and search for the template REPORT SERVER PROJECT.

Step 3:- After clicking on the next button, you have to give the project and solution name and give the path for your project.

Step 4:- Click on Create and your project is created like this.

Step 5:- goto desktop and search odbc data source

Step 6:- Now go to system DSN then click on Add option and select Microsoft Access test driver (*txt, *CSV)

-à Click on the Finish button, give the data source name (DSCSV), disable the current directory, and select the directory where you put your CSV file.

Step 7:- Now go to visual studio and create a new report. click on report and next click on add after that add a new report.

Step 8:- add name as your requirement and select report and click on ADD.

à Now Your Working Window is Open.

Step 9:- Now Right click on Data Source and Click on Add Data Source.

Step 10:- Now select DDBC in Type.

Step 11:- Now click on Build and click on use user or system data source and select DSCSV.

Now click on use connection string check Dsn = DSCSV and click on  test connection

Now click on OK and change the name to DS_sourcefile and click ok you find it on the left side 

Step 12:- now right click on data set and click on Use a dataset embedded in my report and click on the data source and select ds_sourcefile then select CSV file using the query

Select*from filename.

Now:- your data from the CSV file is loaded into your report.

Let's create your Report using the Parameter.

Step 13:- lets right click on blank space goto insert now select table and drag and drop column values from the left side into the table.

Now use the format for decorating your table after that click on the preview to see your data.

Now create some parameters to select some filter data from the whole table.

Step 14:- Let's create a parameter for filter data by supplier id.

 on-the-Left-hand side you got the parameter folder right click on it and add a parameter

Double click on dataset1 and add a parameter in where clause @supid

Now go into dataset properties and go into the filter and add a parameter

Now result using the parameter 

How to create Database In Microsoft SQL SERVER

 The SQL CREATE DATABASE statement is used to create a new SQL database.

Syntax

The basic syntax of this CREATE DATABASE statement is as follows −

CREATE DATABASE DatabaseName;

Always the database name should be unique within the RDBMS.

Example

If you want to create a new database <testDB>, then the CREATE DATABASE statement would be as shown below −

 CREATE DATABASE testDB ;

Video:- How to create a Database