Telerik Forums
Reporting Forum
1 answer
369 views
How can I adjust the textbox size depending on the text?
KS
Top achievements
Rank 1
 answered on 25 Feb 2015
1 answer
336 views
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
KS
Top achievements
Rank 1
 answered on 25 Feb 2015
5 answers
1.0K+ views
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



      
Nasko
Telerik team
 answered on 23 Feb 2015
8 answers
3.4K+ views
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
Stef
Telerik team
 answered on 23 Feb 2015
10 answers
908 views
hi guys,

i have a master detail report that uses a certain table from a DataSet as DataSource,
i've set:
MasterReport.DataSource = DataSet1.Table1 and 
MasterReport.DataMember = "GetEnumerator".
until now, it works fine.

now, i have a subreport in the MasterReport and i want to set its' datasource,
because DataSet1 hold 2 tables, and Table1 is the DataSource of the MasterReport,
i want to take the same DataSet1 and get Table2 from it to put as DataSource of the subreport,
something like that:
((MasterReport.DataSource as DataSet1.Table1).DataSet.Tables["Table2"]

of course this doesn't work because MasterReport.DataSourc is ObjectDataSource type.
how can i do want i need in a better way?
i want the same instance of the Dataset to be the datasource of the two reports but the datamember will be two different tables.
i've attached a screenshot of the way my MasterReport is built.

second problem i have is that i catched in MasterReport this event subReport1_NeedDataSource
(definition of subReport1: "private SubReport subReport1;") and this event MasterReport_NeedDataSource,
i've put a breakpoint in them and it never triggers. any suggestions why that happens?

thanks in advance.
lior.
KS
Top achievements
Rank 1
 answered on 23 Feb 2015
3 answers
525 views
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?
Stef
Telerik team
 answered on 23 Feb 2015
1 answer
128 views
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?



Hinata
Top achievements
Rank 1
 answered on 20 Feb 2015
3 answers
457 views
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.

@section header
{
    @Styles.Render("~/Content/telerikCss")
    <style type="text/css">
        #telerikReportViewer
        {
            overflow: hidden;
            width: 100%;
            height: 595px;
            min-height: 595px;
        }
    </style>
}
 
<div class="row">
    <div class="col-lg-12">
        @{
            var typeReportSource = new TypeReportSource { TypeName = Model.SelectedReportName };
 
            if (typeReportSource.TypeName == "")
            {
                typeReportSource.TypeName = null;
            }
        }
 
        @(Html.TelerikReporting().ReportViewer().Id("telerikReportViewer")
              .ServiceUrl(@Url.Content("~/api/reports/"))
              .TemplateUrl(@Url.Content("~/Content/ReportViewer/templates/telerikReportViewerTemplate-8.2.14.1204.html"))
              .ReportSource(typeReportSource)
              .ViewMode(ViewModes.PRINT_PREVIEW)
              .ScaleMode(ScaleModes.SPECIFIC)
              .Scale(1.0)
              .PersistSession(false)
              )
    </div>
</div>
 
@section scripts
{
    @Scripts.Render("~/bundles/reportsJS")
    <script type="text/javascript">
 
        $(document).ready(function() {
            $("#telerikReportViewer")
            .telerik_ReportViewer({
                parameterEditors: [
                    {
                        match: function (parameter) {
                            return Boolean(parameter.availableValues) && !parameter.multivalue;
                        },
 
                        createEditor: function (placeholder, options) {
                            var dropDownElement = $(placeholder).html('<div></div>'),
                                      parameter,
                                      valueChangedCallback = options.parameterChanged,
                                      dropDownList;
 
                            function onChange() {
                                var val = dropDownList.value();
                                valueChangedCallback(parameter, val);
                            }
 
                            return {
                                beginEdit: function (param) {
 
                                    parameter = param;
 
                                    $(dropDownElement).kendoDropDownList({
                                        dataTextField: "name",
                                        dataValueField: "value",
                                        dataSource: parameter.availableValues,
                                        change: onChange
                                    });
 
                                    dropDownList = $(dropDownElement).data("kendoDropDownList");
                                }
                            };
                        }
                    }]
            });
        });
    </script>
}

Stef
Telerik team
 answered on 19 Feb 2015
3 answers
326 views
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
Nasko
Telerik team
 answered on 18 Feb 2015
6 answers
762 views
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
​
Jack Helfrich
Top achievements
Rank 1
 answered on 17 Feb 2015
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?