rdl

Web designer for VS.NET ReportViewer

Is there any designer for rdl files (visual studio .net reports) that can be used on a web browser? ...

Hiding Subreports in SQL Report (RDL)

I have a bunch a reports that are printed out and mailed to clients. At the top of the report is the return address, left aligned. I was asked to add an optional logo to the report. This logo should be left of the return address. (The logo and all other info is stored in the database). So if the logo exists, you SHOULD see: <someimage> ...

Checking Reports against a changing Data Model

I am working on a SharePoint application where the data is kept in lists. For ease of reporting, we create views in SQL Server 2005 that link lists together, and our Reporting Services model is based on these views. As users add/modify/delete fields, our views become stale. When we recreate the views, some reports are no longer valid. ...

SSRS - OutOf MemoryException - is there a limit to the number of rows that can be displayed

I have created an rdl doc that points at a proc that returns 90 000 rows and I am getting an out of memory exception. Is there a limit to how many rows the report projects can handle? Currently I have changed the proc that drives my report to just do a select Top 90 000. My specs are to be able to create a report with 120 000 rows. M...

Using an ASP.NET server control in a sql server 2005 reporting .rdl file

How would I embed a ASP.NET server control on a SQL Server 2005 Reporting file (.rdl)? I am using the design view to accomplish my task? ...

Upgrading Reporting Services RLD 2005 --> 2008

I ran the solution conversion for a bunch of reports I maintain, but a handful (about half a dozen) failed to convert. I managed to convert some by hand, but some are different enough that changing the RDL by hand is difficult. Is there a better way to fix these reports? ...

how to highlight the rdl projects xml view in VS2003?

i never worked with Reporting Services in the past and i notice that the XML view of the Rdl projects does not offer a syntax highlighting in VS2003 its all plain text does someone knows how to enable this? Thanks, Oscar ...

SQL Reporting Services 2005 - How to get current date as a ReportParameter

Hi all, I have some working reports that must be deployed on SSRS. One more customization that I want to be added is to automatically select the FromDate as today - 1 month, and ToDate as today. Specifically, I want to replace the fragment bellow with a piece that accomplish the requirements above: <ReportParameter Name="FromDate"> ...

Process rdl/rdlc report files without SSRS?

Is there any way to render and export an rdl file within a batch process without using SSRS? I don't want the overhead of SSRS (IIS + database) and instead want to handle this within my own batch/scheduling service. Thanks ...

Where does a published RDL file sit?

Hi, When publishing a reporting services report. Where does the actual .RDL file sit on the server? I can redownload the .RDL file via browsing through the report manager? But where is this file situated on the reporting services server? Thanks ...

How to convert a RDL to RDLC file with a different schema?

I'm using Sql Server Reporting Services (SSRS) 2008 to create RDL files, but also need to create a RDLC file. The problem is that SSRS 2008 uses a 2008 schema, while Visual Studio 2008 uses the 2005 schema. Is there a tool or work around for this solution? Note: I'm not using tablix, so that should not be a problem. ...

When to use RDLC over RDL reports?

I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main difference between RDL and RDLC. Searching for this information yields fragmented information ...

In Reporting Services 2008 on.rdl files, does the Report Builder and VisualStudio are equivalent ?

Working on Reporting Services 2008 on .rdl files. I have the choice to work with VisualStudio2008 or the application "Report Builder" ? Do they provide same fonctionnalities ? Can I switch from one to other without any issue ? What application do you prefer ? Thanks ...

Passing parameters between reports in SSRS 2005

I'm relatively new to SSRS 2005. I've built simple reports, and spreadsheets but I'm just beginning to delve into the world of fun that is SSRS/RDL. I'm trying to pass one (custom/non-query) parameter from one report (*.rdl) to another. While logically I would like to add a global variable, there doesn't seem to be any straightforward me...

How to display data from two databases in RDL report?

I'm creating a report that will take some data from one database (Company and list of Customer for every Company) and some data connected to it from other database (list of Item for every Customer). It seems that displayed data can only use one DataSource and that a DataSource is a connection to one database. I did some googling and read...

Hardcode reporting services credentials to view reports on asp.net site without prompt.

Can I provide somewhere credentials to use for viewing some report? It is a .rdl report viewed in reportViewer control on asp.net website. ...

Resizing .rdl report inside ReportViewer control in ASP.NET.

My .rdl report has columns of a fixed size and in preview mode of bi dev studio it looks ok. When viewed in ReportViewer control on asp.net site it shrinks. How can I make it always fill the size of the reportViewer control? ...

Editing RDL files with Visual Studio 2008

Hi, I have installed SQL Server 2008 Express on two workstations. On one workstation, it has updated the VS2008 installation so that I can create reporting projects containing reports as *.rdl files. On the other workstations, VS2008 can only create/edit *.rdlc files. The report edition interface is also different. I do not understand ...

Cleaning Up Temporary SSRS Reports

Our application uses SQL Server Reporting Services and allows users to add custom filters to reports. We do this by modifying the RDL and then uploading the modified RDL to the server to create a new report. The problem is that after the report has run once, it's no longer needed; it's really just a temporary report. Obviously, this woul...

Can you reorder columns in Report designer (bids 2005)

I have a reporting service report and I can't seem to figure out how to reorder the columns in the table control. Is this possible with editing the rdl file directly? ...