Telerik Forums
Reporting Forum
1 answer
167 views

Hi everyone, I'd appreciate any input on the following problem:

I have a crosstab with "sales period" as column group, and the detail value is sum of sales.

my report structure is pretty much identical to this demo: https://demos.telerik.com/reporting/product-sales

the only difference is that I will only compare 2 periods, and never more. that should make things hopefully easier. (in other words: a 'SELECT DISTINCT period' on the datasource will always return 2 values.)

Now I would like to show a sales index by comparing period1 to period2 in an additional column.

how can I do that?

 

Faye
Top achievements
Rank 1
Iron
 answered on 04 Sep 2021
0 answers
82 views

I am facing a problem with report viewer, the pagination on report does not seem to work correctly although it shows all pages in Pagination section of report viewer but by click on next page does not seem to work and it shows all pages on every page. Please see the attach screenshot.

What the correct result for me is to show each page when I click on next page button not all pages.

abdul
Top achievements
Rank 1
 updated question on 31 Aug 2021
1 answer
101 views

I have created the following report it is not clear to see what id is which part of  the donut chart. 

I am not able to find how to make it clearer either by label or being able to created series label at the bottom of the report something like the following.

 

Dimitar
Telerik team
 answered on 31 Aug 2021
1 answer
331 views

I would like to create a pie chart in a pivot as mentioned in the following Article:

 

https://www.telerik.com/blogs/impress-users-with-new-visualizations-in-telerik-reporting-q1-2013

 

I am on report designer 2016 R3 but however i am not sure how to set this up correctly. I currently have the following output but i would like this to be broken down to by each campaign, meaning we will get a pie chat for each campaign instead of the total.

i have used crosstab table with the pie chat within them.

Dimitar
Telerik team
 answered on 31 Aug 2021
1 answer
332 views

I have a stacked bar chart in a cell in my table and I'm trying to rip as much out and make it as compact as possible... I have set the PlotAreaStyle background colour to be yellow in my screenshot below... How can I completely remove this space and make my chart more compact in the cell?

Todor
Telerik team
 answered on 30 Aug 2021
0 answers
685 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
434 views

I want to upgrade version of following telerik assemblies -

1. Telerik.Reporting.dll 

2. Telerik.Reporting.OpenXmlRendering.dll  

3.Telerik.Reporting.XpsRendering.dll  

4.Telerik.ReportViewer.Html5.WebForms.dll

I have removed these 4 existing dlls and replaced them with upgraded version files and  added references. Previously in my project Telerik.ReportViewer.Html5.WebForms.dll  was not exist  and  Telerik.ReportViewer.WebForms.dll was there, so I have removed Telerik.ReportViewer.WebForms.dll and   I have  added  Telerik.ReportViewer.Html5.WebForms.dll. 

Its giving errors on multiple files. 

Anyone can help me ? 

Kind regards, 

Payal

Todor
Telerik team
 answered on 30 Aug 2021
1 answer
151 views

Hi ,

I am writing because the Telerik PDF VIEWER is not showing a correct text selection when I load the issue.pdf file. This file works correctly with other pdf viewers like Microsoft Edge , Chrome , and others . The issue.jpg attached file is the issue.pdf with the extension changed. Pleased change it again to view it. 

You can try with the "Telerik UI for WPF - Demos.appref-ms" app .  There you can see an attached picture of the issue: "issue.pic.png". 

Do you know the reason for this problem?

Best,

 

Dimitar
Telerik team
 answered on 26 Aug 2021
1 answer
359 views

Hi Team,

I have created a report which will be generated with 3 pages of data in PDF format. I am getting report with 6 pages of data with alternate page blank when I use landscape and A4 page settings.

In potrait it is coming good but as data is more the page spilt into pages with half data in one page and half data in another page.

I am using version 10.2.16.914.

 

Please provide some help

Thanks,

Nagasree

 

Dimitar
Telerik team
 answered on 26 Aug 2021
1 answer
215 views

Good Morning Telerik,

 

The query I am using within Telerik to query my data from the SQL database is the following.

SELECT *

FROM WebTasks

WHERE COMPLETEDDATE BETWEEN TO_DATE(:FromDate,'MM/DD/YYYY HH24:MI:SS') AND TO_DATE(:ToDate,'MM/DD/YYYY HH24:MI:SS')

 

It creates two parameters the "To Date" and "From Date" however- selecting the date and clicking preview just returns the entire table with all the data going back before and after the selected dates. one of the tables with the dates is "COMPLETEDDATE" but it seems to be ignoring this I guess?

 

What am I doing wrong?

Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?