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

SSRS - How to autorefresh to the next page multiple pages report

I have a SSRS report that has 4 pages. I want it to refresh to the next page every x seconds. When it reaches last page, then report should loop back to the first page. I have sql server 2008
BI Dude
  • 1,842
  • 5
  • 37
  • 67
0
votes
1 answer

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.
agnieszka
  • 14,897
  • 30
  • 95
  • 113
0
votes
2 answers

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…
osij2is
  • 1,546
  • 3
  • 12
  • 21
0
votes
1 answer

RDLC : No page break - four sub reports within table/tablix

I have a situation where i have to display four reports based on checkboxes. So user can select different combination from four reports. My problem is page breaks. I have tried different options (see below) from which two options (option 1 and 2)…
Ali Faraz
  • 31
  • 1
  • 5
0
votes
1 answer

SSRS report - Group by on Date Part of a Datetime field

I am working on a SSRS report that displays Date, Time and few other columns. My SP returns just Date Column (which has time part in it) and a few other columns. In the report I want to group by Date Part and show all details including the time (I…
user173552
  • 1,169
  • 2
  • 12
  • 13
0
votes
1 answer

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…
Arnaud Alike
0
votes
1 answer

How to format a number cell in RDLC Report

I want to remove the decimal part of a number in a cell but when I set decimal seperator to "0", it also rounds the number. What I want is if my number is 3.99 I would like to see it 3 but it rounds it to 4. Is there a way to do it? Thanks
facot
  • 221
  • 3
  • 7
  • 12
-1
votes
1 answer

SQL Function for FullText search doesn't return results on first run

I have a pretty extensive SQL Server query setup that performs the following functions. For each RDL report in our system (RDL is stored in a table as binary), I extract the CommandText from each dataset and store it in a table as VARCHAR(MAX). I…
svenGUTT
  • 399
  • 4
  • 11
-1
votes
1 answer

Profit and loss with cost to carry report: Preference to show / not show symbol level information

We need the below enhancement in the "Profit and Loss Cost to Carry" Report Right now when we group this report by selecting any parameter say Account, Asset, Custom UDA 1, etc then automatically Symbol level information also comes. But here we…
Yash
  • 1
  • 1
-1
votes
1 answer

How can I add Bar code 39 to my RDL report

I am trying to add barcode 39 to my item number using Microsoft Report Builder. I am not sure about the code to get it work
EAA
  • 1
-1
votes
1 answer

Using RDL reports in Query Designer

Novice here, but I have a main RDL report and in the query designer I wish to reference another RDL report in the query designer is that even possible?
-1
votes
1 answer

Building an rdl in Visual Studio 2015 is removing line breaks from my xml code

I'm building RDL files in Visual Studio 2015 for 2008 R2 Schema and the files output in bin\debug don't have line breaks in the XML. It's all one giant line which makes it a pain for people to read. Is there some setting that I'm missing to prevent…
Darrell A
  • 1
  • 2
-1
votes
1 answer

How to write an script to transform multiple RDL files into multiple XML files in python?

XML[XML] I have "rdl.bat" which is used to transform RDL into XML in case of single file, I want to know about multiple files. here is the link of rdlack.imgur.com/s6om4.png
-1
votes
1 answer

How can I prevent column A from being almost completely hidden in a Report Services report when it is exported to Excel?

I am making some changes to a legacy report (read: not created by me or anyone still here), and one of the requirements is to "Unhide Column A" And yes, when I run the report and export it to Excel, column A is almost completely obscured: When I…
-1
votes
1 answer

Java API for RDL(.rdl) files

I have some .rdl files with me. I want to if there is any specific java API to parse. I searched over the internet but could not find. Please suggest.
1 2 3
32
33