Telerik Forums
Reporting Forum
1 answer
508 views

I have two reports, first report (finished) shows the detail Section normally, but second doesn't. I've already changed the path. F ooter and header section are fine, but when I insert some textbox or something else on the detail section, nothing happens. I tried to change the background color to check if the problem were the items, but the background stays blank. Can you help me please? The ReportPreview shows all the items normally

Of course I set detail.Visibile = True

 

Please help me!

Yana
Telerik team
 answered on 27 Jul 2017
2 answers
836 views

Hi, 
I was designing a report and had multiple columns inside a table, e.g;

Column-A  || Column-B
String 1      ||       45000

String 2      ||

String 3      ||       2000

 

Now, clearly as you can clearly see, on column-B we are supposed to perform SUM function. And this column contains one empty field. Also, I would like to mention here that table is being populated using "expression" and I am supposed to show sum of this column in separate textbox. 

What I am already doing is; " =SUM(Fields.amount)" but that is not giving me correct answer.

I shall be thankful for any help. 

Regards,
Muhammad Mohsin

Muhammad Mohsin
Top achievements
Rank 1
 answered on 27 Jul 2017
2 answers
386 views

i'm using telerik report Ver 

Telerik Reporting Q1 2016 SP1 (version 10.0.16.204)

all report give me 

Error loading the report viewer's templates. (Template = http://domain/APPLICATIONNAME/api/reports/resources/templates/telerikReportViewerTemplate-html).

and when i check telerik service by 

"http://domain/APPLICATIONNAME/api/reports"

 

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<Error>
<Message>
No HTTP resource was found that matches the request URI 'http://domain/APPLICATIONNAME/api/reports'.
</Message>
<MessageDetail>
No type was found that matches the controller named 'reports'.
</MessageDetail>
</Error>

Katia
Telerik team
 answered on 27 Jul 2017
6 answers
221 views

Hi,

I can create the report rendering to XLSX format but a message box will be displayed before the report:  How to avoid this message box?  Thanks.

Infrastructure
Top achievements
Rank 1
 answered on 26 Jul 2017
1 answer
236 views

Hi. I have a Report with Pie Chart that displays number on purcentage based on data in a list.

When the Report repeats itself and finds no data, the Chart Pie disappears. I need a way to display an empty Chart Pie with 0% when there is no data on the list. 

How can I do it?

Yana
Telerik team
 answered on 26 Jul 2017
1 answer
221 views

Sorry if I open another thread, but I need help about Pie Chart.

I created a Pie Chart, and I have three questions about it:

1. How can I fix the size of the entire Chart?

2. How can I fix the size of every slice based on percent? (how you can see, the slice have all the same size even if different values))

3. Why every label near % repeat a number 0,00%?

 

Here the screenshot, hope you can help me.

Best regards.

Angelo

Katia
Telerik team
 answered on 25 Jul 2017
1 answer
474 views
I want the axis to always start at zero, even if the chart has no zero values. How do I do that?
Katia
Telerik team
 answered on 24 Jul 2017
1 answer
260 views

Hello! I apologize for my poor English first.

I am a beginner on Telerik Report. I have to create a Pie chart that displays a datasource's data. Make my point clear:

I am making a Report build on three lists of objects, one object of every list it's named: Status (it can be: Open, On track, Cancelled etc...).

The chart should displays the average of every "Status" inside the three lists of the Report in percent (for example: Open 100%; Open 50%, Open 75% etc...)

The problem is: I don't know how to bind via code the Chart with the ObjectDataSource, I am using Graph Wizard.

I wrote this code 

 private void graph1_NeedDataSource(object sender, EventArgs e)
        {           
            Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
            chart.DataSource = CbpGlobalInitiativesUsdByCountryFollowUpStructure; //it's the DataSource of the entire Report
        }

The Binding of the graph already has "Property path: DataSource", "Expression: =Field.List1 =Field.List2 =Field.List3"

I saw a tutorial and at this point the chart should already works, instead nothing happens!

Where am I get wrong?

Thank you,

Angelo

 

Katia
Telerik team
 answered on 24 Jul 2017
1 answer
220 views

Hi There,

         I'm trying to displaying Telerik report in MVC 6 , its doesn't throw any error either doesn't display the Report viewer with the report. I have provided the Razor code over here . When I Use fiddler, the webapi is throwing an error Telerik.Reporting.Services.Engine.InvalidReportException, from Telerik.Reporting.Services.Engine.ReportEngine.ResolveReportSource(String report). Please help to resolve the issue. Attached the fillder_log as well.

@{var typeReportSource = new TypeReportSource() { TypeName = typeof(BarcodesReport).AssemblyQualifiedName }; }
@(
    Html.TelerikReporting().ReportViewer()
            .Id("Testreport1")
                .ServiceUrl("http://localhost/api/reports/")
                    .TemplateUrl("http://localhost/ReportViewer/templates/telerikReportViewerTemplate.html")
               .ReportSource(typeReportSource)
                .ViewMode(ViewMode.Interactive)
                .ScaleMode(ScaleMode.Specific)
                .Scale(1.0)
                .PersistSession(false)
                .PrintMode(PrintMode.AutoSelect)
                .Deferred()
                   
)
<select id="theme-switcher"></select>
@section scripts
{
    <!--kendo.all.min.js can be used as well kendo.web.min.js and kendo.mobile.min.js-->
    <script src="@Url.Content("~/ReportViewer/js/telerikReportViewer.kendo-11.1.17.614.min.js")"></script>
    <script src="@Url.Content("~/Scripts/themeSwitcher.js")"></script>
    <script src="@Url.Content("~/ReportViewer/js/telerikReportViewer-11.1.17.614.js")"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            //Theme switcher
            themeSwitcher(
                '#theme-switcher',
                '#common-css',
                '#skin-css');
        });
    </script>
    @(Html.TelerikReporting().DeferredScripts())
}

 

 

Katia
Telerik team
 answered on 24 Jul 2017
1 answer
242 views

Hello,

I have been having a problem trying to generate a report programatically. I can generate columns just fine, but when it comes to trying to generate the rows, the ReportViewer gives me a NullReferenceException: "Object reference not set to an instance of an object." As I iterate through my list, I add a new row to the table body. Then, for every cell that needs to be made, I add a ChildGroup to the main Rowgroup. After I've finished iterating and generating everything, I finally add the parent RowGroup. From what I can tell, the way I add rows is close to the way it's done in the designer files. Here is the code in question:

 

private void table1_ItemDataBinding(object sender, EventArgs e)
{
    HtmlTextBox textboxGroup;
    var christieTable = new ChristieTable(ReportParameters["partNumber"].Value.ToString(),
                                          ReportParameters["lotNumber"].Value.ToString());
    var christieProps = typeof(ChristieTable).GetProperties();
 
    table1.ColumnGroups.Clear();
    table1.RowGroups.Clear();
    table1.Body.Columns.Clear();
    table1.Body.Rows.Clear();
    TableGroup rowsTableGroup = new TableGroup();
    List<ReportItemBase> reportItems = new List<ReportItemBase>();
 
    //start at -1 so we can account for the mold # column but retain the ability to index using i
    for (int columnIndex = -1; columnIndex < christieProps.Length - 1; columnIndex++)
    {
        var propValue = (columnIndex != -1) ? (List<Tuple<double, int>>) christieProps[columnIndex].GetValue(christieTable) : null;
        //make sure our column property is populated
        if (propValue != null && propValue.Count > 0)
        {
            var columnsPerStation = 1;
            var currentDip = propValue[0].Item2;
            foreach (var measurePair in propValue)
            {
                if (measurePair.Item2 != currentDip)
                {
                    columnsPerStation++;
                    currentDip = measurePair.Item2;
                }
            }
 
            var tableGroupColumn = new TableGroup();
            table1.ColumnGroups.Add(tableGroupColumn);
            //if tableGroupColumn isn't given a name, all cells will have the same value as cell 0,0
            tableGroupColumn.Name = columnIndex.ToString();
            table1.Body.Columns.Add(new TableBodyColumn(Unit.Inch(1)));
 
            for (int a = 0; a < columnsPerStation; a++)
            {
                textboxGroup = ReportHelper.GenStandardColumnHeader(christieTable.StationNames[columnIndex] + " - DIP NUMBER " + propValue[0].Item2);
                tableGroupColumn.ReportItem = textboxGroup;
                reportItems.Add(textboxGroup);
            }
 
            var value = (List<Tuple<double, int>>) christieProps[columnIndex].GetValue(christieTable, null);
            table1.Body.Rows.Add(new TableBodyRow(Unit.Inch(0.24998027086257935D)));
            for (int rowIndex = 0; rowIndex < 5; rowIndex++)
            {
                TableGroup newRowSubGroup = new TableGroup();
                newRowSubGroup.Name = "row" + (columnIndex + rowIndex + 1).ToString();
                rowsTableGroup.ChildGroups.Add(newRowSubGroup);
                HtmlTextBox newTextBoxTable = ReportHelper.GenTextBox(value[rowIndex].Item1.ToString());
                table1.Body.SetCellContent(rowIndex, columnIndex + 1, newTextBoxTable);
                reportItems.Add(newTextBoxTable);
            }
        }
        else if (propValue == null)
        {
            var tableGroupColumn = new TableGroup();
            table1.ColumnGroups.Add(tableGroupColumn);
            tableGroupColumn.Name = columnIndex.ToString();
            table1.Body.Columns.Add(new TableBodyColumn(Unit.Inch(1)));
 
            textboxGroup = ReportHelper.GenStandardColumnHeader("MOLD #");
            tableGroupColumn.ReportItem = textboxGroup;
            reportItems.Add(textboxGroup);
 
            HtmlTextBox textBoxTable = ReportHelper.GenTextBox("= RowNumber()");
            table1.Body.SetCellContent(0, columnIndex + 1, textBoxTable);
            reportItems.Add(textBoxTable);
        }
    }
    rowsTableGroup.Name = "rowsGroup";
    rowsTableGroup.Groupings.Add(new Grouping(null));
    table1.RowGroups.Add(rowsTableGroup);
 
    table1.Items.AddRange(reportItems.ToArray());
}

 

The GenStandardColumnHeader and GenTextBox methods simply return pre-formatted textboxes, their first parameter being the value of the textbox. The properties of the object ChristieTable that I am iterating through are DataMembers consisting of a list of pairs. Using the debugger, I found that the report processes fine, but throws the exception when trying to render. Despite the fact that rows get clearly added, I found in the debugger that the row count for the table at render time is 0. Any help would be appreciated, thanks.

Stef
Telerik team
 answered on 21 Jul 2017
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?