Parameter layout
I have four parameters in my report. Now I want to configure the report to show only one parameter in every line. In this case I want to have 4 parameter rows. Is this possible? ...
reportingservices-2005
SSRS 2005 How to Print 4" X 3" label as Portrait.. SSRS assumes Landscape
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...
Is there a workaround for placing placeholders in a textbox in SSRS2005
Does anyone know of a workaround for placing placeholders in a textbox in SSRS2005. I am stuck with SSRS2005 but need to insert database fields into specific places of a textbox containing other static text. ...
Is there a rendering provider for SSRS and Adobe Indesign
As a faint hope, does anyone know of an integration piece for SQL Server Reporting Services, such that we could use our Adobe Indesign templates? ...
SSRS access to child folders without having access to parent folder
i need to give contents manager rights to a user 'X' on a child folder in Reports Server. Do I have to give him Browser rights on root folder? Regards Manjot ...
SSRS 2005 - Printing report with matrix and a list gives blank pages every other page
Hi, I am using SQL Server Reporting Services 2005 (SSRS 2005) to build an A4 portrait report. This report contains some text data and a matrix placed on a list so a horizontal table effect is created (with the columns representing the various repeating fields). The problem I am encountering is that, when exporting the report to PDF (or ...
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 >...
Error in Visual Studio 2008 with SSRS 2005 report projects
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports. After an upgrade to VS2008 an existing ...
SSRS 2005 with matrix and list shows blank page between every data page when printing or exporting to PDF
Hi, I am using SQL Server Reporting Services 2005 - I have created a portrait A4 report 8.5in by 11in. The report consists of a header, body and a footer. The body consists of a number of textboxes in a 2 column layout and underneath them a matrix placed onto a list. The matrix consits of 2 fixed rows (with 1 fixed textual column i...
Execution 'iwy2vpzo52pmp555ftfn4455' cannot be found (rsExecutionNotFound)
Some users get the following error when running reports. • Execution 'iwy2vpzo52pmp555ftfn4455' cannot be found (rsExecutionNotFound) They run fine in the morning. Any suggestions? Thank you ...
Export SSRS 2005 report to Excel 2007
Is there any way to export a SSRS 2005 report to Excel 2007 (.xlsx) instead of Excel 2003 (.xls)? ...
How to link table row heights from two tables in SQL reporting services
I have two tables in a SQL Reporting Services report (table + matrix) that I would like to display side by side to give the illusion of one complete table. The problem is that there may be more data in the row of one table vs the other and therefore the rows could be different heights. Is there any way to match/link the heights of the...
How do I keep colors consistent from chart to chart in Reporting Services 2005?
I created a custom color palette for my charts using a technique described on TechNet. I also have a series of drill-through column charts, where you click on one column and it passes a parameter through to the next chart and so on, giving the appearance of drill-down. My graphs consist of 3 types of labor, and have three colors on the...
Why would System.Xml.Serialization.XmlSerializer be undefined in a SSRS 2005 report?
I'm trying to serialize a data structure and pass it to another report via parameter, and this line of code: Dim s As New System.Xml.Serialization.XmlSerializer(GetType(System.Collections.HashTable)) Produces this error: An error occurred during local report processing. The definition of the report '/myReport' is invalid. There i...
How do I execute a custom code function only once on a reporting services report?
I need to execute a custom code function when the report first loads, and I need it to only run once. Where do I put it? ...
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 ...
Force linebreak in VS05 SSRS textbox
In a VS05 SSRS report I have a field coming back from the database that I concatenated together. Ex: SELECT Field1 + ' ' + Field2 I'm wanting to show this in a single textbox on the report but with a line break between the two fields. I've tried: Field1 + '\r\n' + Field2 but of course, no luck. What special characters can I use ...
SSRS: How to show a percentage of overall total in a group header
I have a report that shows customer appointments, by sales rep for the past 3 months grouped by customer sector. In the Customer Sector group header, I want to show the percentage of the overall total of customers in this sector that the appointments represent. For example, my report shows that 6 appointments were made by John Smith fo...
viewstate in reporting services
I work as a consultant at a company that have around 30 reports in a reporting services 2005 server. All of the reports use around 10 parameters to change the data loaded into the report. The parameters is depending on eachother also. The problem is that the reports causes long loadtimes for booth changing parameter and processing/loadi...
SQL Server Reporting Services 2005 - How can I get the report to scale to one page wide when printing?
I have a report and it seems so insist on printing in portrait mode and splitting the report across two pages. How can I make the web version specify landscape automatically, and also have it scale to fit on one page? ...