I have a drill down report which need to be exported to excel. But, when exporting to excel it shows many unwanted blank rows for a particular record due to the drill down option. Is it possible to remove it?
Based on the scenario, the issue may occur if the “WSS_Lists” data source doesn’t support impersonate. When configuring the data source properties, we can check the “ Impersonate the authenticated user after a connection has been made to the data source ” option to allow delegation of credentials only if the data source supports impersonation. For SQL Server databases, this option ...
I am in the process of building my own custom data processing extension and I was wondering if it is possible to build this as a 64 bit application, which can talk to the 64 bit driver and the the custom data process extension to talk and connect to SSRS.
I have a SSRS solution that contains 20 reports all of which utilise a shared data source called "DataWarehouse". This datasource has been configured to use Windows Authentication. These reports have been deployed to a server.
SSRS is in the native mode and I try to connect it with Windows Authentication. I tried starting SSMS as an Administrator, but the result was the same. I would appreciate your supports.
According to your description, you have inserted two Tablix controls in the report and each Tablix displays on separate page. As those two Tablix don’t contain the same number of columns, there will display much space on the right side of the report, right?
The developer tells me he has to use forms authentication to provide access to SSRS, since he wants to prompt the user for credentials only once when the app starts up.