I created a simple report and uploaded it to my report server. It looks correct on the report server, but when I set up an email subscription, the report is much narrower than it is supposed to be. Here is what the report looks like in the designer. It looks similar when I view it on the report server: [http://img58.imageshack.us/img58/...
In our application, we allow administrators of an install to design templates for name tags that are printed when they check-in from a kiosk (sort of like checking in for a flight at a kiosk and printing out a boarding pass). For example, the template might look something like this: [FirstName] [LastName] [Company] [PersonImage] [BarCo...
I have an internal customer that only receives his email report from MS Report Services 2005 about 30% of the time. It is not getting caught by a SPAM filter. The report takes about 2 minutes to run. Does Reporting Services give up after 60 seconds? How do I begin to troubleshoot this issue. ...
Hi, I want to group by a report item, but that's not allowed. So I tried creating a parameter...not allowed as well. Tried referencing from footer...failed again. This is somewhat complicated. Let me explain: I have textbox22, it's value is: =Code.Calc_Factor(Fields!xx.Value, fields!yy.Value...) This is embedded VB code in the report ...
I have the following SQL Statement. I need to select the latest record for each System.Id using the System.RevisedDate SELECT [System.Id],[System.RevisedDate], [System.Title], [System.State], [System.Reason], [System.CreatedDate], [System.WorkItemType], [System.TeamProject], [Microsoft.VSTS.Scheduling.Remainin...
A report I have been working on some time ago started mis-rendering around Christmas. Some of the text boxes on it suddenly started rendering each character in their text content on top of each other, as if the printing of each character no longer "advances the cursor" to the correct position for the next one. The report is rendered to P...
UPDATE 2.4.2010 Yeah, this is an old question but I thought I would give an update. So, I'm working with the ReportViewer again and it's still rendering slowly on the initial load. The only difference is that the SQL database is on the reporting server. UPDATE 3.16.2009 I have done profiling and it's not the SQL that is making the Re...
I'm developing a simple bar-chart in Reporting Services 2005 with a stored procedure as data-source. The values in this graph can be both positive and negative, and can span a very big range, and hence I cannot specify any non-dynamic scale that will work for all scenarios. The problem I'm facing is that the automatic scaling pretty muc...
Hello, The previous DBA here set up some SQL Server Reporting Services Reports to run automatically and email the report to users. When he left his accaount was disabled and now they don't work. The status on the subscription reads: "Failure sending mail: The permissions granted to user 'OURDOMAIN\old_DBA_Username' are insufficient for...
There is a "How To" on adding developers to the TFS on MSDN. http://msdn.microsoft.com/en-us/library/bb668968.aspx It has 3 main parts: Step 1 – Grant Access to the Team Project Step 2 – Grant Access to the SharePoint Project Site Step 3 – Grant Access to SQL Server Reporting Services Fair enough, it works for individual developers. N...
I'm new to SSRS, so I apologize if this question is too simple: I have a report which accepts a parameter called "Amount". I want to constrain valid inputs to currency values >= 0, and pop open an error message if the user enters improper values. I don't want to validate inputs in my stored procedure and throw exceptions, because SSRS ...
I'm using a web service and every time I change something on the dataset, it erases all my parameters. The weird thing is, I can execute the web service call from the data tab and it prompts for all my parameters, but if I click to edit the data the list is empty or if I try to preview the report it blows up because parameters are missi...
I'm starting to look into SSRS Report Builder 2.0, and I see in the documentation that it supports connections to SQL 2005. Does anyone know if the reports made against SQL 2005 can then be upload to the SSRS 2005 website and ran from the site? Or, can they only be run from the SSRS 2008 website if they were generated in Report Builder...
I've got a report in SSRS 2008 that is using a web service as one of its data sources. The basic look of the XML returned is <table> <row> <column1>data</column1> <column2 xsi:nil="true" /> <column3>data</column3> </row> </table> Any tags with the "nil" attribute are showing up as blank on the report. I...
I have created a report in SSRS that contains 2 matrices (not tables/lists), each with a subtotal. What I am trying to work out is if there is any way to calculate a 'grand total' at the bottom of my report that is the sum of the subtotals from my 2 matrices. Matrix 1: 10 10 10 5 10 5 5 ...
How can I set a parameter of a sub-report? I have successfully hooked myself up to the SubreportProcessing event, I can find the correct sub-report through e.ReportPath, and I can add datasources through e.DataSources.Add. But I find no way of adding report parameters?? I have found people suggesting to add them to the master report, bu...
It seems that due to ActiveX that Firefox can't display the print icon/button on the Report Viewer control in SQL Server Reporting services. Has anybody figured out a way to work around this or gotten this to work? If it's not possible, does anybody know of a way to add a standard button that would trigger the print behavior on the rep...
I am trying to insert a conditional page break, actually i had a report of 50 pages with invoices each invoice is 3 pages long so i need a paghebreak for the 2nd invoice t printon the next page as i need the whole report ot print back to back,so i inserted one page break,so this starts the next invoice to start on 4th page but i want nex...
I have a question regarding the integration of business objects developed using Linq To Sql for data query and integrating with Sql Server Reporting Services. We have a set of business objects that query a couple of back end databases that is developed with Linq to SQL. The SQL that gets generated is relatively dynamic (based on the con...
Hi, How do i get rid of the page breaks in the the SSRS report, making the report display in a single page. Thanks in advance, anna ...