Telerik Forums
Reporting Forum
1 answer
12 views

When I copy and paste existing table from telerik report designer. i am getting below error

I set datasource and table from code.

how can we create a new table using the same datasource(which we set in code) from  designer?

Dimitar
Telerik team
 answered on 09 Apr 2024
1 answer
247 views

Hello.

Currently I am designing a report on which I have date and datetime data types.

I have prepared the data-base table with data that goes into the report (attachment data-model.png)

I prepared report template in telerik web report designer (attachment report_template.png)
I set format according to Standard DateTime Format Strings
Field with date data has format {0:d}

On preview (at Web Report Designer) the date seems to be ok (attachment preview.png)

Unfortunately, after exporting the report to excel (xlsx), the date type is not a date in excel (attachment invalid_format.png)

My appsetting.json file contains

"telerikReporting": {
  "extensions": [
    {
      "name": "XLSX",
      "parameters": [
        {
          "name": "UseExtendedFormatting",
          "value": "False"
        }
      ]
    }
  ]
}

 

What should I have to set/do in order to have date format in excel for cells that contain date and date-time data?
I would like to achieve result like below: for cell that contain date data in report I need date format in excel

I would like to emphasize that Standard Numeric Format Strings work:

  • C or c (Currency) works fine
  • N or n (Number) works fine
  • G or g (General) works fine
  • P or p (Percent) works fine

Environment:

  • Visual Studio 2022
  • .NET 6
  • Web report designer written in Razor pages
  • Packages (I know it's not the latest version, but it works the same badly on the latest version)
    • Telerik.Reporting v. 16.2.22.1109 (v2022.3.1109)
    • Telerik.Reporting.OpenXmlRendering v. 16.2.22.1109 (v2022.3.1109)
    • Telerik.WebReportDesigner.Services v. 16.2.22.1109 (v2022.3.1109)
  • jQuery v. 3.6.0
  • Windows culture pl-PL
  • I run my project on IIS
    • IIS version 10
    • culture pl-PL
  • project culture pl-PL
  • I set kendo.culture("pl-PL");
    • culture file https://kendo.cdn.telerik.com/2022.3.1109/js/cultures/kendo.culture.pl-PL.min.js

regards

Momchil
Telerik team
 answered on 09 Aug 2023
1 answer
118 views

Dear Sir

i have a  Net 5  Blazor app with Server and Client how to add blazor reporting with this scenario? 

actually how to apply this example  with balzor page and blazor report viewer 

https://docs.telerik.com/reporting/embedding-reports/display-reports-in-applications/web-application/html5-report-viewer/how-to-use-html5-report-viewer-in-an-asp.net-core-in-.net-5-application

2 answers
76 views
Hello,

Im trying to disable the TRDP option when creating a new report. i want to only keep TRDX extention.
If possible i want to remove the whole dropdown section in New report and always add the TRDX extention to new files.

Ive also been searching if it is possible to edit/style/add attributes to the GUI views in the web app since the whole reporter is initialized with only a few lines of JS. Is it possible to see the code which generates these views or is this all API based?

Kind regards,

Ueskia
Tristan
Top achievements
Rank 1
Iron
 answered on 06 May 2022
0 answers
103 views

Hi Team ,

After updating version of Telerik assemblies, Itemdatabound event[I have attached one screenshot for reference (its written in .vb file)]  is getting called while creating report as well while printing report. but I don't want it to get called while I am printing report. Is there any way that I can set autopostback(in telerik report) to false in telerik report ? Or any other solution will be appreciated to call Itemdatabound event only while creating report and not while printing.

Anyone can help me ? 

Kind regards, 

Payal

1 answer
282 views

Goodmorning i have a site developed in .NET 5 that renderize some .trdp report, i compile that report using a stored procedure in my database, actually i pass it my connectionstringstring using the file appsetting.json of my website, but i need to dinamically pass the connectionstring to my SQL DataSource item in my report (maybe using a report parameter?), how can i do that?

i leave you some screen for better explanation.

This is the SQLDataSoruce of my report

this is the appsetting.json file of my website

this is how i pass parameters from a webPage to the report

let me nknow if i was clear or if it possible do what i ask.

Best regards

0 answers
464 views

Hello everyone,

I have a problem with my Web Report Designer project. On my local machine everything works fine but  when i deploy it on the IIS serve, I receive this error:

 http://localhost/reportdesigner/resources/js/telerikReportViewer/ net::ERR_ABORTED 500 (Internal Server Error)
WebReportDesigner:40 GET http://localhost/reportdesigner/designerresources/js/webReportDesigner/ net::ERR_ABORTED 500 (Internal Server Error)
WebReportDesigner:39 GET http://localhost/reportdesigner/resources/js/telerikReportViewer/ net::ERR_ABORTED 500 (Internal Server Error)
WebReportDesigner:40 GET http://localhost/reportdesigner/designerresources/js/webReportDesigner/ net::ERR_ABORTED 500 (Internal Server Error)
WebReportDesigner:44 Uncaught TypeError: $(...).telerik_WebReportDesigner is not a function
    at HTMLDocument.<anonymous> (WebReportDesigner:44)
    at i (jquery.min.js:2)
    at Object.fireWith [as resolveWith] (jquery.min.js:2)
    at Function.ready (jquery.min.js:2)
    at HTMLDocument.K (jquery.min.js:2)
(anonymous) @ WebReportDesigner:44
i @ jquery.min.js:2
fireWith @ jquery.min.js:2
ready @ jquery.min.js:2
K @ jquery.min.js:2

 

This is my Index.cshtml

<head>
    <title>Web Report Designer</title>

    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <link href="https://fonts.googleapis.com/css?family=Roboto:400,500&display=swap" rel="stylesheet">

</head>
<body>

    <div id="webReportDesigner">
        loading...
    </div>

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://kendo.cdn.telerik.com/2020.3.1118/js/kendo.all.min.js"></script>

    <script src="/api/reportdesigner/resources/js/telerikReportViewer/"></script>
    <script src="/api/reportdesigner/designerresources/js/webReportDesigner/"></script>

    <script type="text/javascript">
        $(document).ready(function () {
            $("#webReportDesigner").telerik_WebReportDesigner({
                toolboxArea: {
                    layout: "list"
                },
                serviceUrl: "/api/reportdesigner",
                report: "20201130 Partner Commissions.trdp"
            }).data("telerik_WebDesigner");
        });
    </script>

</body>

 

This is my controller :

{
    [Route("api/reportdesigner")]
    public class ReportDesignerController : ReportDesignerControllerBase
    {
        public ReportDesignerController(IReportDesignerServiceConfiguration reportDesignerServiceConfiguration, IReportServiceConfiguration reportServiceConfiguration)
            : base(reportDesignerServiceConfiguration, reportServiceConfiguration)
        {
        }
    }
}

 

I would appreciate if anyone could help me. Thanks and have a nice day!

I forgot to mention, I am a beginner with Telerik reporting and everything related to it.


Puiu
Top achievements
Rank 1
 updated question on 30 Aug 2021
1 answer
497 views

We use the Report Designer to design a report that we want to access through the browser.
Does the Telerik Report service support Linux installation? What if I could include a link in my reply?

 


Eric R | Senior Technical Support Engineer
Telerik team
 answered on 23 Jun 2021
Top users last month
Mark
Top achievements
Rank 1
Yurii
Top achievements
Rank 1
Leland
Top achievements
Rank 2
Iron
Iron
Iron
Hon
Top achievements
Rank 1
Iron
Deltaohm
Top achievements
Rank 3
Bronze
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?