Telerik Forums
Reporting Forum
1 answer
137 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
471 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
348 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
795 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.1K+ 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
101 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
333 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
1 answer
415 views
Hello,

I'm trying to build up a table-based report where I'm trying to keep the layout as tight as possible width-wise.  I'd like to be able to programmatically set the widths of my columns based on the width of the largest value in the data set so that the columns would be at the minimum width required to not wrap any of the content.  I was looking through the object model for the column and cell objects and couldn't figure out if there was a property that would get me the actual content size.  Do you know if there's a way to accomplish this?  Thanks so much for your help!

Regards,
Brian
Nasko
Telerik team
 answered on 17 Feb 2015
1 answer
207 views
Hi, 

So I have an HTMLTextbox declared inside my report, it's formatted into italic and bold by using HTML Tags like <i> and <b>, the texts were formatted properly but only on Report Viewer (both Print Preview and Interactive layout), I tried exporting it to PDF but when it was converted to a PDF file, all the HTML formatting that I did on the HTMLTextboxes were gone. Can someone explain to me why this is happening? Thanks
Lea
Top achievements
Rank 1
 answered on 17 Feb 2015
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?