Stack Overflow
Stack Overflow

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
2
votes
1 answer

How do I hide a matrix column?

I have a matrix in SSRS 2008R2. It has the following features: 2 Row Groups (X,Y from let to right as you look at the report) 1 Column Group (Date) Y is toggled via X; and when first rendered Y groups will not be visible I'd like all column Y to…
whytheq
  • 34,466
  • 65
  • 172
  • 267
2
votes
1 answer

Hidding toolbar for reports created using SSRS 2008 in CRM 2011

I have created report in SSRS 2008 and have attached them to the dashboard. The report is displaying fine, except for the fact that about 15-20 % of the space gets occupied by SSRS menu toolbar which has options for printing/zooming etc. Is there a…
Venkatesh
  • 21
  • 1
  • 3
2
votes
0 answers

XML field Manipulation in an RDL report

I'm rendering a report using an SSRS RDL (GreatestAxemenReport.rdl). The RDL populates by calling a sproc (usp_SelectGreatestAxemenReportingData). Well the key information I care about is in a field of XML type in my table…
tMole
  • 41
  • 3
2
votes
1 answer

Rounding to nearest 0.5 in SSRS reporting .rdl

I am trying to round to the nearest 0.5 half. HELP.....I am going round in circles!! I am adding 4 numbers together and dividing the total to give me the nearest 0.5; Example: (5+4+4+4) = 17 / 4 result is 4.25. I want this to show as 4.5 but this…
SQLNew 2021
  • 23
  • 3
2
votes
2 answers

This code give an error for record which doesn't have value in the field but give a good result for those which have value in the field

I want to retrieve data from Microsoft Dynamics CRM 365 for SSRS. So I made a link between visual studio and the CRM to prepare a RDL file to import it in the CRM. The RDL file will permit to generate the report directly on the CRM. So, I work on…
bosskay972
  • 890
  • 1
  • 6
  • 27
2
votes
1 answer

How to use custom utility classes in RDL?

how do you use your own utility classes (those you use in application code) in Microsoft reporting in local mode? Is it even possible? I have read some specification and there are some elements that indicate it can be done but it is not really clear…
Amy West
  • 163
  • 8
2
votes
0 answers

Changing SSRS report to target older SQL Server version only changes rdl file in the bin folder, BAD FORMATTING

VS2017 initially built the report targeting SQL Server 2016 but we only use 2008 currently. When I change the properties to target an older version of SQL Server it appears to only alter the rdl file in the bin folder after the report is built but…
Trad
  • 15
  • 4
2
votes
0 answers

SSRS Export to Word with Heading 1 Style

I have a textbox in SSRS report to which I need to apply style of MS Word. Basically on Export the text in the Text box should have heading 1 style. I referred Applying Style Properties to Report Items…
Akshay G
  • 2,070
  • 1
  • 15
  • 33
2
votes
1 answer

C# Winform - How to display real time reports by passing 3 variables to ReportViewer namely Reportname(RDL file), SQLstring and Connectionstring

What is the most elegant way to pass RDL file, SQL and Connection string to ReportViewer Control on Winform C# project for displaying report at run time. Introduction: I recently started working on Report creation on Windows. I found that RDLC…
Ganesh Kamath - 'Code Frenzy'
  • 5,094
  • 3
  • 43
  • 60
2
votes
2 answers

Howto create or change SSRS2016 default palettes?

I need to define my company-branded color palette for SSRS. This should be re-usable over several reports. I realized that I sometimes need to redefine the custom palette again and again, sometimes even on different controls in the same report, but…
Magier
  • 437
  • 1
  • 6
  • 18
2
votes
1 answer

SSRS Report scrolling issue

When scrolling down through a recently deployed SSRS report, the columns become jumbled and I am unable to scroll all the way to the bottom. I have adjusted the zoom of my browser but this has no effect. The attached screen shot is what my report…
Istaley
  • 359
  • 1
  • 6
  • 24
2
votes
1 answer

directly export to pdf from ssrs viewer in asp.net mvc 5

I have ssrs report viewer url and tried directly convert to pdf : http://someIP/Reports_Server/Pages/Report.aspx?ItemPath=%2fReport+Folder%2fReport+Name&Parameter=parametervalue&rs:Command=Render&rs:Format=PDF If I tried to access it in browser, it…
Prast
  • 41
  • 1
  • 7
2
votes
1 answer

"lookup" function of RDLC report isn't work in this case

I have three related three dataset like these I need to display "INVOICE_CODE" from DatasetA concatenate with "COUNTRY_NAME" from DatasetC Example : "INV123-Korea" I tried to use "Lookup" function by this step 1.) First table is used for main…
Fame th
  • 1,018
  • 3
  • 17
  • 37
2
votes
2 answers

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…
Jack Bolding
  • 3,801
  • 3
  • 39
  • 44
2
votes
1 answer

ReportViewer & SSRS RDL Right-to-Left Export

I am working on an ASP.Net project where we use SSRS RDL reports with the ReportViewer control. The project is in Arabic language so the layout should be right to left. I managed to display right to left reports in the ReportViewer using CSS…
Karim AG
  • 2,166
  • 15
  • 29
1 2 3
…
32 33