A commonly used name for Microsoft SQL Server Reporting Services (SSRS), a web based reporting tool bundled with Microsoft SQL Server.
3
votes
2answers
119 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 ...
0
votes
1answer
53 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
19 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
18 views
Problem with sorting matrix groups in SSRS
I've hit the following issue in SQL Server 2005 Reporting Services
This is a slightly odd and complicated situation: I have a table containing various groups and within each group is also embedded a ...
1
vote
0answers
47 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
250 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
644 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
32 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
283 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
248 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
409 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 ...
