Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
40 views

Split record data in ssrs

Hi all can you please assist me, I would like to split my records into different year and month see below I want figure one to be split into different categories but this must all display on one ...
0
votes
1answer
999 views

SQL Server Reporting services migration (2008 to 2012)

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their ...
2
votes
0answers
125 views

Cross-talk with temp tables with SSRS over a shared data source?

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in ...
0
votes
1answer
52 views

Report in MSSSRS without Star Schema?

I have to create a single report in MSSSRS to view calculated columns (Salary, Total Compensation, Performance Bonus, 401 (k)) by Employee, Department, Service Line, Geography, Quarter, etc. My ...
0
votes
2answers
127 views

Do I need to have enterprise server in order to have multiple data sources in SSRS

I am currently running a single server setup of SSRS on MSSQL Server 2008 R2 Standard Edition and would like to know if I can have multiple data sources in this type of setup. The reason I ask this ...
0
votes
2answers
2k views

SSRS Subscription Error: “Failure sending mail: Report processing has been canceled by the user. Mail will not be resent.”

On the report Subscriptions page, under "Status" for Last Run, it has the following error: Failure sending mail: Report processing has been canceled by the user. Mail will not be resent. It's a ...
3
votes
2answers
6k views

How to hide rows in SSRS report?

I'm trying to figure out, how I can hide those rows in my report where Total Allocation and Total Cost IN BOTH COLUMNS TOGETHER are 0 in SSRS 2008. For example: Total Allocation Total Actual ...
0
votes
2answers
2k views

SSRS 2008 - How to Total values from an expression

I'm trying to figure out how to total values from a calculated field. In the example below, I have the following expression: =IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100, ...
0
votes
0answers
206 views

Why have a couple reports started rendering slowly?

Been troubleshooting an issue for a couple weeks now, where a couple reports are running really slowly. These aren't terribly complex reports, they just grab data and do a little aggregation/sorting ...
2
votes
3answers
1k views

Not getting a result set in SSRS 2008r2 from an iSeries DB2 SQL stored procedure

After reading 'Defining an SQL procedure' section of DB2 UDB for iSeries SQL Programming Concepts V5R2 and 'Returning result sets from stored procedures' section of i5/OS Information Center, Version 5 ...
0
votes
0answers
414 views

SSRS 2008. subreport page breaking issue migrating SSRS 2005 reports over to 2008

I'm moving over several hundred reports that were created in SSRS 2005 over to an SSRS 2008 server, and most run fine when copying the .rpt files over, but the reports that have sub-reports don't page ...
2
votes
1answer
245 views

SSRS 2008 parameters question

SSRS allows you to create 5 types of parameters: Text, Boolean, Date/Time, Integer i Float. I created a new integer parameter which allows user to enter a minimum price and view a report. However if ...
1
vote
1answer
1k views

Reporting Services TempDB keeps going into restoring mode

I am looking into an issue with SQL Server 2008 Reporting Services. It has been working fine until yesterday morning. Now I notice that ReportServerTempDB keeps on going into Restoring... mode. I ...
0
votes
2answers
608 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
0answers
149 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 ...
1
vote
1answer
78 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 ...
2
votes
4answers
839 views

Creating a copy of production database for reporting purposes

We previously ran Crystal Reports straight off our production database. This caused a direct impact to the users using the database. We moved to a new (dedicated) server and a new database and ditched ...
2
votes
2answers
501 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
1answer
584 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 ...
0
votes
1answer
3k 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 ...
0
votes
0answers
161 views

SSRS - rsAccessDenied error

I have created one SSRS text report. I have built and deployed it successfully. I am also able to view it from the report manager succesfully. I am a local admin on windows server but not on SQL ...
1
vote
1answer
1k 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 ...
1
vote
1answer
284 views

The best way to log access to SSRS reports

We have a number of SSRS reports created using BIDS 2008 on SQL Server 2008 r2. The business wants us to log access to these reports. For example who and when run the Report A. What is the best way ...
2
votes
1answer
496 views

Renaming the Data Sets in SSRS

What is the easier way to rename the Data Sets in completed SSRS report? I have created a report in BIDS 2008 and now for some reasons I have to rename the Data Set names, but it seems that renaming ...
2
votes
1answer
12k 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 ...
3
votes
2answers
1k views

SSRS 2008 Report toggling between images for various field values

What is the best way for toggling between images on a SSRS report? On the report I'm creating, there are lots of questions with Yes Or No answers and based on the value I've got for the question, ...
1
vote
1answer
2k views

How to convert execution time to a specific format?

I am working on a report that allows people to print off data for physical signatures. Part of the requirement is to format the exectuion date in the format DDMONYY (27Aug12). I can not find a way ...
4
votes
1answer
702 views

Providing an ad-hoc report facility for business users in SQL Server 2008 R2

We are using SQL Server 2008 R2. We need to provide the business users an interactive data exploration facility which they can drag and drop the attributes(columns) they want to create their own ...
2
votes
1answer
32 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
5
votes
1answer
127 views

Show data point values in the legend section

Is it possible to show the values in the legend section in a chart component of SSRS? I'm using SQLserver 2008. Something similar to the image below
3
votes
2answers
533 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
534 views

Can you rename or name Reporting Services jobs?

In Report Manager you can create schedules, either shared or one-of's. When you create these schedules a job is created in SQL Server with names that look like guids. IS it safe to rename these jobs ...
4
votes
1answer
564 views

How to query EndDate value from ReportServer..Subscriptions.MatchData

In SQL 2008 R2, I'm putting together some administrative queries on SSRS metadata to check proper configuration, and other sorts of proactive things. While querying the ReportServer db, I've been ...