reportingservices-2005

Reporting Services 2005 Model using WCF Service for data

I am trying to use WCF Services as models for SQL Server Reporting Services 2005 reports. I can do this if I design the reports in the designer but cannot do it for a Reporting Model project which I think I need to make reports in the Report Builder. My full requirement is to have a report builder that the users can use building reports...

SSRS 2005 formatting question

Hi, I am working on SSRS 2005. I am using two rows as header. The border between the two rows are made white color. The report works fine when I generate it with report viewer. However, when I export it to PDF, the hidden (i.e, white) lines become visible (in black). Is there any way to rectify it? Thanks Lijo ...

SSRS csv export

Hi Team, I am working on SSRS 2005. I have a column that has a comma to be displayed. I write it in the header; but the SP returns without comma for the column header. When I export the report to csv, the column names are taking the name of the text box wich is not having comma. Is there a way to display comma in the header when exporte...

SSRS VS05 - Create a Scale break in a Line chart

Is there a way to add a Scale Break in Visual Studio 2005 for an SSRS line chart report? The reason is because I have some data like the following: Vendor Date Amount ------ ---- ------ Test 1/1 0.0093 Test 1/2 0.0072 Test1 1/1 0.0033 Test1 1/2 -0.0450 Volume 1/1 343203 Volume 1/2 493902 I'm...

Setting Parameters from another Parameter In SSRS

I was able to get this working is SSRS 2008, but do to the fact that my company only has 2005 servers I need to downgrade the report to 2005. The idea is for a given person name there are two key fields EntityType and EntityId So I have a parameter from a dataset where the Label is the Name and the value is EntityType_EntityId I use t...

Reporting Services 2005 Deploying error: could not load file or assembly

Hello, I made a report on Reporting Services 2005 which consumes an external assembly, I added that assembly to the project: Report - Report Properties - References I also copied the assembly to the folders: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin C:\Program Files\Microsoft Visual Studio 8\Co...

SSRS Forms Authentication - Report Builder Login

Hello, I'm using SSRS 2005, with custom forms authentication module. That works great. But the report builder prompts for credentials, is there a way to get around this? Is this a configurability thing? Thanks. ...

Report Builder Error (Input string was not in a correct format) when filtering data

Issue: the user is getting an error “The requested list could not be retrieved because the query is not valid or a connection could not be made to the data source.” while trying to filter a reporting using Report Builder 2.0. When you expand the details the message is “Input string was not in a correct format” I verified that when the...

How can I remove the "!NEW" marker that appears next to items in SQL Server Reporting Services 2005's Report Manager Web interface?

Like many others, I have had to resort to writing a custom report deployer for SQL Server 2005 Reporting Services elements. Currently, its method is to completely destroy the entire contents of the entire report server, then to re-upload all RDLs, images, etc. from scratch. (This may need to change one day if we start using SSRS more d...

How do I enable Model Item Security in Reporting Services 2005?

For the life of me I cannot figure out how to enable model item security on my models in RS2005. Pages such as: http://msdn.microsoft.com/en-us/library/ms365305%28SQL.90%29.aspx Imply that I need to connect using Management Studio... However, when I connect with Management Studio the only things I get to manage are: Jobs Security (...

SSRS 2005 Report Viewer Date Picker Performance Issue

Hello, The date picker on the report viewer control in SSRS 2005 is causing our application to slow down a lot; when the user clicks the calendar icon, it really takes a while to load for them for some reason. Any ideas why? Thanks. ...

Convert Unix Epoch Time to format HH:MM:SS without the date

I'm using SSRS 2005 and I need to convert time from a serial unix time like 3412.254263 to a duration like 166:12:35 where the second format is HH:MM:SS. All .NET code should work, but I can't find any function that does not include the date or does not treat the result as a duration. Any help would be appreciated! ...

SSRS- Bar Chart with single bar needs to display Percentage data

Hi All, I have a requirement to show percentages in bar chart on a single bar using SSRS. For example, I want to show a employees by Age in a percentage in an SSRS report. 1.How many % employees between age 20 and 30? 2.How many % employees between age 30 and 40? 3.How many % employees between age 40 and 50? All this on a chart which h...

A network-related or instance-specific error occurred while establishing a connection to SQL Server

Hi I have two databases DB1 (used by my application) and DB2 (third party) under same SQL Server instance I get the following error SqlException ERROR: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the inst...

SSRS CSV Rendering Export Issue....

I am having my table like this (2 tables) UserId Name 2 Welcome 3 Rename Password Data 2dfdf dfd 3 dfdf I need the data while exported to csv like this... UserId, Name 2,Welcome 3, Rename, password, Data 2dfdf ,dfd 3 ,dfdf But it is displaying like this UserId, name, Password, Data 1, Welcome, 2dfdf ,dfd 3, Rename,3,dfdf How can ...

SSRS 2005: How do I make available varbinary data for download in a report?

Hi, SSRS newbie question here... I have a table where one column is varbinary(max) data. I would like to make a report that makes this data available for download as a hyperlink so the user can just click on the item and get a file download dialog for the binary data. In this particular case, the binary data happens to be the content o...

How to stretch an SSRS table to the end of the nearest page

Hello all, I can't seem to find anyone who has had the same problem as me, which I find hard to believe because it seems like it should be a common need. On to the problem... I have a pretty standard SSRS 2005 Invoice report that has a header, a few address below the header, a table that contains the line item information about the in...

Is there an easy way to transfer reports/schedules from an SSRS 2005 server to a different SSRS 2008 server?

We have a ton of SSRS2005 reports, which I intend to transfer to our new SSRS 2008 server. I'd rather not do this manually... Actually, we've got some SSRS2000 reports on a third server as well, so if anyone knows of a tool or technique for doing all these transfers I pay in upvotes! ;) ...

Can I make a matrix row group span its child groups in SSRS?

I have a matrix, whose rows are grouped into two groups. A class, and a time for that class. The class cell is going to end up being several lines long, and I'd like the rows for each time slot of the class to line up next to the class description, like this: ----------------------------------------- **Class** | 7:00am | [row ...

SSRS 2005 concat values in dropdown parameter

Hi All, I have a dataset which I want to use as a parameter for my chart in SSRS. The puzzle that I am trying to solve is as below. My DataSet has 4 columns and in the Dropdown parameter I can only specify label and value. I am not able to specify two columns as Label and two columns as value. Does anyone know how to concat the values...