reportingservices-2005

Export to excel using report viewer and reportservices

I try to export a report as excel. I am using a report viewer control in a aspx page, the report is on a SSRS 2005 server. The report is rendered ok, I can see it in the browser, I can export it but I cannot open the xls file (neither pdf file). If I open the report directly from SSRS and export from there than the file is readable. I h...

MS Reporting 2010: Use Multi-Value Drop-Down to Add/Subtract WHERE clause from SQL Query

I am currently trying to create a report in Visual Studio 2005 for MSSQL 2005. I need to provide a multi-valued drop-down box that would allow a user to select one or more options. If a user selects one or more of these options, my SQL statement would need to add a AND column = 'something' to my SQL query. I am wondering how I might acc...

Show/Hide a Field based on a UserGroup in SSRS

I have a requirement that needs to show or hide a field on a report in SSRS 2005. I would like to do this based on the Sharepoint or Active Driectory User Group the user is associated with. I know that there is a Global UserID in reporting services, but I don't want to have to modify the report every time a user changes position. ...

Trouble with contradicting where clause

Hi, I am trying to display what each user has spend their time doing for the week(either internal or external work) but the time is all on the same column on the table, is it possible to split it into 2 different columns and still have it so that it only shows each user once not each time they entered time which could be multiple times ...

Export to PDF problem

HI, I have a SSRS report that has about 4 tables in the body and each one has about 4 columns, I fill each tale with its related data, my problem is when export to EXCEL everything is fine but when export to PDF it seems that tables are overlapping each other in away that makes the report look bad. does any one have any suggestions? ...

SSRS if string says this then change it to this

I have a field in SSRS and it returns from SQL saying "Incomplete" In SSRS I want to say anytime this field says "Incomplete" to change the string to "Pending" This has to be done in SSRS. Thanks! ...

What's a good standalone viewer/renderer for RS reports?

Not that technical a question I guess, but what do you guys use? I normally use CRM, but I have a use for a totally standalone one, and I'm not sure what to use for this. ...

SSRS 2005 Get Next Record Value

Hello, How to get Next Record value in SSRS 2005? In SSRS 2005 has previous function but it has not NEXT function. Any other way to implement this function? Prompt reply will be appreciated. Thanks, Dhruval Shah ...

How do you separate a list into sections in RS?

I have a simple list, along these lines: Name % George 20% Ryan 45% Ed 92% In reality, there are multiple percentages listed for each name (simplified; '%' is actually a calculated value), and I'm displaying the last one. What I need to do, though, is break the list up into sections, like so: 0-40% Name % George ...

SSRS - Severe error message when running stored procedure

I have a report that runs a stored procedure that takes about an hour to run. After about 30 minutes I get this error message on the report body: An error has occurred during report processing. Query execution failed for data set 'DEV'. A severe error occurred on the current command. The results, if any, should be discarded. Operation ...

Filter list by custom code in Reporting Services 2005?

Can you do this? The list filter I want to use looks like this: Expression Operator Value =Code.GetOccCat(Fields!accountnumber.Value) = =1 No dice. Basically, it acts like that function returns null as far as the filter is concerned, but when I take the filter off and put the exact...

MDX Syntax for Selection of Numerous Field Values

Hi, I'm writing an SSRS 2005 report based on our cube that contains a prcoedure dimension. I need to setup the report such that it contains only those patient records that has one or more defined procedure codes. My research thus far has pointed me toward creation of a query parameter in my report's dataset. Would this be the corre...

SQL Server 2005 Reporting Services language setting

Ok, i need to write a report in Arabic (ar-AS), the information for this report is in a database in English, with varchar columns (not nvarchar) with collation SQL_Latin1_General_CP1_CI_AS The Language Settings for Reports and Report Designer only changes dates, currency, and numbers to the given language. I also need static text (colum...

SSRS return blank value and regular value to function

In SSRS I have a parameter that is populated from a multi-value list which allows a blank value. When I select just the blank value it returns unit 123 When I select just "New" it returns unit 987 When I select both owner "New" and the blank value it only returns 987. Any ideas? Does SSRS not allow you to pass the blank value and a n...

SSRS reports render incorrectly when directly to pdf

I have a report that is generated directly as a pdf report using the System.Web.Services.Protocols.SoapHttpClientProtocol. When the report renders as a pdf document soem of the cells that have TextAlign set to Right are actually showing with the TextAlign as Left. Is there something in the rdl file that is causing this or is this a bug...

LINQ to SQL vs. SQL Server Reporting Services, which one is good enough for the following?

Basic reporting on content usage including time spent viewing a media asset, progress and interactivity based on % complete or correct for up to tens of thousands of users. Basic table and text based reports. Everything is in a SQL Server 2005 database. To me I don't feel like I should have trouble optimizing the LINQ to SQL to be good e...

SSRS 2005 conditional count in chart: how-to?

I have a column chart in which I want to display the % of Invoiced Sales in 24 hours and % of Not Invoiced Sales in 24 hours. The data should be categorized by date, so for each date I can see the % of invoiced and not invoiced sales within 24 hours. My dataset contains: sales id, sales status (only invoiced are permitted and I took...

Default value reporting services if no data

I have a filter on my report that is a multivalue list for UnitNumber. The report is set up to show each unit's details on a separate page. If I select unit #3 and unit #4 and unit #4 doesn't have any data, is it possible to show the data for unit #3 and then on the next page say "Unit #4 has no activity"? ...

Always select all in SSRS cascading parameters

I have 2 parameter lists. 1 is Owner and 1 is unit which is dependent on owner. These are multiselect parameters. By default select all is chosen for both so right when you enter the report select all is selected for both Owner and Units. Now when I uncheck select all and check 3 owners it again selects checks all units in the unit lis...

SSRS 2005: printing issue - report prints first page in portrait and rest are landscape

my environment is SQL 2005, SSRS 2005 , .net 2.0 Client is experiencing following issue on two different printers. ( Canon and Lanier LD140). We have a report which is designed as landscape report. When report is send to print, First page is rendered in portrait mode(cutting of the information on the right side. ) rest of the pages ...