Telerik Forums
Reporting Forum
2 answers
572 views

Hello,

 

For my report I will have multiple records with the same date, but each with different times. I was hoping to be able to show an aggregate for the data for each date, with a drill down to show more info for the different times. So far I have been unable to actually get the dates to combine at all, and instead will show every record. How can I get the records to combine into a single row?

 

Currently showing:

 

Day     Sum(price)

1

Mads
Telerik team
 answered on 26 Nov 2020
1 answer
139 views

Can anyone give me an example of how to do this. The docs are very thin.

Thanks … Ed

 

Neli
Telerik team
 answered on 24 Nov 2020
6 answers
1.6K+ views

Hello,

    In a report that I am working on I have a string field coming in from a web service data source that has carriage returns and line feeds in it.

    I would like to remove those \r\n instances and have a single line for my string field.

 

Ezra
Top achievements
Rank 1
 answered on 20 Nov 2020
2 answers
299 views

Hello everybody, 

I'm triyng to define a custom DocumentName for my Report Book (trbp) from Javascript for TelerikViewer. Here my code example for your reference. 

First I initialize telerik Report Viewer:

 $scope.loadTelerikViewer = function () {
            $("#reportViewer").telerik_ReportViewer({
                serviceUrl: "/api/reports",

                reportSource: {
                    report: null,
                    parameters: {
                    }
                },

                // Specifies whether the viewer is in interactive or print preview mode.
                // PRINT_PREVIEW - Displays the paginated report as if it is printed on paper. Interactivity is not enabled.
                // INTERACTIVE - Displays the report in its original width and height without paging. Additionally interactivity is enabled.
                viewMode: telerikReportViewer.ViewModes.INTERACTIVE,

}

Than based on required report Id i change the report source as follow:

var viewer = $("#reportViewer").data("telerik_ReportViewer");
            if ($scope.reportId == 1) {
                viewer.reportSource({
                    report: $scope.fileReportName,
                    parameters: {
                        ReportTitle: $scope.reportTitle,
                        DownloadFileName: $scope.downloadFileName,
                        ConnectionString: $scope.dbStringConn,
                        Client: $scope.JobObject.Client,
                        ManufacturingPlant: $scope.JobObject.PlantClient + ' ' + $scope.JobObject.StateClient,
                        Plant: $scope.JobObject.JobDescription,
                        JobId: $scope.JobObject.JobId,
                        ShowAllDoc: $scope.allDocument
                    }
                });
            }

 

Is there a way to define a custom Document Name for my given TRBP file? 

Thanks

Bruno

prisma
Top achievements
Rank 1
 answered on 19 Nov 2020
1 answer
285 views

HI All, 
I currently have a report where i have a crosstab table that list staff and their respective logon time and break report. I would like to have a summary section at the top of the report and outside the cross tab so that we can indicate the staff with the heights break and the name of the staff.The orange area in the attachment.

Currently, i have attempted to use IFF function but it has not been successful as the true and false parts of the IFF functions are not only staff that meet the expression. I am currently using the following expression. 

=IIF((Fields.BreakDuration) > 0 AND Exec('table2', (Fields.BreakDuration)) <= Exec('table2', Max(Fields.BreakDuration)),
"Highest Agent Break Time: " + Fields.AgentName + " - " + Format("{0:00}:{1:00}:{2:00}"
                   , Truncate((Max(Fields.BreakDuration)) / 1000 / 3600)
                   , Truncate(((Max(Fields.BreakDuration)) /1000/60) MOD 60)
                   , Truncate(((Max(Fields.BreakDuration)) / 1000) MOD 60)
 ),"No Break Time ") 


Mads
Telerik team
 answered on 19 Nov 2020
1 answer
365 views

Hi, so glad to have found the web designer - thanks. I just used VS template to add it to a demo project and it worked well (apart from web.system import missing). On running the demo I tried to add a CSV Datasource and get this error:

    Could not save resource 'BOOKED.csv'.
    An error occurred while loading the data schema for "csvDataSource1": Invalid URI: The URI is empty.

Is there a quick config change needed in the project to allow uploads??

Also I tried to find documentation about the web designer and didn't find much beyond one page.  Do you have details on how to (programmatically/config) create an empty report and add 4-5 default datasources so the user has something to start with?

Thanks, Matt

 

 

 

 

 

Mads
Telerik team
 answered on 18 Nov 2020
6 answers
320 views

When you generate pdf you can set various pdf descriptions (DocumentTitle, DocumentAuthor, DocumentSubject, DocumentKeywords). If you use special chars "\().." Telerik automatically escape these chars with "\" or writes them direct if it possible.

We have problem when we use some our local chars. (some works some not)

Example: we put deviceInfo.Add("DocumentSubject", "Účtovný denník"); and the result is stored inside pdf file as /Subject(Ú\rtovný denník).

So Telerik automatically convert č -> \r, but only this one char.

We try:

1) set also deviceInfo.Add("DocumentNaturalLanguage", "sk-SK") but this doesn't help.  (A language identifier in accordance to RFC 1766 that specifies the natural language for all text in the document. If absent, the language will be retrieved from report's culture. Example value: en-US.)

2) we try put this char as numeric sequence "\226" but Telerik automatically correct it to "\\226" and result is string "\226"

Any clues? :-)

Ivan Hristov
Telerik team
 answered on 17 Nov 2020
1 answer
691 views

Hello,

in out ASP.NET application we used the "old" WebForms ReportViewer until recently.
Now we use the new Html5 ReportViewer, and I want to change the skin/theme (css) as descriped in the "CSharp.ReportExamples", using the "CSharp.WebFormsDemo".

With the "theme-switcher", I am able to switch the diffent themes in the ReportViewer.

 

 

When I try to integrate this example in my application, I get the following error in the browser console:

Uncaught (in promise) TypeError: e.children(...).kendoPanelBar is not a function
    at d (VM743 WebResource.axd:9)
    at new r (VM743 WebResource.axd:9)
    at HTMLDivElement.<anonymous> (VM743 WebResource.axd:9)
    at Object.each (VM743 WebResource.axd:9)
    at n.fn.init.I.fn.<computed> [as telerik_ReportViewer_SideMenu] (VM743 WebResource.axd:9)
    at HTMLDivElement.<anonymous> (VM743 WebResource.axd:9)
    at Object.each (VM743 WebResource.axd:9)
    at Object.bind (VM743 WebResource.axd:9)
    at init (VM743 WebResource.axd:9)
    at start (VM743 WebResource.axd:9)

I figured out that this line causes the error:

<script src="/api/reports/resources/js/telerikReportViewer-kendo"></script>

 

But without this line, I am not able to switch the theme, even not in the example.

 

How can I manage to use the "bootstrap"-theme in my application?

 

Just include this css does not work:

<link href="https://kendo.cdn.telerik.com/2020.1.114/styles/kendo.common.min.css" rel="stylesheet"/>
<link href="https://kendo.cdn.telerik.com/2020.1.114/styles/kendo.bootstrap.min.css" rel="stylesheet"/>

Thanks and Best Regards,

Ralph

Dimitar
Telerik team
 answered on 17 Nov 2020
3 answers
594 views

Hi,

I have recently upgraded Telerik Reporter Designer and Telerik package for Visual Studio for the newest available version which is possible to download from my company's account. Current Telerik Report Designer is R1 2018 and the Telerik.Reporting package in the project 12.0.18.416 - previously was 11.0.17.118.

For upgrading I have used Telerik Reporting Upgrade Wizard in Visual Studio. Everything worked fine, at least I thought so, because when I run the project locally, there is no problem. However, after uploading project to the dev environment the web application doesn't work. It throws error right from the start. Could you please tell me what am I doing wrong? How is it possible that everything work fine on the local machine and when uploaded to server it doesn't work at all? I'm attaching the printscreen of the error.

I really hoped that the upgrade will be smooth using the upgrade wizard and was very dissapointed to end up with broken project. I have spent many hours trying to find a solution, but I wasn't lucky.

Thank you in advance for any suggestions.

Todor
Telerik team
 answered on 16 Nov 2020
18 answers
3.5K+ views

How can I generate PDF from a .Net Core WebApplication?
I'm using the following code:

var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
var uriReportSource = new Telerik.Reporting.UriReportSource();
 
uriReportSource.Uri = "Report.tdrp";
 
var result = reportProcessor.RenderReport("PDF", uriReportSource, null);
 
var output =  result.DocumentBytes;
 
return File(output, "application/pdf");

 

But it gives me an exception:

System.BadImageFormatException: Could not load file or assembly 'System.Windows.Forms'

Todor
Telerik team
 answered on 13 Nov 2020
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Andrey
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?