I set out today with the intent to parse an SSRS RDL file (XML) using Python in order to gather the DataSet and Query data. A recent project has me back tracking on a variety of reports and data sources with the intention of consolidating and cleaning up what we have published. I was able to use this script to create a CSV file with th...
I was wondering if there anyway to manipulate the position and size of the text boxes for the parameters in SSRS 2005. They generally take up a large part of the top of the page and I want to prevent that if possible. ...
I have a line chart with two lines in it. Sometimes the values between them differ by a hundred or more. That leaves the bottom line looking very flat. I want both of these to remain on the same graph but is there a way to have a different scale for each line? I was told that it is possible to have one (scale) on the left and one on ...
While using reporting services in share Point Integrated mode, it throws error that reporting services cant be used in this version of SQLEXPRESS ADVANCED. I am currently using SQL Server 2008 R2 edition which supports Reporting services and it is also written that it supports SYNCING with Office Servers. I am confused now on which SQL v...
In my report I display a record from a table of my database. One of my columns has data formated as html. I want to display this as rendered html. So <b>nice header</b> should render nice header Can I do this in a report? ...
I use ReportViewer web server control on a web page. The goal is to have a page that will allow anonymous access. I'm creating a dummy FormsAuthentication cookie that expires in 5 seconds and try to call the report. I also derive from IReportServerCredential and pass in Domain administrator's credentials to the report server. Weird thing...
I need to have an optional parameter or a parameter that's default value is null. I want to use a dropdown list for a report, the list is getting it's values from another dataset. I have selected the option to allow NULL values. I have tried setting the default value to null and all the other settings available. Is there some way to ma...
I have two entities (A and B) which share a common key, but aren't related by primary/foreign key in the database. I have created a logical relationship between the two in the data source view, and a matching role in a model. The cardinality of the role is "OptionalMany to OptionalMany" since none of the columns are marked as unique in t...
Hi All, I have installed Visual Web Developer Express 2010, and SQL Server 2008 R2 Express with advanced services. How can I write reports to use with reporting services? Do I need to install Visual Studio C# Express 2010 for instance? Thanks. ...
I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space. I'm on SQL 2008 and Windows Server 2008 R2 Standard. Any ideas how to fix? I've confirmed that I am logged in as a local administrator. I tried adding the URL to trusted sites but that didn't seem to help eith...
I've connected to a SharePoint list using SSRS with this query. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>{4...
Our company has a huge nasty report that takes about 50-60 minutes to run (it's for a university and lists all sorts of payment information for all students registered in courses). While it has been running each morning at 5am as a subscription, it recently stopped working and displays "An error has occurred during report processing." in...
I am using Visual Studio 2005. I have a stored procedure that retuns all the data, the dataset on the data tab of reporting service returns all the data, but the matrix in the report doesn't. it looks like it is pulling all of the data but the last 3 sites. is there a setting i need to adjust to get it to show all of the data? and not...
I have several parameters on an SSRS report. There are two groups of these parameters. One group is report specific, the other group is data specific. I would like to be able to seperate these two groups of paramaters for ease of use. Is it possible to introduce formatting into the Parameters section of an SSRS report? Thanks ...
Hi, I have the error while executing the reporting on the following line on the prerendercomplete event: ReportViewer1.ServerReport.ReportServerUrl = new Uri(@"http://localhost/ReportServer"); can anyone please help? ...
I am working on a reporting project, and the client currently makes use of MS Reporting Services 2000, and I am developing using Reporting Services 2005. What are the differences between RDLs in Reporting Services 2000 vs 2005? The RDL is just an XML file, and the difference's I've picked up so far are: XML Namespace in root element:...
Hi, I want to create a graph that looks like the one mentioned in the below image. For sample graph, please visit http://i29.tinypic.com/2r3w3o2.png How can I create a chart like this? ...
Is there a way to make a single field in SSRS have half bold and half normal text? Making it 2 fields is not an option. Thanks SSRS 2005 ...
Consider the scenario of a user creating a new Team Project. The user is a developer who wants to create and manage their Team Project. Why can't this user create a new Team Project, including the Reporting Services components? What can be done to resolve this error? The exception is TF218027: the following reporting folder could...
I cannot render an excel file for download correctly using SSRS SDK for PHP. I can for a CSV, and I can render one for PDF inline. The contents of produced file is garbage when viewed in EXCEL. Here is my code: $renderAs = new RenderAsEXCEL(); $result = $ssrs_report->Render2($renderAs, PageCountModeEnum::$Estimate, ...