A commonly used name for Microsoft SQL Server Reporting Services (SSRS), a web based reporting tool bundled with Microsoft SQL Server.

learn more… | top users | synonyms

3
votes
2answers
108 views

why would command text not execute at all?

in my report i have:: <CommandText>SELECT column1, column2, 'poop' from mytable </CommandText> i am using sql server profiler to see exactly what statement is ...
2
votes
0answers
18 views

Troubleshoot Microsoft SQL Server Reporting Services unexpected error

I have an error implementing reports on reporting services from Visual Studio 2005 but I can do it from the Reports Manager Microsoft SQL Server Reporting Services Versión 10.0.5500.0. The ...
1
vote
0answers
44 views

Drill down report links fall outside cell

Apologies for the vague title, not sure how to summarise the problem... I'm creating a dashboard report showing server state for a group of SQL servers, the problem is that the links for the drill ...
1
vote
0answers
233 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) ...
1
vote
0answers
607 views

Problems with cross forest authentication in SQL Reporting

We're currently running an SQL 2008 R2 Cluster with Reporting Services running, all for use with System Center Operations Manager 2007 R2 (RU3). Our users are on a different domains to the SCOM and ...
0
votes
0answers
24 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., &#x201C; should display as left double ...
0
votes
0answers
246 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
222 views

looking up a value in a table using ranges in SSRS

I have a fairly smple use case that I can never seem to figure out in SSRS. It has caused me great pain so I figured I would see if anyone knows the answer. In SSRS i have a query that returns a set ...
0
votes
0answers
395 views

Sys.WebForms.PageRequestManager Error in SSRS

When i am executing on SSRS report i am getting below error Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code ...