SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
2
votes
0answers
19 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 ...
0
votes
1answer
25 views
How to add rows/columns to the table in runtime in SSRS 2008
Usually we design the table to have x number of rows and y number of columns in a report. But how can we create a report which adds the rows and columns dynamically at run time based on the result of ...
2
votes
0answers
86 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 ...
1
vote
1answer
39 views
SSRS 2008 R2 setup issue
I have installed SSRS 2008 R2 on my desktop and server. When I hit the reports link on my desktop
http://mypc/Reports_mypc/Pages/Folder.aspx
all I get to see is this
I cant create a new folder ...
0
votes
0answers
25 views
Displaying Hexadecimal Characters in Reporting Services Report
How do I properly display hexadecimal characters in an SSRS report?
These characters: http://www.htmlhelp.com/reference/html40/entities/special.html
E.g., “ should display as left double ...
0
votes
0answers
32 views
Calling a MySQL stored procedure with parameters in SSRS reporting through ODBC
In SSRS, when I pass hard-coded values to my stored procedure, it works fine. But it doesn't work when I try to pass the parameters.
Can you please tell me the right syntax for calling MySQL stored ...
1
vote
1answer
20 views
SSRS Deployment
I have developed and deploy my reports on report server in LAN. but I want to deploy my reports on report server which is not in LAN. means I need a setup or package which can run at client end ...
0
votes
1answer
31 views
Image fades on the SSRS report
We have a SSRS report built using Report Builder 3. There is a coloured logo on top of this report which is displayed correctly when see the report on screen, print it or export it to Word. However ...
0
votes
0answers
36 views
SSRS Reports Design Standards and Guidelines Document [closed]
We've just started to create reports for out under developed application using SSRS. To make the layouts, formats, namings, etc consistent across all reports, we should create a Reports design ...
0
votes
0answers
66 views
SSRS email subscription fails intermittently with “The e-mail address of one or more recipients is not valid”
I have an SSRS server sending mail via smtp to a list of users.
These are all internal users with email addresses of the form user.name@example.com
An email subscription run at 18:05 used to work, ...
1
vote
1answer
39 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 ...
0
votes
1answer
51 views
SSRS Bar Chart Issue
I have a Bar Chart that I am trying to limit Sales data to specific Months. I want a SUM of Sales $ for 2012 and a SUM of Sales $ for 2013. The Month Names are formatted like January 2012, January ...
1
vote
0answers
130 views
SSRS Timeline Chart for each day / minute
I'm asked to make a Timeline Bar Chart with SSRS 2012.
There should be 1 chart per day/employee, and this chart should have a x-axis of 1440 minutes (or 24 hours).
The bar should have 2 different ...
2
votes
2answers
198 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 ...
2
votes
2answers
101 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); ...
4
votes
0answers
120 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 ...
0
votes
0answers
257 views
SSRS report viewer - log on failed (rsLogonFailed)
I was redirected here from StackOverflow...
I have set up a web based report viewer using the SSRS reportviewer control (sql server 2008 r2) including the ability to specify credentials.
When I ...
0
votes
0answers
45 views
Include dataset/datasource when downloading report builder
I'm trying to solve the following problem with SSRS 2008.
What I would like to do is when a user clicks on the Report Builder, include with the report (?, needs clarification) the datasource and ...
2
votes
0answers
164 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
245 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
1answer
224 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
331 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 ...
5
votes
2answers
238 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 ...
1
vote
1answer
228 views
Installing 32bit SSRS on 64bit Windows/IIS
I've inherited a situation where I have SQL Server 2005 Standard 32bit running on Windows Server 2008 R2 64bit.
When I come to install SSRS components I'm warned that "Failed to find the ASP.Net ...
0
votes
1answer
516 views
Tablix cells width issue in SSRS
I have a weird issue in the reports that I have created in SSRS 2008.
On the report I have got a number of tablixes defined, that should be displayed attached together vertically. Imagine they form a ...
2
votes
2answers
190 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 ...
1
vote
1answer
184 views
Convert spatial points data to line data for use in Line Layer in SQL Server Reporting Services (SSRS)
I have a query that returns the fields Order, Lat, Long, SpatialData, <OtherStuff>. SpatialData is a point.
I want to create a line layer that draws lines between my points based on the order ...
3
votes
2answers
176 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).
...
2
votes
2answers
644 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 ...
3
votes
2answers
129 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 ...
1
vote
1answer
3k views
Page setup and print layout in SSRS Report
I'm creating a SSRS report using BID 2008 and have a couple of questions, your help would be much appreciated.
Why the page layout on the report is different from print set up? For example I have ...
1
vote
2answers
288 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
282 views
rsExecutionNotFound when directly accessing an SSRS report
I have an SSRS report that can I access from the Web Portal but once I try to access it directly through the URL, I get the following error: Execution 'xxx' cannot be found (rsExecutionNotFound).
I ...
1
vote
0answers
67 views
summary column in ssrs2005 matrix
Hi I create a monthly sale report. there is a week-to-date column at the end of each week, then the end of report, I need to a month-to-date column. The the column will display date and the row will ...
0
votes
2answers
368 views
Date and time parameter In msrs report
Hi I am looking to set up my report so the start date will always be say '14-09-2011 00:00:00'
And the end date will always be '14-09-2011 23:59:59' Or in other words Start date will be 00:00 and end ...
2
votes
1answer
307 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 ...
4
votes
2answers
161 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 ...
1
vote
1answer
290 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 ...
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
3
votes
1answer
306 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 ...
2
votes
0answers
44 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 ...
3
votes
2answers
285 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
63 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
759 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
156 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
129 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
844 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
...
7
votes
1answer
349 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
264 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
358 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 ...
