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

How do I set datasource to my rdl reports after deployment?

How do I set datasource to my rdl reports after deployment? Currently I have created 2 different data sources for 2 different clients. And specify that on rdl reports at the time of deployment. But how can I do this after deployment at runtime…
Neo
  • 15,491
  • 59
  • 215
  • 405
0
votes
1 answer

RDL report - Chart with both bar and lines

I want to show in one chart report two series of data, one as a horizontal bar and one as a line. When I select for the second series a line chart type, it changes also the chart type for the first series which was set to bars. This works if I'm…
mslliviu
  • 1,098
  • 2
  • 12
  • 30
0
votes
0 answers

How to make group of tables repeat according to the number of entries in table in rdl using fyiReporting designer

I am creating a new report and for this report I need to repeat group of tables per a record. For example The top few lines in the image are table records. thank you for your help in advance. Example input More detail out put
Terry
  • 75
  • 1
  • 9
0
votes
0 answers

Multiple sub-report based on dataset

I'm working in Report Builder with an .rdl file and i was wondering if it's possible to basically add my entire .rdl report as a Sub-Report of itself and based on results in a dataset run that sub-report once for each result. Something…
Nick G
  • 1,209
  • 8
  • 34
  • 58
0
votes
1 answer

How to Place an Image Behind A Tablix

I have 4 Tablices, there are always exactly two cells of data for each tablix, so there are only 8 Fields of data in total. My problem: when i try to place an Image behind those tablices the Tablices are rendered under the report, so in the upper…
Daniel Jawna
  • 339
  • 1
  • 3
  • 17
0
votes
1 answer

Report Expression to SUM [Column A] values for records with null/empty values in [Column B]

I am working on an existing SSRS report and have the following situation: It is working well and displays grouped data from a stored procedure A request has been made to SUM values of certain column(say Quantity) ONLY when values are empty/null in…
tinonetic
  • 7,751
  • 11
  • 54
  • 79
0
votes
1 answer

first time using SSRS web server, setting up website

its my first time using this and as a newbie I have many questions. Any help are appreciated. My ultimate goal is to have reports created from database that will be able to be accessed by other end users on website so they can view/filter the report…
willchye
  • 43
  • 13
0
votes
1 answer

Hide or Show textbox outside tablix

I am facing a critical problem in ssrs reporting. i have a textbox with value and tablix with no record. now i want to hide this textbox when tablix has not no row.here is my report
Shohel
  • 3,886
  • 4
  • 38
  • 75
0
votes
1 answer

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…
ZombieDev
  • 959
  • 1
  • 10
  • 25
0
votes
1 answer

Can I add HTML attributes to a ReportViewer's RDL/output?

We use ReportViewer to generate our reports. I'm attempting to automate checking reports. However, the HTML that is generated by the system is... both intense and difficult to navigate. Nested tables, no classes or IDs, that sort of thing. Is it…
XtinaS
  • 194
  • 3
  • 15
0
votes
2 answers

How to upload a .rdl report to CRM 2011

I have downloaded one of the system generated reports from CRM 2011, it saved as a .RDL file which I then opened and modified. My question is, how do I then upload the modified report back to CRM. I have tried using the report wizard and searching…
Lauren
  • 21
  • 2
  • 8
0
votes
1 answer

Generate a custom report with parameters

I have created a .RDL with ReportBuilder 3.0. This RDL contains a dataset and a datasource. The dataset has its own query. This RDL contains some parameters. What i want to do is: From a WPF application, take this RDL, put some data in the…
user2499088
  • 625
  • 1
  • 6
  • 12
0
votes
1 answer

embedding data in RDL report

i want to add reporting runtime capabilities to my software and have decided to go with RDL and local report viewer (WinForms) I have been reading several good HOW TOs (MSDN and gotreportviewer) and articles and i have successfully done the…
moshe
  • 37
  • 1
  • 9
0
votes
1 answer

How the report is being generated in rdl to other format like Excel or pdf?

Is it from the server or in the application? I am using the below line to Export from rdl. byte[] bytes = reportViewer.ServerReport.Render("EXCEL", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
S J Karthi
  • 51
  • 1
  • 6
0
votes
1 answer

How to convert .rpt file to .rdl file

I need to convert several .rpt file(crystal reports) to rdl files(ssrs reports). How to generate .rdl file dynamically? Is there any link that will provide all the list of formulas to convert ?
srinivasan
  • 39
  • 1
  • 1
  • 7