Anyone know how I can copy the user reports (and model) someone has created to point at another database (same schema). I don't really want to recreate the data model becuase (a) it's really complicated and (b) the previous developer added lots of friendlt column names. Thanks in advance, Jim ...
Hello, A quick question for someone, hopefully! In my .rdl file source I can see the tag "< sorting >" Where abouts in the GUI (I'm using Visual Studio) can this property be set? Thanks in advance, Jim ...
I'm using ssrs with the winforms ReportViewer control to display reports to my users. Sometimes they want to select some of the text that the report outputs. But the ReportViewer control does not give us that ability, it just renders the text. Is there some property that I can change in the .rdl report or some property in the ReportViewe...
I tried to find any solution, saw a lot of similar questions on different sites, but still have no appropriate solution. So, the situation is following: On SQL Server 2005, Reporting services I have printed form (ex. "invoice"), which can be multi-page. I need to print a lot of such forms (ex. all "invoices" for specified customer and ...
Hello, My SSRS 2005 report has a border around the table. Currently, if the report goes over two pages, then the following happens: PAGE 1: Border on top, left and right sides. PAGE 2: Border on bottom, left and right sides. I want to have a border at the bottom of page 1 and the top of page 2. FYI: Putting a border on the body doe...
I'm trying to add an image to a report. The image src url is an IHttpHandler that takes a few query string parameters. Here's an example: <img src="Image.ashx?item=1234567890&lot=asdf&width=50" alt=""/> I added an Image to a cell and then set Source to External and Value to the following expression: ="Image.ashx?item="+Fields!ItemID....
I have finally gotten the ReportViewer to work in Local mode. Now I would like a report to render as a PDF or Excel spreadsheet automatically. ...
I have a SSRS 2005 report form that is printing to a Zebra ZDesigner TLP 2844-Z label printer. The Interactive and Page sizes are set to 4" wide by 3" high. Since there is no paper orientation in SSRS, it is assuming this to be a landscape report when it should be a portrait thereby printing the labels sideways. The users are able t...
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. ...
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 >...
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...
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 ...
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...
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...
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...
Perhaps this question is naive, as I am just starting with ssrs. This is a large Delphi (2009) application that currently uses Crystal (activex) for reports. We are wanting to move to ssrs but would still like to control the report parameters from within our app as we've done with crystal. I've seen the Report Viewer Control for a VS env...
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 ...
I am trying to add the variable SName to the report header. I copied this =First(ReportItems!SName.Value) after reading this http://msdn.microsoft.com/en-us/library/ms252093%28VS.80%29.aspx and it works on the First page of the report. However, on the second through penultimate page it becomes blank (i think because the textbox Sname do...
Is there a way to customize how SSRS reports its log? I would like SSRS to report subscription errors to a database, is there a way to do this? Thank You ...
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...