rdl

How can I control the subreport layout?

My business analysts have created 7 reports (using Report Builder) they want merged into a MEGA-report. I've been trying to do this by wrapping them all in subreports (which you can't use in Report Builder 1.0). While all reports show up, the layouts are all over the place. The subreports seem to reorder themselves. I've dropped down to...

SSRS report page break problem

I need look at a problem with page breaks in an SSRS report, and I'm by no means an expert. This is in the XML mark up to provide a page break: <TableGroups> <TableGroup> <Grouping Name="AdjustmentPageBreakGroup"> <PageBreakAtEnd>true</PageBreakAtEnd> <GroupExpressions> <GroupExpression>=CInt(Ceiling(RowNumber(...

extracting RDL data using LINQ

I'm working with some SQL Report definition files (RDLs), using LINQ to extract component query statements for validation. I'm trying to extract the <DataSet> elements from under the <DataSets> element. I seem to be getting hung up with one of the elements under <DataSet><Fields><Field> which has a namespace qualifier <rd:TypeName> I've...

Localization of Reporting Services-Reports (.rdl / .rdlc-Files)

Hallo, i need to localize a Reporting Services-report (.rdlc) and i would like to do it using a ressource-file (.resx). I found pages like this and that and they use custom code to achieve their target. But pages like Setting the Report Language Parameter in a URL give me the impression that localization in reports is possible without c...

How to add group, or page field in an existing .rdl report

Hello. I have several .rdl reports designed for our client. However, they need new ones, that are relatively similar to the old ones. Differences are in the "group" and "page fields" (these can be changed easily). I'm interested in adding new group and page fields. I would like to copy/paste the old report, and then add new (group and ...

TFS2010 sprint rdl report

I'm evaluating tfs2010 and i'm actually in stuck with mdx rdl reporting. Where i could find some example about iteration query? (Sprint team capacity for example... ) ...

SSRS shared data source to SSAS and MDX query

I am trying to deploy reports that connect to an SSAS cube as a shared data source. The problem I'm having centers around that fact that even if I change the Initial Catalog in the SSAS connection string, all the MDX queries in the rdl files still reference the old SSAS cube by name. This is a particular problem because these cube names...

Is there a way to publish rdl reports programmatically with C#?

I have a solution file in BI that contains 10 report projects. I publish these projects manually with every change. I want to know that is there a solution to deploy these projects on report server programmatically? ...

Is there a way for printing a report without previewing it on report viewer?

I want to print a report (RDL) directly without previewing it. Is there a solution for this work? ...

deploy a reports project

I have a ReportsApplication and a WpfApplication. I Want Deploy Reports in ReportsApplication with WpfApplication. How can deploy a report in ReportsApplication with C# ? ...

How can I get a dataset to populate from an RDL file?

I have an RDL report file and I would like to somehow "run" the report and get the dataset that would be used to fill the report. What I'm trying to do is get a raw data extract from the data that would be used to fill the report, without actually showing the report to the user. Is this possible? ...

How can I generate a flat excel file from a .rdl report?

I have a .rdl report that formats data as a report. I want to export that data to excel as a flat table with the raw data that was returned based on the params in the report. The default excel export looks just like the report which isn't what I want (I just want rows and columns). Is there an easy way to do this? ...

RDL Renderer in WPF

All, Is there a third party application / open source etc that renders RDL (Report Definition Language) to WPF? We are not happy with the presentation Reporting Services provides so thinking of using the RDL and render it in WPF. Thanks, MK ...

SSRS 2005: How do I make available varbinary data for download in a report?

Hi, SSRS newbie question here... I have a table where one column is varbinary(max) data. I would like to make a report that makes this data available for download as a hyperlink so the user can just click on the item and get a file download dialog for the binary data. In this particular case, the binary data happens to be the content o...

Using fyiReporting in a medium trust host

Anyone knows if fyiReporting RDL reports require Full trust like RDLC or they can work in Medium trust? ...

How to layout this table in SSRS 2005

We have a report requirement that looks like the following: |=============================| |C1 | C2 | C3 | C4 | C5 | |=============================| | There | 0 | a | a | a | | | |----|----|----| | Is | | b | b | b | | | |----|----|----| | a lot | | c | c | c | | if data |----|----|-...

Does RDLC fire any events when binding to a datasource?

In Microsoft ReportViewer Web server control I have a report in RDLC that "binds" a table to a datasource. Are there any events fired that I can hook into on each cell/row so that I can programmatically set formatting properties for each row/cell in my c# code? ...

How to pass parameters to report model in Reporting Services

I'm developing report in RS that show top N customers based on some criteria. It also allows to select number of customers and period of time. Is it possible to do it by using report model? Thing that it seems to be difficult is how to pass parameters determined by user. Another thing that in my oppinion is very disappointing is that i...

Should MS Report Cache Files (*.rdl.data) be stored in Source Control?

Hi. I am working on a legacy application for a client, that uses Reporting Services. I have imported the project SVN repository, which includes a Reporting project and folder, setup in a Visual Studio Reporting solution/project. Included in this SVN folder (but not the VS solution/project) are .rdl*files (the actual report definitions)...

Dynamically re-order columns and set column width in an SSRS tablix

We have a grid on our application that we need to render as part of a report that will be rendered in SSRS. The user has the ability to change the order and sizes of the columns in this grid in the application. I now have the requirement to make the printed grid match the column order / column sizes at the time the report is rendered. ...