Hi,

I don' t know if this is the right place to post my problem. 
Anyway I am working with Spreadsheet process and I want to export some data to an excel worksheet, in particular I' d like to format a worksheet as table (in interop this should be ListObject), because in my excel formulas I need to use an excel table instead of excel range.

An example of result is shown in the attached picture. Is there a way to obtain this?

Thanks

Ciro

I'm using the Q3 2009 version.

I want to selectively hide the detail row in the report when the data source row contains a blank value.

I have tried using the ItemDataBinding event for the detail item, but I am unable to get access to the row in the data table that is being bound to the detail item.

When I look at the ItemtDataBinding event in the debugger I can see the field I need but its contained the ReportItemBase object.

In the debugger, I can see that the sender is an object {Telerik.Reporting.Processing.DetailSection}.

Which inherits from Telerik.Reporting.Processing.ReportSection {Telerik.Reporting.Processing.DetailSection}.

Which inherits from Telerik.Reporting.Processing.ReportSectionBase {Telerik.Reporting.Processing.DetailSection}

Which inherits from Telerik.Reporting.Processing.ReportItemBase {Telerik.Reporting.Processing.DetailSection}.

The ReportItemBase contains the Telerik.Reporting.Processing.IDataObject {Telerik.Reporting.Processing.Data.DataMember} which contains a RawData member which contains the row being bound to the detail item.

I can see that the RawData is a strongly typed row of the data table in my data set.

I thought once I get access to the data row I could check the field for a blank value and hide the detail item by setting the Visible property to false if the field contains a blank.

So, how do I get access to the RawData member of the ReportItemBase object in the ItemDataBinding event?

Thanks for any help on this.

Mark



      

Good Evening,

I understand that the export options for reports using the ReportViewer use the rendering extensions to exporting to a document in order to get the document to be as close as the original report, but I was wondering if there is a way around this.  Our clients want to be able to export the report to an excel document in a row by row fashion, in basically the format that the stored procedure returns the data, and then add some formatting changes.

The comma delimited csv format doesn't quite give them what they want because it also exports textboxes that are being used as labels. 

Is there a way to capture the exporting event, and export it similar to the way radgrids are exported to excel?

Thank you,
Steve

hi guys,

I have several reports within my application. I was having an issue with exporting to excel so we upgraded all the reports to Q2 2014.
All the reports work fine in the development environment however once deployed to production, the export to word function throws this error:
"Index was outside the bounds of the array"

All other export functions perform as expected.
I checked the deployed version of DocumentFormat.OpenXml.dll and it is the correct version (2.0.5022.0) as well as all of the Telerik modules.

This error occurs on all deployment installs and can be reproduced at will.

Has anyone else run into this?

VS 2013 Update 3
Telerik  Reporting Q3 2014

1. How to set different colors  for the items text displaying along X-Axis. (rounded  red in
color in the below image)
2. How to set On Y-axis, customizing the starting values like (starting from 20% and ending up to 50%).
3. How to control the width and size of Data Points?

Hi Everyone,

I've been trying to create a new report using a drop down list for parameters, but instead of a drop down, I'm getting a select list.  I followed the howto How To: Create a Custom Parameter Editor and added the JavaScript into my view (using MVC 5, Telerik Q3 2014 SP1 8.2.14.1204), as well as ensuring that the dropdownelement was using ".html" instead of ".htmll" (Error Found: How To Create a Custom Parameter Editor).  Any help would be appreciated.

Hi, I've got some problems with overlaping labels in pie graphs and legends when I put them in bottom center. Another problem is the overlapping among data labels when the values are small (position outside end). How can I solve that?
Thanks in Advance.
Augusto

I have a report with several check boxes. Many have a Yes and a No box, so one must be populated. I am using a SQL Server database and all of the fields that are related to the check boxes are data type bit. There is only one field in the database for each pair of check boxes, and the fields are all set to required, so there can never be a null value.

The desired behavior is, If the value is True, the Yes check box should be checked, and the No check box should be blank. If the value = False, the Yes check box should be blank and the No check box should be checked.

The current behavior is, if the value is False, both check boxes are blank. If the value is True, the Yes check box is checked, and the No check box has a dot in the middle.

It would be acceptable for both check boxes to be blank if the value is False. But it is not acceptable for the No checkbox to have a dot in the middle.

Here are the properties for the Yes check box:
All properties are the default values except:
Location and Size
Multiline - False
Text - Yes
Value - = Fields.TenPrint

Here are the properties for the No check box:
All properties are the default values except:
Location and Size
Multiline - False
Text - No
TrueValue - False
Value - = Fields.TenPrint

Is there a way to set the properties so I can get the desired behavior?


Thank you,
Jack
​

I have set up a SQLDataSource parameter for a report and can set its value at design time. I need to set the parameter value from a UI element at runtime. This is the code that I have (setting the TypeReportSource dynamically at runtime works fine, and I can query the report's parameter's collection without issue. However, once I update the parameter value, the report still uses the design-time value.


the value '999' is not passed into the query (I am using SQL Profiler to see the value passed in by the reporting framework). I see the value I set at design time.