reporting-services

Why has Microsoft removed the select all option on Reporting Services 2008?

When creating a subscription on reporting services 2008 one is unable to select all on the parameters. ...

SQL server query not showing daily date result

I have a simple user production report where daily quotas are tracked. The sql returns a weeks worth of data for all users and for each day it tracks their totals. The problem is if they are out for a day and have a zero production for that day then the result query just skips that day and leaves it out. I want to return days even if the...

SQL Server 2008 and .Net 4.0?

Does anyone konw whether I can load .net 4.0 assemblies from SQL Server 2008? In particular, we are looking at SQL Reporting, with Custom Data Extensions. I have noticed that hte SQL Server 2008 Business Intelligence Studio does not seem to support VS2010 at the moment. If I release my CDE's as .net 4.0 assemblies, will I even be able...

SSRS function returns #Error if value of field is null

Thanks in advance for any and all assistance. My code is: Public Function StripHTML(value As String) As String Return System.Text.RegularExpressions.Regex.Replace(value, "<(.|\n)*?>", "") End Function Then I call the function from a textbox. This works great unless there are nulls in the dataset. I tried to compensate for the null...

SSRS create report with given Guid as Identifier

I'm calling CreateReport method on ReportingService web service to create a report on the server. I was wondering if there is a way to give this newly created report a Guid I want for the ItemID in the Catalog table? ...

SQL Server Reporting Services - output subreports to individual files

Hi, I have a parent report that generates a series of subreports. After clicking the preview button, I can see the final report built with the actual data, and I may print it or save it to file. File may be a MS Word doc, a PDF or others. Perfect. I can do that individually to each report I need. My problem: I have a base report that wil...

reporting services: use a custom assembly with a local (RDLC) report

Hello: I am designing a report that will be used in local mode (an RDLC file) in a Winform app. I have a custom assembly with a static class that has some functions that I want to use inside of the report (as expressions). I have found all sorts of help for doing this with RDL reports, but I'm running into a permissions problem with m...

ERROR [HY000][ODBC Excel Driver] The connection for viewing your linked Micrisoft Excel worksheet was lost.

I have an SSRS Report, which uses an Excel file as datasource. I have created a system dsn and connect my SSRS Report through ODBC. I can see the fields in design time but when I preview the report the following error generates. ERROR [HY000][ODBC Excel Driver] The connection for viewing your linked Micrisoft Excel worksheet was lost. ...

Resize Report to set on one page by wide

Is there a possibility to set size of Report to fit on one page pragmatically. In excel there is option for page Scaling where We can set how many pages by tall and by wide is going to be printed . Does exists something analog in SSRS2008 ? I am using Sql Report Server 2008 and Ill try to do that by exporting report to excel and after...

Large Reports for MSRS

I have a report that needs to be able to render a very large amount of pages (about 4500 in this instance) in a web browser. The total time needed to finish on the report server from start time to end time is about 30 mins for the instance that I am looking at. Does anyone know what options exist for handling the rendering of such a la...

Select All as default value for multiple values parameter SSRS

Hi there I'm building a report in VS08 with a lot of multiple values parameters and it's working great, but I would like to have have the "(Select all)" option as default value when the report is opened. Is there some kind of expression or sql code I can use to make this happen or do I need to choose "(Select all)" every time, in every ...

Diaplaying SSMS standard report in your web application

SSMS 2005 & 2008 comes with inbuilt standard reports. How can we display these standard reports inside a asp.net web site? ...

Dual parameters for same value

Is it possible to have 2 report parameters set the same actual parameter? For example, the user should either be able to type in an ID, or select it from a dropdown list - for the query to then take that id and run the proc for that id. ...

SSRS 2005 tabs/newline characters display in table

Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table will render as: TRIPLE > HYBRIDS > HY...

Getting a null reference exception exporting a slightly complex rdlc report to excel

Have an issue in exporting a slightly complex report to excel from an rdlc. Exporting a simple tabular report works fine, but getting a null reference exception with a more complex one. As is usually the case, it works on the server in the development environment, but not in the test environment. The server in the development environme...

How can i Make This Type SSRS.....

I have a table in data base which has column MonthNo ,Year ,MonthValue ,AvgYTD and it has values in 1 ROW... 1 , 2010 , 2.3 , 4.0 AND 2 ROW... 2, 2010, 3.3 ,5.0 AND 3 ROW.. 3, 2010, 3.3, 7.9 AND I want output in my SSRS..... WHEN I SELECT MONTH MARCH USING PARAMETER THEN OUTPUT WILL BE....A TABLE AND IT HAS COLUMN JAN , ...

The width of a list that contains an embedded matrix grows unexpectedly

I have a report in reporting services 2005 that includes a list with an embedded matrix and am attempting to put a border on the list, however, when I run the report in visual studio the matrix is growing past the end of the page and therefore the border is growing with it causing it to grow into the second page. It appears that there wa...

HP Quality Center 10- Publishing Dashboard reports

Hello- We are creating reports on QC 10 using the dashboard module. I was wondering if there is a quick, built-in way to publish a URL so 3rd parties (non-QC users) can view the reports on the web. Is such thing possible or is there a recommended workaround to that? Our second option would be to export the report to Excel. Apologies ...

Lotus Notes embeds SSRS csv data in body not as attachment

I have a MS Reporting Services subscription implemented which emails out a CSV report as an attachment. The email is received with the attached CSV file no problem, EXCEPT for users with Lotus Notes. With LN users the contents of the csv file are embedded in the body of the email. Any suggestions on this? UPDATE: Might Lotus be handin...

SSRS Subscription not loading in Browser

I have SSRS set up with IIS and SQL on separate servers and can no longer add new subscriptions from the web interface. ...