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
0
votes
0 answers

SSRS Result on Multiple Value Parameters

I have an SSRS report that takes multiple valued parameter, when I try to generate the sp's with the multiple values, I get the desired result on the contrary when I'm on the SSRS env (test), even if I select multiple values, I only get the top row…
mirageservo
  • 2,387
  • 4
  • 22
  • 31
0
votes
2 answers

Applying CSS styles to RDL file

Is there any way to apply CSS styles to an SSRS rdl file ? Note: it's not necessary to BIDS, my main goal is to edit the rdl file regardless of the used tool. Thanks
Mostafa Moatassem
  • 351
  • 3
  • 11
  • 23
0
votes
1 answer

How can I add an embedded data source to RDL in C# code?

I am trying to use SSRS in a multi-tenant situation. The base version we want to support is SQL Server 2008 but if R2 is needed we might be ok with that. I am currently using the ReportingService2005.asmx endpoint which seems to expose the…
PilotBob
  • 3,107
  • 7
  • 35
  • 52
0
votes
1 answer

How do you place namespace alias on an XElement? How do you add a datasource to existing RDL document?

I am trying to create an XElement of a datasource to insert into an SSRS RDL file. However, I am unable to seem to get it to create correctly with respect to the rd: alias. Here is the code I am using. XNamespace rootNs =…
PilotBob
  • 3,107
  • 7
  • 35
  • 52
0
votes
2 answers

Report Header in Report Builder

I apologize if I am missing something obvious guys, but I am having a heck of a time figuring out how to add a report header (not page header) to a report. I want a header that shows up on the first page and only the first page. Again, I apologize…
CodeHulk
  • 111
  • 1
  • 12
0
votes
1 answer

RDL Expression for NULL date return #Error

Need some help on this, as mentioned above this part trouble me cause it will show the value as #Error if the value of date is NULL. It's ok if there is a date value but not if NULL. Argghhhhhhh.... I already couple of expression below but none of…
mutanic
  • 2,448
  • 1
  • 15
  • 17
0
votes
2 answers

Copyright symbol in rdlc reports

I want to print a copyright symbol in rdlc report textbox how to do that?
0
votes
1 answer

How to hide RDLC Table Column if no data is present in all the Rows with Expression?

I would like to hide the entire column including the header if all the rows under that is null or of no values with expression in an RDLC Report. I have tried the expression "=IIF(IsNothing(Fields!de_projectactivityidname.Value), True,…
Vinu
  • 347
  • 2
  • 7
  • 13
0
votes
3 answers

SSRS ReportViewer problems with XML embedded data source

I have C# (WPF) application where I want to display a SSRS report in the ReportViewer control. The local report file has XML datasource embedded in it. The report is displayed correctly when running from SQL Server Business Intelligence Development…
Marius Bancila
  • 16,053
  • 9
  • 49
  • 91
0
votes
2 answers

Is there a way to use datasets from custom assemblies to populate SSRS datasets?

I am tasked with converting some RDLC files to RDL that define their datasource with compiled VB.NET. Translating the code to TSQL is complicated for some of them, and it would be prudent to use the assemblies that are already developed if that is…
CVog
  • 1
  • 1
0
votes
1 answer

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 elements from under the element. I seem to be getting hung up with one of the…
BobC
  • 412
  • 1
  • 7
  • 20
0
votes
1 answer

Report: Incorrect Column Sum Total

I have created a tabular report that has a couple of drilldowns that are subtotaled at the top of each table group via the following…
Theo Kouzelis
  • 3,195
  • 5
  • 37
  • 66
0
votes
1 answer

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…
jwmiller5
  • 2,584
  • 1
  • 15
  • 34
0
votes
1 answer

reporting services, have two reports in rdl

I have a SSRS 2008 report that shows some information based on a start date. I would now like to add another instance of the report to the same rdl, with a different start date. How can I add a second instance of the same report to the rdl file? …
Craig
  • 1,277
  • 2
  • 16
  • 29
0
votes
2 answers

how to use rdl/rdlc in my asp.net project to generate a report?

I have a web application which will use MS ReportViewer. I have another team create a rdl file for me. I renamed the rdl to rdlc and added to my project. And I created a DataSet1.xsd to get the data needed by this rdlc. In my aspx page, I added a…
GLP
  • 3,441
  • 20
  • 59
  • 91