ssrs-2008

How to embed file attachments from TFS work item into SSRS 2008 report

Hi I have a few work items in TFS 2008 with file attachments. I have generated a custom report based on the TFS work item data using ssrs 2008. Now I wanted to embed file attachments (related to the work items) within the ssrs report. How to extract the attachments from tfs database and embed in the report? Thanks. ...

SSRS 2008 export to MS Word issue

Hi I have a ssrs 2008 report which when exported to word gives all sorts of horizontal and verticals lines with data in between and also does not include the image. As an example please see the below snapshot of the original report: << THERE IS AN IMAGE HERE >> And now the word export snapshot: << THE IMAGE IS MISSING FROM EXPORT >...

Calling custom C# code from SSRS 2008 report

Hi I want to call a function written in C# from within ssrs 2008 report. Following is a close representation of the actual C# function to be called public void GetAttachment(string serverName) { TeamFoundationServer tfsServer = new TeamFoundationServer(serverName); tfsServer.Authenticate(); WorkItemStore workItemStore = new Wo...

Does Microsoft SQL Report Builder require Reporting Services running at all?

I'm having trouble figuring this out. I stopped ALL of local SQL Services, e.g. SQL Server, SQL Agent, Reporting Services. Then using Report Builder 2.0 to create a report connecting to a remote SQL Server (No SSRS running) out in the farm. When I click on "Run" button, for some odd reasons, it still render the report. I thought you ...

Reporting Services Textbox "Line Break"

I am bringing data over from Oracle into SSRS. One dataset pulls in a a string of names and initials divided by a semi colon. : EX: Ratliff, J D;Schlue, R S I would like to insert a line break after each semicolon and bold the very last line to display as follows: Ratliff, J D; Schlue, R S Any ideas on how to accomplish this? ...

Getting windows account username of the client accessing the ssrs report.

Hi Is there a way to get windows account username of the client accessing the ssrs report. If user is accessing reports on server B from machine A how can we get the user's windows username in the SSRS report? I used User!UserID and it worked fine since I was running it from my local machine. As soon as it was deployed to a different ...

How to prevent autoresizing body in SSRS report

I have a report that has a header and footer that are both set up to fill the whole A4 length (minus margins of course) because I have some information on the far right and far left of each of them. Now in the body I have a List Element that allows me to have a tablix report and a chart next to each other. The body is also sized propery ...

"The remote host closed the connection. The error code is 0x80072746." On cancelling a big report export.

Hi, I get the following exception when i try to cancel the download of SSRS report export. It is generated by Reserved.ReportViewerWebControl.axd file. Is there anything i can do to prevent this exception? I did google before posting here but really didn't find anything useful. System.Web.HttpException: The remote host closed the con...

Reporting Services - translating labels into different languages

I'm finishing up my reports in my SQL Server 2008 Reporting Services project, and as one of the last steps, I need to make things translateable. Since I have a bunch of reports, and they all share some identical labels, I decided to put all those labels I need to show into a SQL Server table, and I am surfacing that contents as a DataSe...

TFS Burn down charts

Hi I want to create a simple ssrs report showing rolling burndown chart for each team member in a particular iteration/sprint. So if 5 members are on the team then there should a burndown chart for each of the member depiciting the remaining effort (in hrs) against last 30 days. This will be a rolling time period from present date to la...

Missing expansion images on Matrix Report

Hi, I'm comparatively new to report-viewer control and SQL reporting services. We've developed a report with matrix control and integrated the RDLC file on the asp.net web page. It works perfect when published on the local development server with the expand and collapse functionality but when we published the web app to the production s...

Using Dynamic Connection Strings in SSRS2008

Hi, I have a bunch of SSRS 2008 reports which I'd like to run on several different machines (development, test, production). Each machine has it's own database, so I need to use different connection strings depending on where the report is running. One workaround I found is to specify the server and catalog name in a hidden parameter ...

Typing delay in SSRS 2008 report designer.

When creating a report using VS 2008 there is a typing delay in all the textboxes on the report designer. When I type in a textbox, whether a lone textbox or a textbox within a tablix, the text will not appear until approximately three seconds after I stop typing. I've recently installed SQL Server 2008 and I did not have this problem ...

Doing conditional formatting on empty cells.

I'm currently building a matrix style report. After each rowgroup, i would like to add in a nice 2pt solid black border. Unfortunately not all fields in the matrix will have data in them, and therefore i don't seem to be able to use conditional formatting on the cell level. I've tried using IIF(RowNumber("group") = 1, "Black", "Light ...

Reporting Services - Get the results for a specific period through a longer period

Original Question with Query attached as requested, thank you Hello, I have a table that retrieves data over a 3 day period on an hourly basis, there are several different machines that work on a specific bottle for a period of time, during the three day period there could be several different bottles go on that machine. I want to show...

Howto: Display a parameter on a SQL Server Report?

I'm creating some reports in Visual Studio BIDS, out of our SQL Analysis Server 2008. The report works fine, and uses an MDX query with parameters. So far, so good. The problem is that I would like to display the parameter on the report. For example, I would like to display the 'Month' of the Date parameter, but it shows up on the repor...

SSRS How to add a tablix footer group

SSRS Newbie and feeling a bit silly. Im working on my first report(in VS 2008) and cant seem to work out the group footer for my tablix. This must sound really simple but how do I add it and configure it to show on every page of my report? I have the group header working fine but I want the overall totals to display at the bottom of eac...

SSRS2008: LocalReport export to HTML / fragment

I need local RDL report to be exported to HTML, preferably HTML fragment. In 2005 it wasn't officially supported but there was a trick. In SSRS2008 they seem to drop this support (there's no HTML extension in the supported extensions when enumerating using reflection) and use RPL instead which is a binary format that I doubt someone will...

SSRS 2008 Reports column and row header visibility while scrolling

For the tablix used in report keep header visible while scrolling options are selected for row and column headers during design time. Scrolling is happening during testing time on report server also. During deployment, the reports are hosted on a report viewer control in asp.net page. Auto scrolling is not happening. As the report's size...

SSRS 2008 export to MS Word with dynamic Page Footer

Hi all, I have a requirement to have a page footer show up on the first page of a report, and then no page footer on subsequent pages. When I create a report that toggle the visibility of objects in the footer it works fine in BIDS, and it works fine when I export to PDF, however upon export to MS Word, the footer from the first page a...