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

Grouping does not create in master details rdlc report formatting

I want to create a rdlc report using Microsoft Report Designer. Due to complexity of my data (the given below is just an example) I do not use View on Database side. So, I have to use seperate tables (data sources) for my report design. Now, as it…
Shohel
  • 3,886
  • 4
  • 38
  • 75
0
votes
1 answer

Visual Studio RDL Report New Page per record

I have this RDL report that I created in Visual Studio and it is using a Stored Procedure as the data source. Every column from the SP output is mapped to a text box in the report. Now, the SP returns multiple rows but in the report, only one of…
user2913493
0
votes
1 answer

SSRS Chart Group Series - How do I get the secondary series group to start at the first data point?

I have a chart where I am comparing two years worth of data. I have a series group that filters the data for each year. The problem is that the secondary group series is not starting at the first data point. Is there a parameter I can set to get…
Eric
  • 958
  • 1
  • 11
  • 28
0
votes
1 answer

While generating an RDLC, I get an exception with the Message "MyDataSetName"

The short version: When generating a report from an RDLC, it throws a LocalProcessingException, with the message "An error occurred during local report processing." There is an InnerException of type ProcessingAbortedException, with the message "An…
REW
  • 752
  • 2
  • 9
  • 27
0
votes
0 answers

Java script In rdlc

i am using java script in rdl to open another page in a tab when we click a particular row in rdlc,i used the following code for that purpose ="javascript:void(window.parent.$('#tt').tabs('add',{title: 'New Company',content:'
AfterGlow
  • 227
  • 3
  • 17
0
votes
0 answers

SSRS with Custom DataSet (System.Data.DataSet)

How to create a report with DataSet object? Hers is my existing approach, Create the connection String. Create the Query String. Write the RDL file manually using XMLWriter with the above details, like
Thorin Oakenshield
  • 14,232
  • 33
  • 106
  • 146
0
votes
2 answers

ASP.NET reporting, what, how and when to use RDLC

I am new to reporting in asp.net and can't get the things work up good for me. Basically, I made a demo of what was told here. Everything worked fine and it generated report on my local system. But, did not worked on the web server. Now, I've got a…
Cyberpks
  • 1,401
  • 6
  • 21
  • 51
0
votes
3 answers

SSRS - Remove seconds from Time field

How do I remove seconds from Time field? I tried: =Rset(Fields!hr_saida.Value,5) = return #Error =TimeValue(Fields!hr_saida.Value) = return #Error =FormatDateTime(CDate(Fields!hr_saida.Value),"hh:mm") = return #Error I also tried set my text box…
migmig
  • 131
  • 3
  • 6
  • 16
0
votes
1 answer

How can I load an SSRS report dynamically into a Report Viewer and include the data sources / datasets?

Here's the scenario: I have many different report files (*.rdl) and the user is able to select one from a web interface. This, in turn, loads a Report Viewer control (as an ASPX control). My *.rdl files contain both Data Sources and Datasets in the…
qJake
  • 16,821
  • 17
  • 83
  • 135
0
votes
1 answer

How to modify static text in rdlc file?

I have a rdlc file and I try to modify a static text on the file, but when I start the program the text in the form is not modified. I use VS C# 2008 Express. What should I do to be able to modify the text in rdlc file?
Vasil Vasilev
  • 1
0
votes
1 answer

Repeat Column Headers in RDL Report, New Page Appearing

In a simple report in SSRS, I needed to repeat column headers of a tablix. I did what I had seen on http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx (and many other websites) and it works.…
Delphi.Boy
  • 1,199
  • 4
  • 17
  • 38
0
votes
2 answers

How to add group, or page field in an existing .rdl report

I have several .rdl reports designed for our client. However, they need new ones, that are relatively similar to the old ones. Differences are in the "group" and "page fields" (these can be changed easily). I'm interested in adding new group and…
Eedoh
  • 5,818
  • 9
  • 38
  • 62
0
votes
1 answer

How to use SharePoint web service 'getUserProfileByName' corect in SSRS report query builder?

I have several SSRS 2005 reports that i am updating to SSRS 2008 however there is a data set that requires using the SharePoint 2010 web service 'getUserProfileByName' to complete the report. However, the old query that apparently 'worked' in the…
JBMac
  • 329
  • 1
  • 6
  • 18
0
votes
1 answer

SQL Report Server - how do I edit the report input?

I'm fairly new to SQL Server Reporting Services. I can edit the report output by editing the .rdl file in Visual Studio, however I'm trying to find out how to edit the input options available to report users - specifically the one shown below. …
Chris Halcrow
  • 28,994
  • 18
  • 176
  • 206
0
votes
1 answer

Concatenate multiple rows in one row

I've been trying to do this until I can't figure it out how, I just wanted to concatenate multiple rows into one row and make it the value of the final column query. To illustrate; Initial Query: ColumnOne --------- Row1 | 1 - One …
mirageservo
  • 2,387
  • 4
  • 22
  • 31
1 2 3
…
32 33