reportbuilder

Report Builder alternate row group background

I know how to alternate the background color of individual rows in a Report Builder 2.0 table, but what I want is to have all rows within a row group to have the same background color, and I want that color to alternate with row groups. --------------------------------------------------------- group 1 | row 1 in group 1 - white backgrou...

Numbered list in Report Builder export to word

I have created a SQL Server Reporting Services Report Builder 3 report that contains a list of several items from a SharePoint list. I would like the list on the report to be a numbered list, so that when exported to Word, if a user adds another item to the document, the numbering is updated automatically. I can simulate a numbered lis...

inconsistent TablixHeader.Size in Report Builder 2

I get this nonsensical error seemingly randomly in Report Builder 2.0. Does anyone know why it comes up or how I can get rid of it? The TablixRowHierarchy in tablix 'Tablix1' contains an inconsistent TablixHeader.Size in one or more of the TablixMembers that contain headers for TablixRow 2. TablixRow 2 has an expected total header s...

Obtaining the SQL Server 2005 Report Builder XSD

I've managed to obtain the report definition schema for SQL Server 2005, but cannot find the xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" schema anywhere. Is it part of the 2005 install buried somewhere? The reason I ask is because I've recently started writing RDL files for SQL Reporting Services. I'd lik...

Can't display secondary category axis labels in Report Builder 2.0.

Most property settings are the same for the primary and secondary category axes. Interval: Interval=1, IntervalType=Months. Labels: HideLabels=False. However, Scale maximum and minimums are different: Primary: Maximum=Parameters!EndDate.Value Primary: Minimum=Parameters!StartDate.Value Secondary: Maximum= IIf( Parameters!StartDateB...

Need a way to restrict the reports that can be run when ReportBuilder launches from a web application

Hi, We have a web application that launches ReportBuilder by simply calling ReportBuilder.application and connecting using SQL Server credentials. Unfortunately, this means that everyone who launches the application from the web app can run any report. We need a way of restricting the reports that can be run after ReportBuilder launch...

help convert this SOAP request to Report Builder 2.0 query for XML data source

I have a complex parameter to a web method in my .NET web service, and I want to query that web method with Report Builder 2.0 using SOAP. With soapUI, I get the following SOAP request for that web method: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:qcr="MyNamespace"> <soapenv:Header/> <soape...

ReportBuilder 2.0 creating dynamic tables

I was wondering... In C# you can have a checkbox's and foreach checkbox checked you could do something like create a HTML table and populate foreach box checked.... i want to do the same thing in reportbuilder 2.0 on user selection of projects to create tables and fill foreach project (at a more basic level) if i could just create a...

SQL Server Report Services Premisson

I am currently looking into developing and designing the Report service system for work. My user does not seem to have access to Report Builder etc. I have given access to the below roles, but all I can seem to do is view report, create new folders and upload. Browser Content Manager My Reports Publisher Report Builder Does anyone k...

REP-1216 | print condition error

i face this problem in oracle Report Builder REP-1216 anybody can explain ?? ...

Passing Database Server To Digital Metaphors Report Builder Server

I'm using Report Builder (Server) to run my reports. We currently host the component in a windows service, now the web tier we have is passing some information through to the server, the usual stuff like the report to run etc, but also the database server on which to run the report. We seem to be able to pick up these properties in t...

Issue with ftCurrency fields with ADODatasets

Hello I have an accuracy problem with a reporting tool that I'm using. The issue is that it is reading in data from a TADODataset on the fly but converting the ftBCD fields into doubles. This causes rounding errors when performing operations at the reporting level (sums, etc). I'd like to specify my currency fields as ftCurrency, not ...

Report Model Inefficiencies. Need Advice.

I'm trying to help my power users have more access to our data so I don't have to interrupt my work (playing Pac-Man) 25 times a day writing Ad Hoc Queries and such. I'm trying to use Data Source Views, Data Models, and Report Builder 2 and 3 to allow them to have access to cleansed data in which they can safely do their own basic anal...

restore deleted y-axis

Is there a way to add the y-axis back to a bar chart if it has been deleted? Right now, all I have found to do is create a new chart and set it up again like my other chart, just not deleting the y-axis. :/ I'm using Report Builder 2.0. ...

Is there a way to specify a sort for a query in Report Builder 3.0, not using Edit as Text?

In Report Builder 3.0, you can open a report, or a query. When you open up a query, you're in a full-screen visual query designer. I cannot figure out how to indicate that I want to sort columns in this designer. There is an "Edit as Text" mode. When I go in there, it shows the SQL statement. I can add an ORDER BY clause at the end...

What causes the lens button to appear in the Report Builder Preview window? (Delphi)

This is a Delphi question on the usage of the ReportBuilder component by Digital Metaphors. I have a Report (created by the end userm using RAP and DADE) with autosearch Parameters. Anyway I am using "modify SQL" in the dataviews, so to pass the parameter I use the :Parameter syntax. (instead of using the query designer Search condition...

Report Builder 3.0 Limitations

Hi, I am building an application and the client is asking for reports. Normally we would create the reports for them using reporting services. We are wanting to give the client report builder and let them build there own reports. Some of these reports can be complex and I am not 100% sure how far report builder will take us. Before we ...

SSRS Report Builder

I would like to know in order to use the Report Builder at the user system, What kind of licencing model we require, If we have one SSRS server (SQL Server licence) and all the users can download report builder? What is the licencing model to use the Report Builder? It is SQL 2008 ...

Report creating problem

Hi stackoverflow comunity. I'm using report builder 3.0 and i need to put two textboxes in the same line in table cell, but the problem is when there is too much text in textbox1 it grows in height, but i need i widht. You can say that i can use placeholder to do the trick, but I can't use placeholder to hold the text of textbox2 in firs...