how to create a sample/test SSRS report

There are 2 sections here for SSRS report.

  1. Configuring SSRS report
  2. Deploying the SSRS file to report server URL for scheduling report

Section 1: Configuring SSRS report

Step1: open Visual studio from All Program

or

At Run prompt – type devenv and enter.

visual_studio_shortcut_Capture

Step2: Click CREATE project as shown

visual_studio_CREATE_PROJECT

Step 3: Select Report server project wizard & enter your own project name as shown.

create_SSRS_wizard

SSRS_REPORT_WIZARD

Step 5: create a data source.

create_data_Source

  • Step 5.1) click Edit.. to add server details etc
  • Step 5.2) click credentials.. to add login details etc

edit-credentials

edit-credentials_1

Click Next..

Step 6) Paste the data fetching query here as shown and press Next >

paste_query

select_report_type

design_table

deployment_location

formating_report

Check the report format & spacing for your requirements as per above picture.

report_preview

Section 2: Deploying SSRS reports:

Open internet browser with admin permission as shown.

open_IE_as_admin

 Step 3: save the SSRS config as a .rdl file as shown.

SSRS_RDL_file_config_in_SSRS_URL

SSRS_RDL_file_config_in_SSRS_URL_1

 Step 5: you can also open any existing folder & upload the .rdl as shown.

upload the rdl file

upload the rdl file_1

Once the .rdl file is uploaded, click the drop down button & click Manage option as shown

parameters_update_SSRS

parameters_update_SSRS_1

Schedule the report in subscription section as shown.

report_subscription

 

 

 

 

 

 

 

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s