create template sql server reports
I rerun the same reports each month, but use a different date. Can I set up templates for these reports so that I don't have to keep keying in the same information/parameters each time I run the reports?
Report Builder 15 resets connection to OLAP data source
I'm using the latest version of Report Builder (15.0.20073.0) and connecting to an OLAP over HTTP data source. On particular machines, Report Builder resets the network connection after authenticating to the SSAS service with the error below. I am able…
Is support for SQL data queries in Excel being phased out?
I was told today by my IT department that I'll have to stop using Excel with SQL data queries to pull data directly into Excel from a SQL server. They stated that Microsoft was phasing out this feature. I couldn't find anything searching the Microsoft…
SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
Report Viewer (.rdlc) print dialog box save to pdf option download file with different name in Firefox.
Hi Team, using ASP.Net web application report viewer page,Report Viewer (.rdlc) print dialog box save to pdf option download file with different name in Firefox. Thanks, Shaik Masthan Babu.
SSRS 2016 Data Driven Subscription is generating one email for each row in report
I have a SSRS 2016 data driven subscription. When there is no data, no email goes out, but when there is data, it sends a duplicate email for the number of rows in the report. Is there an easy way to limit it to one email per time it is run if there…
Report Viewer Issue(.rdlc) print dialog box done button getting asp.net session timeout issue in firefox
Hi Team, using ASP.Net web application report viewer page,Report Viewer (.rdlc) print dialog box done button before preview window then getting asp.net session timeout issue in firefox brower. Kindly Suggest regarding this issue. Thanks, Shaik Babu
Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
Please help me solve this error. Cant install SQL Server 2022: Unable to install SQL Server 2022 (setup.exe). Exit code (Decimal): -2147467259.The system cannot find the path specified.
tablix header row on each page not working
I have set properties of static members in row group like this FixedData: True KeepWithGroup: After RepeatOnNewPage: True But header rows on each page not showing there are four columns in data rows. and also there is a tablix in each data…
Can't display the list of the table through ODBC from Report Builder
Can you please help or confirm with the information below as earliest We are trying to connect TIBCO Data Virtualization from Report builder through ODBC connection and it allows to connect this data source through query designer in free form text which…
should i prefer join over exists or in
hi, I have seen people use exists when exists is required and no cols are required in select. But I notice sometimes exists slows down and join performs better q1) is there any news i should know , that one should not use exists or in , and should go…
open report in popup window with parameter
I have set the action to: ="javascript:void(window.open(' http://prodsql02/reports/report/%D7%93%D7%95%D7%97%D7%95%D7%AA/%D7%A4%D7%A2%D7%99%D7%9C%D7%95%D7%AA/subreports/1_field_popup ¶m1=" & Fields!conclusions.value & "…
Log off Log on to SQL Server Reporting Services
I think I used the wrong login and now it tells me that it is NT AUTHORITY\ANONYMOUS LOGON and I can't get out of this to log in again. Closing the browser and reopening it didn't help.
SSRS parameter default based on another parameter
I have a report where the title was set based on 2 of my parameters. I would now like to set that title as a default and allow the user to overtype it. So, parameter 1 is an ID of an Account, Site or Retailer. Parameter 2 is a pick list of Account,…
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
Afternoon Everyone, I am getting The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported) when trying to access the Configuration Manager SQL Report Servers . The issue first started…
SSRS on Azure SQL Server 2019 VM's
Hi, I am deploying SQL Server 2019 VM's. SQL Server comes preinstalled as part of the VM creation process. SSRS does not come preinstalled. The SSRS installer requires a product key for Standard or Enterprise licensing. For SQL Server VM's, where can…
Error occurred during local report processing
Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…
How to fix this error?
Hi Guys, How to fix the error message in the image below?
Microsoft.ReportViewer.ProcessingObjectModel failed to load
Nuget Microsoft.ReportingServices.ReportViewerControl.WebForms Version: 150.1484.0 Web config <assemblies> <!-- All assemblies updated to version 15.0.0.0. --> <add…
Overload resolution failed because no accessible 'Join' can be called with these arguments
I have a dataset in ssrs in which one of the parameter has expression as =IIF(Parameters!EquipmentTypeID.Value(0)=-1,NOTHING,JOIN(CInt(Split(Parameters!EquipmentTypeID.Value," ").GetValue(0)),",")) I have a dataset in ssrs in…