This seems more of a SuperUser thing but I didn't see any Report Builder or SSRS tags there. Move if it's in the wrong place, please! When I create a report in Report Builder 2, I often have charts on top and then a table underneath. The problem I encounter is that some charts get shoved over to the right, seemingly due to the table w...
We use Intraweb for our Web Applications and also have been using ReportBuilder for reporting for our internal windows applications. We also have ExtraDevices which we've used to allow us to save our ReportBuilder reports as Excel files. Now, I am want to produce a report on our web applications as a PDF file. I have an example on h...
We are using Delphi 7 to develop database apps with advantage as a backend. Our system is usually installed on the windows server with the pcs acting as terminals. All the settings and database are on the server. we are having problems running our software on Citrix servers. In particular printing seems to be an issue. Both in select...
I am trying to set the bold style of a category axis label given a certain label value. I have added an expression to the style attribute of the label font in the category axis properties window. The expression doesn't evaluate. Here is an example of the expression I am trying to use: =IIF(Fields!FieldName.Value = "SomeValue", "Heavy"...
Hi, I am trying to use Report Builder (ver 9) as bundled with SQL Server 2005. I am able to select my data source from the report server, and load all the relevant entities associated with the data source fine. However when I try and navigate entities I am unable to view the entire list of entities again. There is no 'back or forward na...
I'm using Digital Metaphors ReportBuilder in Delphi 2007. I'd like to access the system date (the value of the now function in Delphi) using RAP, but get an undeclared identifier error when attempting to compile in the Report Builder designer. What is the best way to get the system date inside of RAP? ...
I'm trying to use a custom assembly in Report Builder 2.0. I have added the assembly to the report via Report Properties > References. When I try to call a public static method in the assembly, I get this message: 'ExtractTag' is not a member of 'ReportsClassLibrary.ReportsClassLibraryTools'. The expression I'm trying to use to c...
I've been trying to get a dropdown filter to work in Report Builder 2.0. One example of the functionality I would like is to be able to rollup money spent by state. The filter could effectively limit which states were brought back in the report. I've tried various things... the worst of which brought back an error and the report didn'...
I'm using SQL Server 2008 with Report Builder 2.0 to try and query data from a Sharepoint List, as described in this tutorial. The report is set up to use an XML data source with the connection string set to http://mySharepointSite/_vti_bin/lists.asmx. However, I cannot seem to get all the fields from the Sharepoint List, even if I spe...
I'm trying to use Report Builder 2.0 to query a Sharepoint List using an XML data source. I explicitly list the fields I want returned because otherwise I don't get all of them, due to some of them being null sometimes. However, one of the fields I need has a space in its name. If I do a query where I don't explicitly specify fields, ...
I'm opening ReportBuilder on an instance of SQL Reporting Services 2008 from within a WPF application. When I open it, I call it like this: string rptBuilderUrl = "http://localhost/ReportServer/ReportBuilder/ReportBuilder.application"; Process.Start(new ProcessStartInfo(rptBuilderUrl)); It opens OK, but it always fla...
In Report Builder 2.0, I'm trying to create a table with data like the following: Person | StrID's ------------------- Jim | a, b, c, d Mary | h, k Sue | l, m, p, z The problem is that my Oracle SQL query returns data in the following format: Person | StrID -------------- Jim | a Jim | b Jim | c Jim | d Mary | h...
I'm using SQL Server 2008 (non-R2) and trying to use Report Builder 3.0. When I try to connect to the report server, I get an error: Connection Failed. Unable to connect to the server that is specified in the URL...... However, I am using the same connection as my Report Builder 2.0 and that works fine. Can RB 3 not work with ...
I'm using Report Builder 2.0 to construct a report that contains datetime data stored in the database as UTC time. Is there a way to convert the UTC time to local time of the computer viewing the report? Thanks. ...
This is driving me nuts. I've looked at all the relevant MSDN tutorials but they talk about 'data field drop zones' and how a 'Add Calculated Series' menu option should be there but it's not, and no screenshot is provided to show what a 'data field drop zone' is. This is the menu I get when I "right-click on a field in the data field d...
Coldfusion Report Builder is great. One small issue. We use ANT+CFANT to deploy. When we create the report, say in a datasource called MyApp_dev on a dev box. Our other server is the production server. It also contains a staging build to ensure everything is going smoothly before we publish to live. (thanks to Al Everett for bringi...
I created a report with a sub-report but not every line in the main report has something in the sub-report. So when it prints the empty sub-report prints a blank line. How do I get rid of the blank lines? ...
Hello, I have been using Report Builder 2.0 for a little time now and I can't seem to get Interactive sorting to work on a matrix header. Here is a first image of the report design: ReportDesign The final report should look something like this: [FinalReport] The TextBoxProperties window of [Importanta] looks something like this [TextBoxP...
I've got a report in ReportBuilder that's supposed to report on two objects. I didn't create this report, and I can't ask the person who did about how it works. Before running the report, we have some code that goes through, finds all the properties on the objects, and loads them into a memory dataset that looks like this: OBJECT_ID: ...
I am developing reports using report builder2.0, in these I am facing a pagination problem like, one report is in portrait and other is in Landscape. Regarding the page breaks in the report, how to handle the sub-reports being in a different orientation than the main report (Portrait vs Landscape). Is there any way that I can accommod...