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

SSRS report - export to excel date time filteration

Populating an SSRS report from dyanmic dataset i.e. number column and order of columns may vary based on condition, and this report on trying to export to excel. But in exporting date column filtration not working. Finds the reason is I bind the…
Jithin
  • 31
  • 3
3
votes
4 answers

How do Microsoft reports (RDL) query the data?

I am not creating RDL from scratch so maybe this is a problem -- I work on already prepared files. MSDN states that CommandText in RDL file can contain T-SQL query. Ok, this I understand, but what else it can contains? I am asking because the…
greenoldman
  • 16,895
  • 26
  • 119
  • 185
3
votes
1 answer

Why would an SSRS report produce different data when run from SQL Server Reporting Services than when run using the Preview tab?

I've got a report running the data I want - from the Preview tab, that is, or when run using F5 in VS 2010. But when I upload the report (.rdl file) to SQL Server Reporting Services, and run the updated report from there, it still shows the old…
3
votes
2 answers

Formatting multiple fields at once in RDL or RDLC

Over the years, I've been working with SSRS reports (RDL and RDLC) but I have not found a solution to this problem: Let's say I have x number of fields in my report. I would like to highlight all the fields at once and modify the…
warriorpostman
  • 2,268
  • 2
  • 16
  • 26
3
votes
2 answers

How to resize image if the image is bigger than Textbox.But it not increase scale if smaller

I created RDLC report layouts by using Visual Studio Report Designer. I need to display image on textbox. The image was set center align by Chris Hays 's method. But This method must set sizing to be "Clip" So It has a problem because when…
Fame th
  • 1,018
  • 3
  • 17
  • 37
3
votes
1 answer

Hide/Show tablix row based on subreport results

is it possible for me to hide/show a row in a tablix that contains a subreport based on the resultset count of the subreport? basically, if there is no results in the subreport than don't display the row that it lives in.
Nick G
  • 1,209
  • 8
  • 34
  • 58
3
votes
2 answers

How to add current time in rdl?

How to add Current Time in Rdl report SSRS. Please any one help me... I am using Date for =DateAdd("m", -1, Now) but for Time only?
Sumanta
  • 313
  • 2
  • 6
  • 17
3
votes
1 answer

How to programatically execute and export .rdl file to pdf without any SSRS and reportviewer

There are more examples on rendering a rdl file to reportviewer and then showing it in .pdf format.I need to built a console application that takes a .rdl as input and executes it to a pdf. How can i do this without using SSRS and reportviewer?
3
votes
3 answers

Localization of Reporting Services-Reports (.rdl / .rdlc-Files)

i need to localize a Reporting Services-report (.rdlc) and i would like to do it using a ressource-file (.resx). I found pages like this and that and they use custom code to achieve their target. But pages like Setting the Report Language Parameter…
user4531
  • 2,525
  • 7
  • 30
  • 38
3
votes
1 answer

Editing RDL files with Visual Studio 2008

I have installed SQL Server 2008 Express on two workstations. On one workstation, it has updated the VS2008 installation so that I can create reporting projects containing reports as *.rdl files. On the other workstations, VS2008 can only…
Xavier Poinas
  • 19,377
  • 14
  • 63
  • 95
3
votes
2 answers

SSRS Adding text box that accepts input for printing

Using Business Intelligence Development Studio, I am creating a report for SSRS that requires the user to add a few notes before being printed. The notes do not need to be sent back to the SQL Server that the report is being generated from, they…
Luke Wyatt
  • 1,126
  • 2
  • 12
  • 23
3
votes
2 answers

How can I merge rows (of a particular column) having the same value in SQL Server Reports RDL?

I'm new to working with SQL Server 2005 Reporting Servives using RDLs in BIDS. I need to modify an existing report so that I can merge cells in adjacent rows which would have the same value for that particular column. Ex: consider this is the table…
Tx36
  • 506
  • 2
  • 6
  • 7
3
votes
1 answer

In SSRS report manager can not see New folder, new dat source, upload file etc. options?

I am trying to use report manager to deploy report. I am newbie on SSRS. When i opened report manager URL i see something like this. So I could not find any way to upload rdl/create dataset etc. When I googled I got following image. Here there…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
3
votes
2 answers

How to convert a RDL to RDLC file with a different schema?

I'm using Sql Server Reporting Services (SSRS) 2008 to create RDL files, but also need to create a RDLC file. The problem is that SSRS 2008 uses a 2008 schema, while Visual Studio 2008 uses the 2005 schema. Is there a tool or work around for this…
avgbody
  • 1,382
  • 3
  • 15
  • 31
2
votes
1 answer

Is there a new version of RDL Schema for SQL Server 2012 (denali)?

All previous versions of SQL Server (including Reporting Services) introduced new RDL schema, which was not supported by current version of report viewer control (included in Visual Studio). Is it true also for version 2012? For example SQL server…
IvanH
  • 5,039
  • 14
  • 60
  • 81