Prateek Jain

What is shared data set in SSRS?

Data set are the specific way to create the query and support the report on run time execution with data. There can be a scenario where we wanted to use the same data set for multiple reports. As an example, let’s say I have a set of 10 reports where I am showing the data based on year on year growth in different…

SQL Server

Answered Nov 13, 2019 · 1.5K Views Read answer →

What is the best way to showcase the KPIs in SSRS?

KPIs are Key performance indicators. In SSRS, we can show case KPIs via Gauges or Indicators. Gauge helps us to show the relative data and Indicators can show case the data with icons. We can also include the Indicators inside the Gauge panel. If you check out below link from Microsoft documents, you will be able to…

SQL Server

Answered Nov 12, 2019 · 1.7K Views Read answer →

How to check the logs in report server database?

Logs in the database can be checked by either tables or pre-defined views. If any developer who has proper level of knowledge about the reporting server db then it’s easier to check the logs via table. However, there is another easy to use the logs. Reporting server Logs are primary execution logs. Reporting server…

SQL Server

Answered Nov 9, 2019 · 1.8K Views Read answer →

How many types of reports can be created in SSRS?

In SSRS, we have multiple tools available to create and support the reporting requirements. Please find below screenshot. We can create reports like tabular, matrix, chart, gauge etc. Also, we can customize the report based on multiple other items like rectangle, list, images, sub report, drill through and drill down…

SQL Server

Answered Nov 6, 2019 · 1.6K Views Read answer →

Exporting to excel is merging columns for SSRS Report

This issue usually occurs when alignment and dimensions of column for a particular cell is not properly defined. There can be two scenarios: Dimensions Issues: column and rows of a particular cell should be defined with whole number. In SSRS, click on a cell and go to properties and set width and length to whole…

SQL Server

Answered Nov 6, 2019 · 4.0K Views Read answer →

How to configure the email settings in reporting services configuration manager.

SSRS configuration manager allows you to configure the email settings. IF you want to send out an email via subscriptions, then you can setup the email port and server via configuration manager. SSRS uses a SMTP (simple mail transfer protocol) to send out the emails. Via email, you can deliver the reports or report…

SQL Server

Answered Nov 5, 2019 · 12.5K Views Read answer →

What is prerequisite to install the SSRS?

There are certain prerequisites to install the SSRS: You should install the Microsoft .net framework 4.6.1 in order to install the SSRS 2017 edition. SQL SERVER should be already installed on the same machine or another machine. A user/Service account with proper access (administrator preferably) to the machine where…

SQL Server

Answered Nov 5, 2019 · 1.6K Views Read answer →

What is reporting service configuration manager?

If reporting services has been installed, then we should configure it via reporting services configuration manager. It can be used to configure the local or remote reporting service instance. We should always define a service account in order to start the services. Faceless ID should be with password not expire mode.…

SQL Server

Answered Nov 4, 2019 · 1.8K Views Read answer →

Exporting report to PDF will results into blank pages

This issue also part of wrong alignment and dimensions of report. Try to identify the proper sizing of exported output, if you want to pull the report on A4 sheet, try to setup the report page less than A4 size. Also make sure that layout of report is correctly set for portrait or landscape.

SQL Server

Answered Nov 1, 2019 · 1.6K Views Read answer →