0
votes
0answers
11 views

Reporting Services Scripter ScheduleID Error

I'm currently in a SQL Server 2005 environment that's being upgraded to 2012. I need a tool to script out all of my SSRS subscriptions, and I chose to use RSScripter. I'm having an issue whenever I ...
1
vote
0answers
64 views

SQL Server Reporting Services (MSSQLSERVER) Process using high memory

We have the Reporting Services installed on our database but we are not actually using it. Generally, the running process takes up a few MB but all of a sudden it has jumped to 4GB. We have restarted ...
0
votes
1answer
174 views

Find the median of a calculated field in SSRS 2012

I have a start date and an end date, and am calculating the weekdays in between with the following: I created a calcuated field called CountWeekDays, and it equals: ...
0
votes
0answers
55 views

SSRS different print and screen layout

Is it possible to display all rows of the report on one page when displayed on the screen, and one row per page when printed out?
0
votes
0answers
321 views

How to determine if SQL Server Reporting Services database is being used?

I have a SQL 2005 server that needs to be decommissioned. For regular databases, I have a couple scripts that look at sys.dm_db_index_usage_stats to determine last access. My normal process is to make ...
2
votes
1answer
2k views

How to keep the structure of the Tablix when there is no data to show

We have a SSRS report which shows the result of a dataset in a tablix. If the query in the dataset returns no data, the header of the Tablix gets displayed but not the tablix cells below the header. I ...
0
votes
0answers
282 views

SSRS - display in DataSet1 the sum of a column from DataSet2 grouped by a specific group

I've got an excel chart that I'm trying to convert to an SSRS report. I've got 2 charts. One with today's data and the other yesterday's data. C,D columns have changing values. E,F columns have ...
1
vote
2answers
2k views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
0
votes
2answers
418 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 ...
0
votes
1answer
80 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
1k 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 ...
2
votes
1answer
544 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
2answers
474 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
10k 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
914 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 ...
0
votes
2answers
1k 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
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 ...
-4
votes
2answers
530 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
267 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
83 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
362 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 ...
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 ...
1
vote
0answers
397 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) ...
20
votes
1answer
485 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 ...