Telerik Forums
Reporting Forum
1 answer
310 views

I used to Telerik reporing for data show. It is work order. but after update 2020 R1. I can not replace the connection string. please help.

my controller:

[Route("api/reports")]
    public class ReportsController : ReportsControllerBase
    {
        string reportsPath = string.Empty;

        public ReportsController(IHostingEnvironment environment)
        {
            this.reportsPath = Path.Combine(environment.WebRootPath, "UserUpload\\Reports");
            this.ReportServiceConfiguration = new ReportServiceConfiguration
            {
                HostAppId = "Html5DemoApp",
                Storage = new FileStorage(),
                ReportResolver = new ReportTypeResolver()
                                    .AddFallbackResolver(new ReportFileResolver(this.reportsPath)),
            };
        }


        [HttpGet("reportlist")]
        public IEnumerable<string> GetReports()
        {
            return Directory
                .GetFiles(this.reportsPath)
                .Select(path =>
                    Path.GetFileName(path));
        }
    }

 

viewer code:

<script>
    function ReportRendering(e,args) {
        var info = args.deviceInfo;
        //info.set("FontEmbedding", "Full");
    }
   
    function OnLoad()
    {
        var win = window.parent.GetWindow("WdIframe");
        var report = win.reportName;
        var parameters = win.reportParam;
        var printMode = /(chrome)/.test(navigator.userAgent.toLowerCase())
            ? telerikReportViewer.PrintModes.FORCE_PDF_PLUGIN
            : telerikReportViewer.PrintModes.FORCE_PDF_FILE;


        $("#reportViewer")
            .telerik_ReportViewer({
                serviceUrl: "../api/reports/",
                reportSource: {
                    report: report,
                    parameters: parameters,
                },
                viewMode: telerikReportViewer.ViewModes.PRINT_PREVIEW,
                scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                scale: 1.0,
                enableAccessibility: false,
                sendEmail: { enabled: false }
            });


        //$("#reportViewer").telerik_ReportViewer({
        //    serviceUrl: "../Api/reports/",
        //        reportSource: {
        //            //report: "Telerik.Reporting.Examples.CSharp.ReportCatalog, CSharp.ReportLibrary",
        //            report: report,
        //            parameters: parameters,
        //    },
        //    renderingBegin:ReportRendering,
        //    viewMode: telerikReportViewer.ViewModes.PRINT_PREVIEW,
        //    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
        //    scale: 1.0
        //});
        if (win.mode == "Print") {
            var reportViewer = $("#reportViewer").data("telerik_ReportViewer");
            reportViewer.bind(telerikReportViewer.Events.PAGE_READY, function (e) {
                reportViewer.commands.print.exec();
            });
        }
    }
    $(document).ready(OnLoad());
</script>

 

Katia
Telerik team
 answered on 06 Mar 2020
1 answer
225 views

I was creating a report in Oracle and running an SP when suddenly my computer started to slowdown, upon checking I discovered that the Telerik ReportDesigner R1 2020 is consuming 4,920.4 of memory with 1.9MB/s in Disk. Because of this outcome and due to my computer slowdown, I hard re-boot my computer. After opening my PC and logging in, I opened the ReportDesigner but it no longer opens up. It always gives up an error message "Fatal error in workbench. Now closing... An error has occured while loading the ReportDesigner's Workbench".

Here is an attached file for the crashed Telerik ReportDsigner,

I need to get the app started badly to finish my report and to give assessment on Telerik Reproting to my bosses.

Thanks in advance!

Neli
Telerik team
 answered on 05 Mar 2020
1 answer
686 views
Is it possible to have multiple textboxes in a single table cell? The reason i want that is to use different fonts/styles etc. HtmlTextBox does not help because we also want this to work in Excel.
Katia
Telerik team
 answered on 05 Mar 2020
1 answer
503 views

Hi,

I want to make a report by using report viewer on Winforms(C#). 

Report was designed on Visual studio 2019. 

When I add and set a sqlDataSource on Report Designer.  it is shown correctly.

 

I create a report on report viewer on Winforms(C#) by dynamic data with SQL query.

How can I set sqlDataSource ?

 

Here is my code.

 

private void reportViewer1_Load(object sender, EventArgs e)
        {
            TypeReportSource typeReportSouce = new TypeReportSource();
            typeReportSouce.TypeName = "SalesManager.Products.BarcodePrintReport, SalesManager, Version=0.9.24.1, Culture=neutral, PublicKeyToken=null";
            typeReportSouce.Parameters.Add(new Telerik.Reporting.Parameter("Barcode", "O43659"));

            SqlDataSource sqlDataSource = new SqlDataSource();
            sqlDataSource.ProviderName = "MySql.Data.MySqlClient";
            sqlDataSource.ConnectionString = "Server=********;Port=****;Database=****;Uid=****;Pwd=*****;CharSet=utf8;Convert Zero Datetime=True";
            sqlDataSource.SelectCommand = "SELECT barcode,name FROM product_list WHERE code = 'TT003' OR  code = 'TT002'";
            sqlDataSource.CommandTimeout = 0;

            this.reportViewer.ReportSource = typeReportSouce;
            this.reportViewer.RefreshReport();
        }

박문석
Top achievements
Rank 1
 answered on 05 Mar 2020
0 answers
94 views

Im trying to make a doble colum report, and i gotit  but a the and of report i want to end in a complente center table, but i can not get it cuz the report is in double column.

 

What can I Do for resolve that problem. 

Ezequiel
Top achievements
Rank 1
 asked on 04 Mar 2020
1 answer
47 views

Hi,

        I have downloaded Telerik_Reporting_Q1_2016_SP1_manual.chm, however I can only see the content tables, I cannot see content on the right hand side of help windows. I am using windows 10.

 

Neli
Telerik team
 answered on 04 Mar 2020
2 answers
753 views

Downloaded and installed Telerik Report Designer to do some assessment. I am trying to connect to Oracle database for the report I've been working with. But when I click "Test Connection", I encountered this issue.

I wan't to know what does this mean, and how to resolve this issue.

PS: Currently using the following:

Processor: Intel Core i7-6500U
OS: Win 10 Pro ver.1909 OS Build: 18363.657
64bit, x64-based processor 

Any help would be highly appreciated. Thanks in advance.

frederick
Top achievements
Rank 1
 answered on 04 Mar 2020
1 answer
235 views

Now im having 2 column charts:

1. Sales amount by department

and

2. Number of transactions by department

 

i wan to combine both of them in this way:

Sales amount : left vertical axis

Number of transactions: right vertical axis

department: horizontal axis

 

may i know can I achieve it?

thanks in advance

Ivan Hristov
Telerik team
 answered on 02 Mar 2020
1 answer
231 views
Hi, we currently have an Asp.Net MVC application and we use a lot of Kendo UI components. There is a new requirement to create a dashboard for our application, all the data for the dashboard is in a database view.  I would like to make use of Telerik reporting to show a report based on some of the data which is returned in the view. Also, I would like the report to refresh every 5 seconds. Is this possible in Telerik reporting and if so where do I start?
Regards,
Abe
Ivan Hristov
Telerik team
 answered on 02 Mar 2020
3 answers
172 views

Hello,

 

I am using Telerik Report Designer HTML5. I have made a graph where the x-axis ('x') and y-axis ('y') data is retrieved from the database. On my tool-tip, I am retrieving a different data from the database, let's say 'z'.

 

When I export my graph in .csv format, the 'x' and 'y' data is listed down, but I want the csv to also export my 'z' data from the tool-tip.

 

Hence, is it possible to export the tool-tip data from a graph in a csv?

Neli
Telerik team
 answered on 28 Feb 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?