Configuration with SQL Server Reporting Services

This article is the step by step guide to configure SQL Server Reporting Service. But first we need to see what are the software requirements: -

(1) First, we need to have a browser (Recommended Internet Explorer).

(2) Second, we need to have a MS SQL Server. Download SQL Server.

(3) Third, we need Report Builder. Download Report Builder directly from here.

This article is the continuation of the previous articles How to create SSRS Report using SQL Server and Report Builder? and How to: Start Reporting Services Configuration Manager

Before configuring to SQL Server Reporting Services you need to start the Reporting Services Configuration Manager (RSCM). Now, we will proceed step by step to understand better.

Step-1: Open browser. Prefer Internet Explorer.

Step-2: Type the URL that you have obtained from the previous blog.

(1) To access Reports: You need to type URL. It may look something like this http://<server name>:<Port Number>/Reports

For eg.- http://lenovo-pc:9090/Reports  OR   http://localhost:9090/Reports

(2) To access Report Server: You need to type URL. It may look something like this http://<server name>:<Port Number>/ReportServer

For eg.- http://lenovo-pc:9090/ReportServer  OR   http://localhost:9090/ReportServer

Note: Read the article How to grant full permissions to a user in SQL Server if you are facing this error: “The permissions granted to user 'Lenovo-PC\Manish' are insufficient for performing this operation. (rsAccessDenied)”

Step-3: Once you click Enter. You will be redirected to http://<server name>:<Port Number>/Reports/Pages/Folder.aspx. The URL changed automatically from http://localhost:9090/Reports to http://lenovo-pc:9090/Reports/Pages/Folder.aspx.

Step-4: On Home Tab, click on Folder Settings.

Step-5: In the Security TAB, click on New Role Assignment.

Step-6: Add roles to the user. For that “Create Group or User Name”. Select the User by checking the checkbox and Click on "OK" button.

Step-7: Once the user is created successfully. It may look something like this "<Domain Name>\<User Name>" for ex- Lenovo-PC\Manish

Step-8: Add New Folder and rename it “Teacher_Report”. Open the folder and Upload your reports here.

Step-9: Click the Report. The report will open in its preview mode. You can save the report in given format (eg. PDF, Word, Excel).

Hope you find the article interesting.

For any query, comment us below.

Previous – How to: Start Reporting Services Configuration Manager

Next – Types of SQL Server Joins #1

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

How to check PC has a precision touchpad?

Precision touchpads are new inventions of Windows. They give you an efficient way of working without a mouse click.

To find out whether your PC or laptop has a precision touchpad, Go to Settings -> Devices -> Touchpad. Look for the message, "Your PC has a precision touchpad." Turn the switch ON to enable touchpad.

If you want to disable touchpad gestures turn the switch off.

Hope you find the article helpful.

For any query, comment us below.

Previous – Touchpad shortcut in Windows 10

Next – How to delete Temporary files from windows?

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »

Touchpad shortcut in Windows 10

Hey, folks this time Windows come up with some new and interesting Touchpad gestures which make you feel really excited. And in this article, I am excited to share those awesome touchpad shortcuts with you. If you haven’t try those then get set ready to make your work efficient without clicking the mouse buttons.

         

(1) Single click: Tap with a single finger to select an item.

(2) Right-click: Tap the touchpad with two fingers.

(3) Drag and Multi-select: Tap the touchpad twice with a single finger and drag to select multiple lines.

(4) Scrolling: Tap the touchpad with two fingers gently and slide horizontally or vertically.

(5) Zoom in or out: Place two fingers gently on the touchpad and pinch in or stretch out.

(6) Drag windows: Double-tap the touchpad and drag the menu bar (top of app window).

(7) Show Task view: Place three fingers on the touchpad and swipe them vertically up.

(8) Show the desktop: Place three fingers on the touchpad and swipe them vertically down.

(9) Switch between open windows: Place three fingers on the touchpad and swipe right or left.

(10) Cortana: Tap the touchpad with three fingers and Cortana will pop-up from lower left corner.

(11) Action Center: Tap the touchpad with four fingers and Action Center will pop-up from lower right corner.

Read How to check PC has a precision touchpad?

Hope you find the article helpful.

For any query, comment us below.

Previous – How to view computer hidden files in Windows 10, 8.1, 8, 7 and XP?

Next – How to delete Temporary files from windows?

Click imagination hunt to read latest blogs.

Posted By - +Manish Kumar Gautam +LIVE VIAR +ASP.NET SOLUTIONS 

Keep learning and sharing...

Read More »