SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

learn more… | top users | synonyms

3
votes
2answers
545 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 ...
1
vote
1answer
83 views

how to config SSRS 2005 email setting with google apps

My Company recently switches email service to google apps (asp.google.com). all the current subscriptions in SSRS2005 are configured to MS exchange server and no longer workable. Do someone knows how ...
3
votes
1answer
2k 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
296 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
2answers
369 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 ...
2
votes
1answer
2k 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 ...
9
votes
1answer
805 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 ...
2
votes
1answer
629 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? ...
1
vote
1answer
1k 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 ...
-4
votes
2answers
664 views

Performance Improvement in SSRS' Reports [closed]

There are reports build in SSRS 2008 by some user. I need to improve the performance of the already-build reports. The reports fetches a lot of data and run very very slow. I googled and found ...
0
votes
1answer
384 views

Stored Procedure is not returning complete result

I am using the query as mentioned in the answer accepted in the question located at Stored Procedure doesn't show result in SQL Server Now when I run this SP with the values provided in the ...
0
votes
1answer
119 views

how to pull data source information on data-driven subscriptions

I would like to know more about the data-driven subscriptions on our ReportServer. I am specifically looking for what shared data sources are being used, but the connection string would also suffice. ...
1
vote
1answer
445 views

Microsoft SQL Server 2008 R2 Subscriptions

I have an installation of SQL Server 2008 R2. In the subscriptions section I do not see an icon or button to create data driven subscriptions; in the previous installation of SQL Server 2008, I do ...
2
votes
1answer
197 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 ...
4
votes
1answer
1k 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 ...
1
vote
0answers
189 views

Sort a non-grouped (SUM) column in descending order [closed]

I have a SSRS Report that contains 3 columns: Asset, Project Type and Total Hours. Report is grouped by first level grouping on asset and second level on Project Type. For example, clicking on Asset ...
2
votes
1answer
978 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 ...
1
vote
1answer
803 views

Can't connect to Analysis Services or Reporting Services on localhost

I'm able to connect to my SQL Server 2008R2 localhost Database Engine and Integration Services. However, when I try to connect to Analysis Services, it fails with the message: "A connection attempt ...
7
votes
3answers
217 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 ...
1
vote
1answer
218 views

drastically different runtimes in BIDS and the SSRS Web Portal

I have a report in a BIDS project that has been deployed to our SSRS Web Portal. On the web, it renders within seconds. In BIDS, it takes upwards of seven minutes. I can see that the query runs ...
5
votes
1answer
1k 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 ...
0
votes
1answer
112 views

Chart creation in BIDS 2008

Due to low reputation point i am not able to include the picture. I am trying to make u guys understand what i am asking for: I had created a report. And that Report contains these fields and ...
1
vote
1answer
407 views

data driven subscriptions in SSRS - pulling a password value from the database

If I create a data driven subscription in SSRS and use the query to return some value for the username and password, how "safe" is this password? Let me explain. I am looking to set up a data source ...
1
vote
0answers
464 views

Keep original column names in SSRS report designer 3.0?

I have queries returns a lot of (over a hundred) columns which names contain important underscores, >, < and Uppercase/lowercase characters. However, when creating the reports, SSRS designer (3.0) ...
2
votes
1answer
205 views

Views - Indexes/Keys/Execution Plans

I am working with a SQL 2005 database server that contains multiple databases and tables that are replicated from various sources. No one but administrators have access to this server. There is a ...
1
vote
1answer
536 views

Send SSRS Report Many Times Based on Sql Query

I have a user who is requesting that a legacy report (email subscription) that runs with multiple categories be modified to run based on which categories exist in the given date range. Thus instead of ...
1
vote
1answer
48 views

Copy scheduling information form local system to remote system SSRS

I am scheduling some reports locally in my system. How can I copy this schedule information to remote system to avoid re-doing of scheduling at remote system?
2
votes
2answers
189 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
3answers
973 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 ...
3
votes
1answer
260 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 ...
4
votes
1answer
2k 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 ...
2
votes
1answer
764 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 ...
5
votes
1answer
6k 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 ...
6
votes
3answers
298 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 ...
20
votes
1answer
510 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 ...
0
votes
1answer
246 views

Using SSAS for retrieval data instead of using SSRS to make a report?

If you work with Reporting service in order to create a report and you need to retrieve data from the relational database. The datamodel of the relational database can be structured in a certain way ...
6
votes
3answers
232 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 ...
3
votes
2answers
279 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 ...
5
votes
1answer
2k 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 ...
1
vote
2answers
1k 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?
3
votes
3answers
4k 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 ...