Telerik Forums
Reporting Forum
1 answer
262 views

im followed this thread but doest work.
https://www.telerik.com/forums/how-to-write-an-oracle-stored-procedure-to-work-with-telerik-reporting-wizard

now im using .netcore 2 mvc. and i want to build report from Report Designer and put it in my project.
but i cant create datasource from Oracle stored.

Please help me.

 

Katia
Telerik team
 answered on 15 Jan 2018
1 answer
153 views

I don't seem to be able to find a chart control for a Funnel. I suspect there is not one at this time.

Has anyone created a work around for this yet using a bar chart?

Silviya
Telerik team
 answered on 15 Jan 2018
2 answers
773 views

Hi,

I have two projects; a website and a web api. (.net Core 2.0 )

The website has the following html;

 $("#reportViewer1")
                .telerik_ReportViewer({
                    //serviceUrl: "/api/reports/",
                    serviceUrl: "@ViewBag.TelerikReportServerUrl",
                    reportSource: {
                        report: "TelerikReportService.Report, TelerikReportService", 
                        //report: "Barcodes Report.trdp",
                        parameters: {}
                    },
                    viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
                    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                    scale: 1.0,
                });

And within the web API project I have been trying to create an example Report Class file that can be served up to the client.
This is how far I have got, but it wont work and I cannot find an example of this anywhere in the forums.

("Barcodes Report.trdp" works fine, just a CODED report class,  I cannot get to work)

I get the error;

"Unable to get report parameters.
An error has occurred.
Invalid report type"

 

CODED report class: 

namespace TelerikReportService

{
    public partial class SchemeReport : Telerik.Reporting.Report
    {

        public SchemeReport()
        {
            
        }


        public DataTable GetData()
    {
        dynamic table = new DataTable();
        table.Columns.Add("col1", typeof(int));
        table.Columns.Add("col2", typeof(int));

        table.Rows.Add(1, 3);
        table.Rows.Add(4, 6);
        table.Rows.Add(2, 5);
        table.Rows.Add(4, 7);

        return table;
    }



    public Telerik.Reporting.Report GenerateReport()
    {
            
        //create a blank report
        Telerik.Reporting.Report report = new Telerik.Reporting.Report();
        report.Name = "Report1";
        report.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(1.0), Telerik.Reporting.Drawing.Unit.Inch(1.0), Telerik.Reporting.Drawing.Unit.Inch(1.0), Telerik.Reporting.Drawing.Unit.Inch(1.0));
        report.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
        report.Width = Telerik.Reporting.Drawing.Unit.Inch(6.0);

        //create a detail section and add it to the report instance's Items collection
        Telerik.Reporting.DetailSection detailSection = new Telerik.Reporting.DetailSection();
        detailSection.Height = Telerik.Reporting.Drawing.Unit.Inch(1);

        detailSection.Name = "DetailSection";
        report.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { detailSection });

        //create a blank Table item
        Telerik.Reporting.Table table1 = new Telerik.Reporting.Table();
        table1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0), Telerik.Reporting.Drawing.Unit.Inch(0.0));
        table1.Name = "Table1";
        table1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4), Telerik.Reporting.Drawing.Unit.Inch(1));


        //get the data for the table
        dynamic data = GetData();
        table1.DataSource = data;

        //create a dynamic row group
        Telerik.Reporting.TableGroup DetailRowGroup = new Telerik.Reporting.TableGroup();
        DetailRowGroup.Groupings.Add(new Telerik.Reporting.Grouping(null));
        DetailRowGroup.Name = "DetailRowGroup";
        table1.RowGroups.Add(DetailRowGroup);
        //add a row container
        table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.5)));


        //add columns
        for (int i = 0; i <= data.Columns.Count - 1; i++)
        {
            //add a column container
            table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(2)));
            //add a static column group per data field
            Telerik.Reporting.TableGroup columnGroup = new Telerik.Reporting.TableGroup();
            table1.ColumnGroups.Add(columnGroup);

            //header textbox
            Telerik.Reporting.TextBox headerTextBox = new Telerik.Reporting.TextBox();
            headerTextBox.Name = "headerTextBox" + i.ToString();
            headerTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2), Telerik.Reporting.Drawing.Unit.Inch(0.5));
            headerTextBox.Value = data.Columns[i].ColumnName;
            columnGroup.ReportItem = headerTextBox;

            //field that will be displayed
            Telerik.Reporting.TextBox detailRowTextBox = new Telerik.Reporting.TextBox();
            detailRowTextBox.Name = "detailRowTextBox" + i.ToString();
            detailRowTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2), Telerik.Reporting.Drawing.Unit.Inch(0.5));
            detailRowTextBox.Value = "= Fields.[" + data.Columns[i].ColumnName + "]";
            table1.Body.SetCellContent(0, i, detailRowTextBox);

            //add the nested items in the Table.Items collection
            table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            headerTextBox,
            detailRowTextBox
        });

        }

        //add total group - static group out of the detail row group
        table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.5)));
        Telerik.Reporting.TableGroup totalRowGroup = new Telerik.Reporting.TableGroup();
        totalRowGroup.Name = "totalRowGroup";
        table1.RowGroups.Add(totalRowGroup);
        for (int i = 0; i <= data.Columns.Count - 1; i++)
        {
            Telerik.Reporting.TextBox totalRowTextBox = new Telerik.Reporting.TextBox();
            totalRowTextBox.Name = "detailRowTextBox" + i.ToString();
            totalRowTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2), Telerik.Reporting.Drawing.Unit.Inch(0.5));
            totalRowTextBox.Value = "= Sum(Fields.[" + data.Columns[i].ColumnName + "])";

            totalRowTextBox.Style.BackgroundColor = Color.Azure;
            table1.Body.SetCellContent(1, i, totalRowTextBox);
        }


        //add the table in the detail section's Items collection
        detailSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { table1 });


        return report;
    }
    }
}

 

Todor
Telerik team
 answered on 12 Jan 2018
2 answers
298 views

I am getting the following error when trying to use rollup to bundle my app which is using the Angular report viewer module:

 

?   'ReportViewer' is not exported by node_modules\@progress\telerik-angular-report-viewer\dist\dependencies\telerikReportViewer.js
https://github.com/rollup/rollup/wiki/Troubleshooting#name-is-not-exported-by-module
node_modules\@progress\telerik-angular-report-viewer\dist\es\telerik-report-viewer.component.js (6:9)
4: window.jQuery = jquery;
5: import '../dependencies/telerikReportViewer.kendo-2016.3.914.min';
6: import { ReportViewer } from '../dependencies/telerikReportViewer';
            ^
7: var TelerikReportViewerComponent = /** @class */ (function () {
8:     function TelerikReportViewerComponent() {

 

I followed the link in the error description but am not sure what to put in the commonjs section of rollup.config (if this is the issue), this didn't seem to do anything:

    plugins: [
        nodeResolve({jsnext: true, module: true}),
        commonjs({
            include: 'node_modules/**', 
namedExports: {
                'chart.js': ['Chart'], 
                '@progress/telerik-angular-report-viewer': ['ReportViewer']
}, 
        }),
        uglify()
    ]

Mario
Top achievements
Rank 1
 answered on 11 Jan 2018
2 answers
154 views

Hi, 

I Created a report, when i preview the report it works fine but  sometimes i get " InnerException" Error. I don't understand why i am getting this error. Please can anyone help me. Please find the below attached image. 
Thanks,
Mans

Brian
Top achievements
Rank 1
 answered on 11 Jan 2018
0 answers
191 views

While trying to open my coded step which is a vb I get this error and can't open it.

 

The invocation of the constructor on type 'ActiproSoftware.Windows.Controls.Syntaxeditor.Syndaxeditor' that matches the specified binding constraints threw an exception

Charitos
Top achievements
Rank 1
 asked on 11 Jan 2018
5 answers
246 views

Hi,

Im working on a multi themes application using NoXaml dlls and Telerik.Windows.Themes.<THEME>.dll libraries.

All works perfectly but not the repoirt viewer. The Telerik.Windows.Themes.<THEME>.dll don't contains Telerik.ReportViewer.Wpf.xaml resource?

Why?

You can add it on next release?

Thanks,

marc.

Katia
Telerik team
 answered on 10 Jan 2018
0 answers
623 views

Hi,

 

I am using Telerik reporting.

I have some reports that have some graph and table in the report design.

When I try to export a report in CSV format, it was showing some extra static columns.

I have tried this

https://www.telerik.com/forums/report-export-to-csv-has-extra-columns

and this

https://docs.telerik.com/reporting/configuring-telerik-reporting

 

With the help of these configuration now static data is not showing in report, but now the problem is that report is exporting all the data present in report data source. So in report CSV I can see many tables spanning across different columns in CSV with varying number of rows.Is there any option available to control the data/component being exported in output CSV, lets say I just want to export a table data in CSV not the source data for some graph on the same report.


Pardeep
Top achievements
Rank 1
 asked on 10 Jan 2018
3 answers
343 views

I have successfully created a reportslibrary.dll as a class library containing my reports and when called from a winforms.exe it works as expected.
I'm creating an add-on application for AutoCAD that requires my code to be compiled as a class library(dll).
When I call on my reportslibrary.dll from my AutoCAD dll I receive the following error:
Invalid report type
Value cannot be null.
Parameter name: type

Any reason why I can’t call on my reportslibrary.dll from a dll and I can from an exe?
I have verified all setting are the same.


Todor
Telerik team
 answered on 10 Jan 2018
0 answers
82 views

Hi, 

 

I'm trying to bring just the required data in line X. however empty data is also coming as if it were repeating.

Matheus
Top achievements
Rank 1
 asked on 09 Jan 2018
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?