Hi, We are using Reporting Service(SSRS 2008) webservice(ReportingService2005.asmx, ReportingExecutionService2005.asmx) to export/Render the report into PDF format from Windows application. When exporting the huge amount of data contain report(Upto 10MB), then we are getting exception as "The underlying connection was closed: An unexpec...
What is the way to go to share a look and feel of a report among other reports in the same project? I want to share the layout, colors, etc. Thanks ...
Hi all, i deployed the Reports which i developed in local to DEV Reporting server ( i have the credentials to deploy in DEV). Now i want to generate the scripts which i deployed in DEV . Using Reporting services scripter tool generated the Windows command file but when i am double click on that it is always pointing to DEV server but ...
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager ...
I have a table with a group. I'm using a toggle item in the details group. If the user clicks in the header group the details are shown. I want to change the background color of the header group rows that have its details expanded. In other words, I want to change the property of a report item based on the status of a toggle item. Is t...
I have a report that displays beautifully onto the screen (print preview mode). If I try to export it to Word it works fine. If I try to do a PDF it fails. The field that causes the error is a multi-line field. If I filter our the TSQL code with REPLACE(fieldName, CHAR(10), '') AS fieldName everything works correctly but there are no ...
I want my textbox to have an action ONLY if the condition is true, otherwise no action. This is what I have as my current action expression for going to another report: =IIf(Fields!MyTextbox.Value = "0", "Report2","") This does not produce my desired result. It gives the textbox an action regardless of the condition result. Is there a ...
I'm new to SQL Server. how can I add the values of my Pie Chart to the Legend next to the Series fields? In this case I want the percentage. For example: United States 43.2% Canada 22% etc. ...
Hi All, I am creating a report from ssrs, and storing at local shared folder(MyReports) in excel format using data-driven subscription. It generates a report on scheduled time. But, I don't wanna create a report with zero records. How to stop SSRS to generate a report if no. of records is zero. Pls F1 me ... ! ...
I've some adhoc reports developed on some report models which are published on Report Server (we're using SSRS 2008). Everything is running well. Now in our production environment we've near about forty (40) customers who have their own database (each have the same table structures and other database objects). Now the challenge is whenev...
I have just installed SQL Server 2008 including Reporting Services on Windows Server 2003. I'm having a problem though accessing the Report Manager. When the Reporting Service is first started I can access it fine but after maybe an hour when I try and access it I get an error saying: Unable to connect to the remote server. The report...
Hi, I'm creating an SSRS report which contains a table of orders, grouped by day. Now I can easily get the max order value for the day and put it in the group header by using the SSRS MAX() function. However, I also want to get the corresponding customer name who placed this order, and place this in the group header too. We can assume...
How i can Export a report in SSRS 2008 / 2005 in text file. with proper allignment if it is possible by adding some code in Reporting then pls provide me that code . . its very urgent . . ...
Is there a possibility to set size of Report to fit on one page pragmatically. In excel there is option for page Scaling where We can set how many pages by tall and by wide is going to be printed . Does exists something analog in SSRS2008 ? I am using Sql Report Server 2008 and Ill try to do that by exporting report to excel and after...
I have a report where I'm counting the number of records for a day. At the bottom, I have the total records for that time period. I'd like to display the average records for each day. An example: I can accomplish this by aggregating the data by date in SQL then just doing the Average and Sum of the count from SQL, but that would co...
I am currently working with an SSRS 2008 report that returns a dataset similar to the following: Job# ClientId MoneyIn MoneyOut ------------------------------ 1 ABC123 10 25 1 ABC123 10 25 1 ABC123 5 25 2 XYZ123 25 50 2 XYZ123 25 50 3 XYZ123 15 15 Where MoneyOut shoul...
I Installed SSRS on my Win 7 Machine but I don't see it in my IIS website, and when i try to go to http://localhost/reportserver it asks for credentials which i put my admin account credentials and it doesn't work. Thanks, Marios ...
Does anyone have a slick way of adding filler dots to a table of contents page in RS? This would not be a problem were it using proportional fonts. e.g. Monkey.........5 House..........1 Tree...........11 Underpants.....2 Obviously the example above sucks as the font is proportional ...
I need to do this for a 'Table of Contents' (sub)report. Methinks it is not possible. Any ideas? e.g. Table 1 starts on page 2 Table 2 starts on page 7 Is there, perhaps, a way of tapping into the Document Map? ...
Does anyone know a way to prevent SSRS 2008 from sleeping, after not being used for a while (not sure of the time-out) it takes quite a while to wake up, which is causing a timeout issue? ...