SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
20
votes
1answer
427 views
Reporting Service and Application Role
First poster, long time lurker here.
What is the best way to activate application role in a report ?
I've tried different things and so far the only method that works is to embed the call to the ...
7
votes
1answer
371 views
alert when any job in a job category fails
Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails?
I am wondering because I would like to set up an e-mail anytime an SSRS ...
7
votes
3answers
121 views
Prevent Data Sources from being deployed outside designated folder
Before I just go ahead and put a really awful check constraint on the Catalog table, I wanted to solicit some better ideas first.
I want to ensure that all shared data sources on our report server ...
6
votes
3answers
271 views
Things to consider with a bigger table
I have a table that has around 12 billion rows (row size 32 B) which grows each month by 300 million rows. I have setup partitions for each month and each month has 8 data files (since I currently ...
6
votes
3answers
197 views
Find material for improvement in Microsoft BI
Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS?
Please remember that I'm a newbie in technical BI tool.
If ...
5
votes
2answers
263 views
Options for setting NOLOCK hint in dataset queries
Some context:
At first we wrote reports just "straight up", without any locking hints in the queries. With the larger reports this would sometimes cause locking problems. At first we remedied this by ...
5
votes
1answer
958 views
Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?
I'm changing the recovery model of ReportServer database from FULL to SIMPLE.
Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am ...
5
votes
1answer
456 views
SSRS Merge Data Across 2 Group Values
I have created a report for SSRS 2008 which produces the results below.
What I am looking to achieve is for those results in pink, AD, to be under both AM and PM with the text centered i.e. merged ...
4
votes
1answer
2k views
How can I tell which data sources are being used in SSRS?
We have a bunch of SSRS (2008) reports deployed to our web portal. We have edited some of the reports to use a shared data source different than the one with which it was originally deployed.
I am ...
4
votes
2answers
170 views
How to create a summary report that contains other reports?
I have 4 reports that I run for 8 different environments. Each report creates a graph from some usage tables. It's very simple SQL that creates a very simple graph.
The guy who used to do these ...
4
votes
1answer
115 views
Slow SSRS Report in production
I have an SSRS report which gets its data by firing a series of stored procedures.
Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
4
votes
1answer
146 views
SSRS appears to be ignoring Permissions set using Report Manager
I have setup SSRS on SQL Server 2008 in native mode.
As an administrator I can login to report manager, upload reports and run them, and also use the Web Service URL to generate reports.
I have also ...
3
votes
1answer
323 views
can I create an SSRS group without adding the group to the box itself and without using Active Directory?
I want to know if it is possible to create a group "internal" to SSRS without having to add the group to the ReportServer box itself.
I do not have permissions to the box to create groups and/or add ...
3
votes
2answers
246 views
Report model data source
Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank ...
3
votes
2answers
246 views
Can I programmatically generate reports that are emailed as Excel docs from SSRS?
I've searched already and don't see (or can't decipher) a solution for my issue. I have SSRS emailing a report for 1 district (with 12 retail stores). However, each Region has over 8 Districts, and I ...
3
votes
2answers
154 views
SSRS Report joining data sets in BID 2008
How can we join to Data sets in SSRS? For example we have Dataset1 and Dataset2 and the common columns between them are c1 and c2. I know we can use lookup, but wondering if there is a shortcut like ...
3
votes
2answers
133 views
can I convert an integer to base-2 without a function
Here's a bit of a challenge. I am working with the table ReportServer.Schedule and there is a column called DaysOfWeek. I may not be using the proper terminology here, but this is an integer from ...
3
votes
1answer
162 views
why do SSRS reports run longer for a particular user
We have been receiving complaints from a particular SSRS user that her reports run slow. I investigated in the ExecutionLog table in the ReportServer database and I observed something strange.
...
3
votes
1answer
192 views
What load does SQL Server Reporting Services (SSRS) have on the server?
Does SQL Server Reporting Services use a lot of server resources?
Is it okay to install SSRS on the same server as the SQL Server instance? What should I take into consideration?
Is the SQL Server ...
3
votes
3answers
2k views
Problem Connecting Report Server to Report Server Database in SSRS
I have configured Reporting Services on one Server and have the ReportServerDb & ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers ...
3
votes
2answers
185 views
Updating data from a report: any potential pitfalls?
Question:
In general, are there any pitfalls with updating data from a SSRS report?*
Context:
More specific, I'm talking about this context:
SSRS 2008 (with the option to upgrade, if needed).
...
3
votes
1answer
1k views
How to deploy SSRS reports build through Report Builder?
I would be building or correcting the already build SSRS reports through report builder. Once the change is done in Development side, then how to publish the reports on test server/UAT or on ...
3
votes
2answers
297 views
can I add a custom SSRS e-mail subscription that forces the “TO” address
I would like to know if it is possible to add a custom delivery extension(?) in SSRS that will enable me to force a value into the "TO" address for particular subscriptions?
Big picture: I am ...
3
votes
1answer
811 views
SSRS email subscription with custom file name on the attachment
I would like to set up an SSRS email subscription that attaches the report in PDF format to the email with a custom file name that changes daily. I was hopeful that I could to this via a data-driven ...
3
votes
1answer
536 views
Sum values at a group level rather than detail
I have an invoice report I'm developing for some project billing. The main tablix has several groups, in this order:
ProjectGroup
TicketGroup
NoteGroup
Details (actual billing details)
The data ...
3
votes
0answers
21 views
SSRS Reports on WUXGA Displays
We use WUXGA displays (1920 x 1200), and have lots of SSRS reports. Since these reports need to be printed once in a while the layout is adjusted to A4. However when the users look at the reports on ...
3
votes
0answers
41 views
How to configure SSRS (SQL Server 2012) to run on a different instance, but same server as SharePoint
I have an instance of SQL Server 2012 running on Windows 2008R2 along side another instance of SQL Server 2012 that is running SharePoint (I think it is SharePoint 2010).
When I try to access the ...
3
votes
0answers
114 views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
2
votes
2answers
197 views
SSRS Report dependencies
Is there an automatic way to track reports and their dependencies for SSRS? What I want is a map/tree where I can see whether a report depends on a other report or subreport.
So far we did this by ...
2
votes
1answer
476 views
async_network_io issues with BIDS
This is related to my previous question drastically different runtimes in BIDS and the SSRS Web Portal.
I am struggling with refreshing some reports in BIDS because they run forever. I have now ...
2
votes
1answer
336 views
How should I deploy these SSRS reports?
I need to make a decision about deployment and security of some SSRS reports and would like some advice on what the most appropriate method is.
We have 40+ sites that have access to information for ...
2
votes
2answers
742 views
Date format in SSRS
I'm wondering if there is a setting in SSRS to indicate the date format. We need to show the dates in dd/mm/yyyy format on the reports and from what I can see in database the value has been stored ...
2
votes
1answer
30 views
How to set the language of a doc to a DB field
Is there a way to set the language of a document body to a value fetch from the DB in SSRS? I tried with a simple expression and I got this error. I wonder what the best workaround is
2
votes
1answer
273 views
encryption of SSRS subscription emails and attachments
Is it possible to set up an SSRS e-mail subscription, with an attachment, that is encrypted?
POST ANSWER-ACCEPT UPDATE: Does the SMTPUseSSL switch in the RSReportServer.config file help me at all?
...
2
votes
2answers
125 views
SSRS schedule failure intimation
I am scheduling a report using SQL Server Reporting Services Subscription option.
Suppose my rdl file is corrupted or my stored procedure has got some problem.
Then the report won’t generate in its ...
2
votes
1answer
463 views
How to apply filter at runtime in SSRS 2008 R2
In my report in SSRS 2008 I have created a expression for the CasesShipped column like this:
=IIF(Fields!Current_Product.Value= "Match"," ",Sum(Fields!Cases_Shipped.Value))
It sums the ...
2
votes
1answer
254 views
SSRS max upload size limitations
We are working on a WiX project for deploying our large application (the server side of the application, that is.) The customer has the choice to have the application server, the SQL Server and the ...
2
votes
1answer
420 views
Real Time SQL Server Analysis Services Cube Processing Report
I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting Services? I would like to be able to run ...
2
votes
1answer
912 views
How to do Row Level Security in SSRS 2008 R2 (or 2012) with Active Directory Groups?
I would like to create a single report that filters data based on what Active Directory group the user is in.
Through various searches I see that Row Level Security is possible in SSRS in the Report
...
2
votes
1answer
104 views
Allow a user to create folders and linked reports, but not “real” reports
I have a need to allow certain users the ability to create folders and linked reports within specified folders, but I don't want them to be able to put actual reports in those folders. Is there a ...
2
votes
2answers
112 views
Issue With SSRS Emailing Reports As PDFs
I have a strange issue that I'm unable to find the answer to online or by looking at it myself.
Basically when I set up an email subscription for a report I've created in SSRS Report Builder (2008); ...
2
votes
0answers
197 views
SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
I wrote a report that is executed by a few hundred users each day and the underlying stored procedure for the data set only takes milliseconds to execute. According to the ...
2
votes
1answer
270 views
An unknown error occurred while processing the request on the server [closed]
I have an asp.net 4.0 application with a button that opens a SSRS report. This works fine on my development machine and I can open the report directly with report manager but when I try to access the ...
2
votes
0answers
45 views
How to force SSRS to sync subscriptions and schedules with SQL sever agent jobs
How to force SSRS to sync subscriptions and schedules with SQL sever agent jobs... appears after applying CU6 we lost some security and jobs related to SSRS. Currently security has been corrected and ...
2
votes
3answers
622 views
SQL Reporting Services - T2Embed.dll missing
When generating a report in SSRS, I receive the following error:
There was an error generating your report. Please refer to item 673778174106859 for additional diagnostic information. There was an ...
1
vote
2answers
790 views
Connect a linked server to MS Reporting Service?
I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server?
How do I connect it to Reporting Services?
1
vote
1answer
43 views
How to create column
I am new to ssrs report designing can any one help me in this
I have two question
1) How to create a column to input user data and after that I need to perform some operations on data enter by ...
1
vote
2answers
336 views
Creating a form using SSRS
We have some application forms in our system and want to define them as Reports using SSRS 2008 R2. So when users see the form on the screen and what to print it as a report in a print friendly ...
1
vote
1answer
322 views
uninstalling SSRS and SSIS from clustered SQL Server 2008 R2 SP1
Due to the security recommendation, i will need to uninstall the unused SSRS and SSIS component from a production cluster SQL Server 2008 R2 SP1, so what is the caveats and what do I require to do to ...
1
vote
1answer
387 views
Verification that my SSRS subscription was emailed to a valid address
I would like to know if it is possible to verify that an SSRS subscription that was set up to send an email sent it to a real address. That is, if I put in an email address that is not valid, can I ...
