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

Required Parameter (*) in SSRS Report

I am looking for ideas as to how can we have a (*) sign on a required report parameter (SSRS). One quick idea that comes is to add this symbol in the label itself, is there any parameter setting that enables us to do this? PS: Apologies if this…
Piyush
  • 886
  • 3
  • 9
  • 28
0
votes
2 answers

mdx crossjoin over dimention hierarchy with granular measures results in duplicate statistics of Reporting Services data set

I'v built a SSRS revenue report in Visual Studio 2005 over SSAS 2008 R2 Qube data source for deployment on MS SharePoint 2005 Server. It runs fine (in rus.): (oops, can not post image below 10 points reputation) But the problem is that report's mdx…
Globe
  • 280
  • 2
  • 15
0
votes
1 answer

Printing SSRS graph report on multiple pages

I have graph report that is printing a lot of data on X axis. The output from the report is not adequate, there is not enough space between two points. For example if there 20 points to be displayed on one page, user can not see complete caption,…
Goran Strezoski
  • 1
0
votes
2 answers

How to pass parameters to report model in Reporting Services

I'm developing report in RS that show top N customers based on some criteria. It also allows to select number of customers and period of time. Is it possible to do it by using report model? Thing that it seems to be difficult is how to pass…
savras
  • 41
  • 2
0
votes
1 answer

Does RDLC fire any events when binding to a datasource?

In Microsoft ReportViewer Web server control I have a report in RDLC that "binds" a table to a datasource. Are there any events fired that I can hook into on each cell/row so that I can programmatically set formatting properties for each row/cell in…
Matthew Lock
  • 13,144
  • 12
  • 92
  • 130
0
votes
1 answer

Pagination In RDL

I am facing the pagination issues in RDL generation. My report is showing 7 pages in RDL but actually the records are coming upto 4 pages. 5th, 6th and 7th pages are coming blank. I have done some research and found that there is a property…
Garvit Gupta
  • 189
  • 1
  • 5
  • 15
0
votes
1 answer

RDL report - change of header text in CSV export by parameter

I am working on rdl reports and as I had to add multilingual support, I need to be able to change the column headers' text by the selected language parameter. I added this very basic custom expression to the…
Daniel
  • 153
  • 3
  • 16
0
votes
1 answer

SSRS How to Extend a Tablix till the End of the Page?

I am working on a Purchase Order report. now there is a requirement that totals and department name, manager signature etc should come at the bottom of the page. In SSRS it seems to be impossible to attain such a design. Things i have tried Put…
Ali Umair
  • 1,386
  • 1
  • 21
  • 42
0
votes
1 answer

rdl report Filter sums

How can i write the expression in rdl report for the following : Sum(Fields!Amount.Value) where AccountType='Income' - SUM(Fields!Amount.Value) where AccountType='Cost of Goods Sold') Am Using only 1 dataset with the following columns AccountType…
Stelios
  • 330
  • 5
  • 21
0
votes
1 answer

Associate rdls with a new data source

I have about 300 some reports, and the data source has been deleted during migration, so the dependency of the reports from the data source has been lost. how can I re-associate the new data source I created to all the reports without manually going…
Henry
  • 1
  • 1
0
votes
1 answer

SSRS 2005: How do I make available varbinary data for download in a report?

SSRS newbie question here... I have a table where one column is varbinary(max) data. I would like to make a report that makes this data available for download as a hyperlink so the user can just click on the item and get a file download dialog for…
Angelo
  • 2,936
  • 5
  • 29
  • 44
0
votes
1 answer

Rdlc: dynamically hide item in footer

I want to hide or show certain controls in the page footer of a rdlc report based on what happens in the report. The body contains a couple of a tablixes and as soon as one of those tablixes is shown on a page I don not want to show certain controls…
Roland Deschain
  • 659
  • 11
  • 21
0
votes
1 answer

Is there a way to obfuscate source SSRS code so it cannot be reverse-engineered?

I work on a team that creates custom SSRS reports for our end users that are viewed using Report Manager or Sharepoint depending on the end user community. Some end users are technical and know how to use BIDS or Visual Studio. This presents a…
Steven Kerckhof
  • 1
  • 1
0
votes
1 answer

How can I create a pie chart in a report combining two datasets in Visual Studio?

My question is exactly the one I used for title. I've got an .rdl file with two datasets that are really hard to combine in one script, so I want to create a pie chart using both of them as individual datasets. I need to find the percentages of an…
natan
  • 79
  • 9
0
votes
0 answers

How do I change the datasource of RDL report at runtime?

I have 3-4 different environments like Development,Testing and Production So there is different data in different database and depending upon the environment,after deployment...respective datasource should get attached to the report. Mean to say I…
Mahesh Pachbhai
  • 1
  • 1
1 2 3
…
32 33