SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions
0 answers
SQL Server Report builder 3.0 - trying to remove prompts from an existing report
I am trying to edit some existing queries in Report builder 3.0 using query designer and the Filter tool. When I make simple changes like removing a prompt instruction or changing the date range to a relative date these appear to work, but then do not…
asked 2024-04-19T14:29:33.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 52%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Allason, Matt
0
Reputation points
commented 2024-04-23T09:23:39.4933333+00:00
Allason, Matt
0
Reputation points
2 answers
How to check SSRS version by querying database?
Hello, Is there a way to query SSRS version currently installed using TSQL? In sql server 2019 there is a table 'ProductInfoHistory' and it looks like it keeps the history but I have noticed that it is not consistent and I do not see it updated when I…
asked 2024-04-22T18:08:28.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mughees, Muhammad
0
Reputation points
answered 2024-04-23T03:01:46.7133333+00:00
ZoeHui-MSFT
32,581
Reputation points
2 answers
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?
asked 2024-04-22T17:21:15.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 66%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rowland, Donna S
0
Reputation points
edited an answer 2024-04-23T02:52:43.32+00:00
Greg Low
1,475
Reputation points Microsoft Regional Director
1 answer
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…
asked 2024-04-22T16:13:34.3933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 67%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mike Parsons
0
Reputation points
answered 2024-04-23T01:54:00.58+00:00
ZoeHui-MSFT
32,581
Reputation points
3 answers
One of the answers was accepted by the question author.
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…
asked 2024-04-19T19:34:52.87+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Colin Sachs
20
Reputation points
answered 2024-04-22T15:44:42.1933333+00:00
Colin Sachs
20
Reputation points
3 answers
One of the answers was accepted by the question author.
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,…
asked 2024-04-19T19:31:42.4666667+00:00
Colin Sachs
20
Reputation points
answered 2024-04-22T15:44:23.57+00:00
Colin Sachs
20
Reputation points
1 answer
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.
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,248 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,219 questions
asked 2024-04-18T08:23:45.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shaik Babu
0
Reputation points
answered 2024-04-22T05:35:37.4566667+00:00
Shaik Babu
0
Reputation points
5 answers
One of the answers was accepted by the question author.
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 40%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
asked 2024-04-14T11:17:03.4666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
hamada mostafa mohammed othman
0
Reputation points
edited the question 2024-04-19T08:18:40.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 17%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RNareddy
510
Reputation points Microsoft Vendor
1 answer
"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition
Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…
asked 2024-04-12T12:42:24.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 50%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hakan KARATEKE
0
Reputation points
commented 2024-04-19T06:42:17.5733333+00:00
Hakan KARATEKE
0
Reputation points
1 answer
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
asked 2024-04-18T07:14:15.4266667+00:00
Shaik Babu
0
Reputation points
answered 2024-04-19T01:36:53.7+00:00
ZoeHui-MSFT
32,581
Reputation points
1 answer
SSRS 2022 upgrade breaks report
After upgrading my SSRS 2022 instances from 16.0.1113.11 to 16.0.1115.61, my reports that usually displays a few columns coming from a stored procedure does not display the results anymore (only lines with blank data in all differents browser). ->…
asked 2024-04-08T16:08:21.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 87%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Rives, Vincent
1
Reputation point
commented 2024-04-18T19:48:47.3033333+00:00
Rives, Vincent
1
Reputation point
5 answers
SQL Server Reporting Services is spewing logs - This may be due to a connection failure, timeout or low disk condition within the database.
On SQL Server Reporting Services, all of a sudden logs are full of : library!WindowsService_0!16e4!04/16/2024-13:52:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 5%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
1 answer
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.
asked 2024-04-17T03:19:46.4966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JOANNAH MARIE ZARAGOZA
0
Reputation points
answered 2024-04-18T07:22:26.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 32%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Prathamesh Anup Khade
0
Reputation points
3 answers
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 78%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
2 answers
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…
asked 2024-04-16T17:29:33.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 77%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niraj Kesarwani
0
Reputation points
answered 2024-04-18T01:56:28.4066667+00:00
ZoeHui-MSFT
32,581
Reputation points
1 answer
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…
asked 2024-04-16T07:20:37.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-04-18T00:59:52.34+00:00
Greg Low
1,475
Reputation points Microsoft Regional Director
0 answers
why ssms 20.1 Cannot Open ?
Why my ssms 20.1 that was downloaded on 04/14/24, always run the same popup page message as in the attatchment ? if i choose repaired and wait it finishes and then reboot the computer, the same popup message pops again. Even that I have uninstall the…
asked 2024-04-14T12:05:02.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 4%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Angele Tantiana
5
Reputation points
commented 2024-04-18T00:33:56.98+00:00
Greg Low
1,475
Reputation points Microsoft Regional Director
3 answers
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 & "…
asked 2020-09-24T07:05:02.54+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
david berlinger
96
Reputation points
answered 2024-04-17T16:57:22.4766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 3%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Karel Hrubeš
0
Reputation points
3 answers
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.
asked 2021-02-22T15:54:23.413+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 88%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Liviu Zaharia
1
Reputation point
edited an answer 2024-04-17T14:11:23.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
47,806
Reputation points