Reports

SSRS and c# local report
Hi, I want to use the Reportingservices to create a PDF out of my web application. I don't want to show it in the Report viewer. It should be just downloadable. The Report should be created localy without using the webservice of the reporting services. i've seen lots of samples and tried do get the thing t... 10 Jul 2008 03:08

Count on Group problem
Hi there, I'm using VS 2005 with SQL Server 2005 on XP In reporting Services I wrote based on Northwind database SELECT TOP (100) PERCENT C.CompanyName, O.OrderID, P.ProductName, OD.Quantity, P.UnitPrice, P.UnitsInStock, P.Discontinued FROM dbo.Orders AS O INNER JOIN dbo.Customers AS C ON O.Custome... 7 Jul 2008 23:48

Switch vs case
Hi, I am trying to use a switch statement in reporting services because from what I read RS doesn't do case and switch is supposed to be the equivalent. I have found some examples but none seem to have the "else" equivalent in them. Does switch have an else? What is the syntax I'd like to do this Case colou... 8 Jul 2008 21:20

Problems configuring SSRS
We recently upgraded our SQL Server installation to SQL Server 2005. After the upgrade we could not publish to Reporting Services, reconfiguring did not help and ultimately it stopped responding. It appeared that we had multiple SSRS databases created when we tried to get it to work by reconfiguring it, so we... 14 Jul 2008 20:56

SSRS report models kerberos delegation and windows authentication
jave the case when I have kerberos delegation and still when a report model is used I have nt uattherity anonimous authentication instead of the windows authentication. the trace shows that the connection to sql server database for ssrs comming from ssrs server has Login failed for user 'NT AUTHORITY\ANONYMOU... 7 Jul 2008 16:38

Localize Reports
Yes, Create a custom assembly that contains a resx file, then add an accessor method. For localization, I create an instance class, rather than static so that I can keep the users language in a property, rather than passing it in or resolving it on each call. Thanks, Steve MunLeeuw For example: namespa... 7 Jul 2008 13:32

Did you find a solution?
Did you find a solution to this problem? I have the same issue. Even though I set the report datasource to an available data source and I even tried a bindingsource, I get the same error. ... 7 Jul 2008 13:32

SQL Server 2008 RC0 RS + Sharepoint 2007 Integration
Hi, I've set up an environment to test the reporting capabilities of SQL Server 2008 RC0 Reporting Services integrated with Sharepoint 2007. I believe I've completed all the steps necessary to make these work together but unfortunately I'm not able to deploy any reports or successfully deploy but then can't open... 7 Jul 2008 12:30

Can you programatically assign colspan or merge cells
I have a report in a matrix, and I would like to based on the data merge cells or colspan the cells so that a description can be seen across so many fields. Basically its a weekly calendar, I have 5 days across, and someone can have an assignment that is 1 day, 3 days, starting on mon, tues. and so on. If... 7 Jul 2008 11:28

For security reasons DTD is prohibited in this XML document
We have installed SQL 2005 SP2 reporting services integrated in MOSS 2007 farm. When we are laucnhing rdl file in sharepoint library we are getting error "For security reasons DTD is prohibited in this XML document...". MOSS log reports following: Windows SharePoint Services Database 6f8g Unexpected Un... 7 Jul 2008 10:26