Telerik Forums
Reporting Forum
10 answers
892 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
506 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
125 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
447 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
311 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
740 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
2 answers
1.1K+ views
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.

// Specifying the assembly qualified name of the Report class for the TypeName of the report source<br>
ViewerReportSource = new TypeReportSource {TypeName = selectedReport.ReportType.AssemblyQualifiedName};<
br><br>
// create instance of report
<
br>var report = (Report)Activator.CreateInstance(selectedReport.ReportType);
<
br><br>
// Set filters (datasource params)<
br>
var ds = report.DataSource as SqlDataSource;<
br>
ds.Parameters["@UserID"].Value = 999;


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.
kaczmar2
Top achievements
Rank 1
 answered on 17 Feb 2015
10 answers
3.0K+ views

OK I have looked in the docs to no avail.

Take a look at the attached files. What I want to do is get the value that is in the first section Total

(This is a group footer section in Telerik) in the example the value is 81 and I want to show this value in the report footer section. I want to do the same thing for the next group. Things work great when used under the group, and for the entire report SUM() works but how would I display a group value  that is the result of a SUM() on the group in the report footer?

 

I’m sure this can’t be hard but can’t seem to find the info on what to put into the text box value.

 

I was thinking it might be something like value =  MyReport. sectionNamesGroupFooter(0). Sum(Fields.Count) or something with the 0 representing the first group if I wanted the value of the second group I would use value =  MyReport. sectionNamesGroupFooter(1). Sum(Fields.Count)

 

Thanks

Nasko
Telerik team
 answered on 17 Feb 2015
3 answers
94 views
We are using Telerik Reporting Q3 2014 web report viewer in our MVC 4 project running .net 4.5. 
With our reports that use a textbox that require an integer input, we found an issue with data entry into those fields. This issue is only found in IE8+, Google Chrome, and Firefox are unable to replicate this issue. The issue is that whenever an integer is put into this field it is not being sent back to the report resolver and makes the report parameters inoperable for the report rendering it useless. Is this a known issue? 

I'm wanting to make custom report parameters for drop down lists, so i may be able to make that work with this particular field. If i can put in Kendo Datetime picker that just does a year it would work better... 

     So i guess my question after all this, Using the project that i specified above and using an MVC control for the report viewer, how do i go about creating custom parameters for the options on the report. 
Stef
Telerik team
 answered on 17 Feb 2015
5 answers
325 views
I have a c# dll file which creates a pdf report.
I use:
Log("start rendering")
                Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                Telerik.Reporting.Processing.RenderingResult auditAsPdf = reportProcessor.RenderReport("PDF", report, null);
Log("finish rendering")


my application creates dump file in runtime, so I added logs, and I see the first log print but I don't get the "finish" print.
right after I get your print: *** ReportProcessor.Render DONE in 00:00:02.6466816 *** in debug view, the dump file is created.

I use TelerikReporting 3.1.9.701

Any ideas why?

KS
Top achievements
Rank 1
 answered on 17 Feb 2015
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?