Questions tagged [rdl]

Report Definition Language (RDL) is a standard proposed by Microsoft for defining reports.

Report Definition Language (RDL) is a standard proposed by Microsoft for defining reports.

SQL Server RDL Specification

SQL Server 2005 Report Definition Language Documentation
SQL Server 2008 Report Definition Language Documentation
SQL Server 2008 R2 Report Definition Language Documentation
SQL Server 2012 Report Definition Language Documentation

489 questions
4
votes
2 answers

How do you insert a newline in an RDL Textbox?

How do you insert a newline in an RDL-2005 textbox definition ? Example: how to display FooNewline on a newline inside the textbox: ` Foo…
sthiers
  • 3,489
  • 5
  • 34
  • 47
4
votes
1 answer

RDL set page break

I am trying to set a page break on a sub report that is acting as a cover page. Does andybody out there know how to do this ? Right now, I stretch the height of the report to force the page break. I am using Visual Studio 2008 (SQL Server Business…
jeffreychi
  • 199
  • 3
  • 14
4
votes
2 answers

Dynamically store and send SSRS reports as PDF with C#

I have a report in SSRS that takes as a parameter a SalesRepCode and Email to generate a PDF receipt. It's working as it should be if I'm using the Report Viewer. With C#, I'd like to automatically generate a PDF for each SalesRep that exists, once…
gmwill934
  • 609
  • 1
  • 10
  • 27
4
votes
2 answers

Is it necessary to build/compile SSRS reports?

We have a 2008 R2 native installation of SSRS. I usually develop reports in one big visual studio report server project and manually upload the .rdl files via the front-end of the SSRS web site. However, I've noticed that you can build…
4
votes
1 answer

Tree diagram in rdl ssrs

I have a data set with following data : How can I display this in tree view in rdl. something like below or any form which can display in tree structure :
Sagar Dev Timilsina
  • 1,310
  • 15
  • 32
4
votes
1 answer

Changing properties for multiple fields at once in SSRS Designer

This is very similar to the post on Formatting multiple fields at once in RDL, but there are still issues with setting properties like Size.Width and Font.FontSize when the underlying data is different between selected cells. Here's the accepted…
KyleMit
  • 30,350
  • 66
  • 462
  • 664
4
votes
3 answers

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…
NotDan
  • 31,709
  • 36
  • 116
  • 156
4
votes
3 answers

How can I execute an .rdl report with a Report Viewer control without an SSRS server?

I'm trying to set up a web page where users can select an .rdl file to run, and it will open a Report Viewer control (ASPX), load the report definition file, run it, and display the report. So far, what I've found is, "local" reports can only accept…
qJake
  • 16,821
  • 17
  • 83
  • 135
3
votes
3 answers

Format number Rdlc report

i need to show numbers 1 2 3 in Arabic letters i write in text box expression this statement =FormatNumber(Fields!Size.Value,1,-2,-2,-2) but i don't know it's parameter and which parameter can show numbers in Arabic format MANY THANKS
3
votes
2 answers

How to center the report title in RDLC file

I am trying to center the report title placed within report header on RDLC matrix report - this should have been quite straight-forward but I am struggling to achieve it. I am using VS 2010 (SP1) report designer to edit the RDLC. The report is quite…
VinayC
  • 47,395
  • 5
  • 59
  • 72
3
votes
2 answers

Viewing .rdl files online

I am creating a report viewer which outputs the report definitions as .rdl files. These rdl files will be stored server-side. I don't have much experience in programming in .NET and was wondering how it would be possible for people to view these…
user559142
  • 12,279
  • 49
  • 116
  • 179
3
votes
1 answer

SSRS - Trying to pass lengthy parameters to a report and opening in a new window

I am trying to open a report (From a report which is RDL) in a new window by using the command: ="javascript:void(window.open('http://...¶m1=ddd¶m2=fff&.... This is working fine for less number of parameters. But,…
vivek murugan
  • 31
  • 1
  • 3
3
votes
1 answer

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
NabilS
  • 1,421
  • 1
  • 19
  • 31
3
votes
2 answers

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

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…
MariusCC
  • 617
  • 2
  • 6
  • 11
3
votes
0 answers

Correct rendering via Web, but rendered without evaluating expressions when using WinForms ReportViewer

I've got an issue where a .RDL report (remote processing) running on SSRS 2005 will render with expression evaluated when viewed via web…
1 2
3
32 33