Hi

In SSRS, it has a build-in field called UserID which is the current username. So you can set the visibility expression based on this field.

https://msdn.microsoft.com/en-us/library/dd255235.aspx

Hi

In SSRS, without using parameter to filter the data, all the data will be displayed when exporting into excel. It's not supported to exporting part of data. So you...

Hi

Please check the credential using for your data source. Click on your report on Report Manager->Manage->Data Source.

Check Connect using. Try to use stored credential, and select use as windows...

Hi

If you don't use Action to display the subreport, you can directly insert the subreports in tablix (rendered with main report). If you need the subreport updated with the...

Hi kirtim,

This is the limitation when exporting to Excel. It's not supported to have the column header fixed while scrolling in Excel. Because after exporting to excel, the whole report...

In a data region, you can group data by a single field, or create more complex expressions that identify the data on which to group.

We can apply dynamic field...

If you directly use data field in the chart title, it will only use =First(Fields!Department.Value)

And JOIN() function can only be used on joining values in an array so that it...

We can View Reporting Services Reports on Microsoft Surface Devices and Apple iOS Devices

Please refer to link below:

https://msdn.microsoft.com/en-us/library/jj659023.aspx

In this scenario, if you want to show values for all series when you drill through to another report, you should not pass the series as parameter to run the...

Firstly, refresh the fields in your dataset. In your report, not only deleting the column in tablix, you also need to delete all reference to the data field for the...

For your requirement, you need to do Extranet or Internet Deployment for Reporting Services so that users from different location can access report server via internet. Please refer to a...

This is the limitation for SSRS when exporting reports to Excel, Reporting Services does not support margins on report headers and footers. When exported to Excel, these margin values are...

Query Designer in SSRS doesn't support multiple result set, if multiple result sets are retrieved through a single query, only the first result set is processed, and all other result...

In this scenario, you need to use a matrix instead of table to render you data. You need to delete the row group and add each "person" as column group,...

In SSRS, not all query types are supported by all data sources. For example, Table is supported only by data source types OLE DB and ODBC. So please check your...