Telerik Forums
Reporting Forum
3 answers
268 views

Hello,

I'm using Reporting R3 2016 10.2.16.1025.

in IE browser, print dialog show at the first time, and I close dialog or print to printer, the dialog will show again,

and I try again, the dialog is really closed.

 

 

at function printDesktop, I'm trying to write as follow, 

                setTimeout(function () {
                    document.body.removeChild(iframe);
                }, 3000);

It works at Adobe Reader version 19.021.20056, earlier version is not work.

It seems not a good solution, Do you have any idea?   Thanks.

 

 

Todor
Telerik team
 answered on 06 Dec 2019
8 answers
273 views
Version:  5.3.11.1116

On several reports, in group/report summary lines, I need to return the maximum date for the group.  What is returned instead by =Max(Fields.LastTranDate) is simply the LastTranDate value of the group. 

Data type of LastTranDate in database/entity framework:  datetimeoffset: 

How do I actually get the maximum date value rather than the value of the maximum row? 
Balen
Top achievements
Rank 1
 answered on 05 Dec 2019
1 answer
191 views

Hi, I have a query with a subquery works fine on sql, but when I use it as select statement on Configure Data Source Command  in my telerik report, this not work correctly, the results make me think the subquery don't works

This is my query in SQL

select * from apc_AlmacenProductoTerminado a
where a.SalidaAlmacen = 0 
and not exists
(select * from apc_AuditoriaALPC b
where b.FechaHora = @FechaAuditoria
and b.Boleta = a.Boleta)

The Telerik Query Builder give me this:

SELECT       a.Boleta, a.IdUsuario, a.FechaHora, a.Celda, a.Disponible, a.Vendido, a.SalidaAlmacen, b.NoEmpresa, b.Base, b.Boleta AS Expr1, b.Caja, b.NoCliente, b.Nombre, b.Camion, b.Fecha, b.HoraEntrada, b.HoraSalida, b.Familia, b.Material, 
                         b.Descripcion, b.Celda AS Expr2, b.Credito, b.Contado, b.PesoEntrada, b.Tara, b.Neto, b.Toneladas, b.Tarifa, b.Importe, b.Iva, b.Total, b.CostoTotal, b.Status, b.FechaFacturacion, b.FolioFactura, b.IdUsuario AS Expr3, b.NoGenerador, 
                         b.PesoCapturado, b.TaraCapturada, b.FolioPermiso, b.modificacion, b.firmado, b.firma, b.BasIN, b.BasOUT, b.UserIN, b.FolioFacturaContado
FROM            apc_AlmacenProductoTerminado AS a INNER JOIN
                         Boletas AS b ON a.Boleta = b.Boleta
WHERE        (a.SalidaAlmacen = 0) AND (NOT EXISTS
                             (SELECT       Boleta, IDUsuario, FechaHora
                               FROM             apc_AuditoriaALPC AS c
                               WHERE         (FechaHora = @FechaAuditoria) AND (Boleta = a.Boleta)))

 

But, when I run the report, the results not are correct, are there a restriction about this?

Cynthia
Top achievements
Rank 1
 answered on 05 Dec 2019
3 answers
226 views

Posted 9 hours ago (permalink)

Hello,

I used the trial version Q3 2009 for a while and made some reports with it, most crosstab reports and some straight forward reports.
Yesterday i diceded to buy the new Q1 2010 premuim set and deinstall the trial version and installed the licended (dev) version.

After using the upgrade wizard no one of the reports are working anymore.
The first problem is this warning for each report.

Warning 1 'Public Property DataMember() As String' is obsolete: 'Please use ObjectDataSource as DataSource and set its DataMember instead.'

After trying to fix it i decided to build a new report from scratch and when i use the SqlDataSource to connect to a database/table
the same warning appear.

This is the code from the designer

--------

'Report1 

' 

Me.DataMember = ""

Me.DataSource = Me.SqlDataSource1

----------
I  searched the KB but didnt find a answer.
So anyone who knows this problem please tell me the solution.

Kind Regards

Ferry Engels

Neli
Telerik team
 answered on 04 Dec 2019
1 answer
254 views

Hi there,

I am in the midst of designing a line chart where i need to calculate the difference between some of the fields of  the consequent rows. 

For eg: The object data source have a field of datetime. I want to find the difference between the datetime of the first row data and the second row data.

More like , = First(Fields.DateTime) - Second(Fields.DateTime) . Where the second means the next row or second row.

I tried using PREVIOUS data function but it is not working in my telerik version. Unfortunately i cant find the correct expression to do this nor i can add a data field in the data level itself. Is there any expression to do this requirement  ? 

Thanks in advance

 

    

Neli
Telerik team
 answered on 03 Dec 2019
6 answers
450 views

We want to separate report layout from data generation logic. 

Our data generation logic is a class like this:

 

class Generator

{

     public Data Generate(/* parameters here*/);

}

 

Where Data is like this:

 

class Data

{

     public List<RowType1> List1;

     public List<RowType2> List2;

     // other collections

}

 

In order to feed this data to a report definition (created in Standalone Report Designer),the only option seems to be ObjectDataSource. However, it only supports one collection at a time. Thus, we need multiple  ObjectDataSource-s to expose all collections. This will result in multiple calls to Generator.Generate(), which looks really problematic.

 

Is there any way to do this elegantly with Telerik Reporting, while avoiding multiple calls to report generation logic and avoiding UI/logic mix?

Dmytro
Top achievements
Rank 1
 answered on 03 Dec 2019
1 answer
153 views

I want to disable the default export feature and trigger a custom download when the export is selected. I can disable the default execution by 

args.handled = true;

Now I want to access an external service from the parent context. However the parent context is not available inside the exportBegin event. Is there a way I can achieve this?

 

 

 

 

Todor
Telerik team
 answered on 02 Dec 2019
4 answers
1.0K+ views

Hello,

as usually I have a table in my report.

In this case it is a table who shows travelling expenses.

And now I want to export the table datas in a csv file.

But the output is not that what I want.

Please see the attached file!

It is a jumble of datas with Layout information textBox1,textBox3,textBox2, and so on.

The column headings should appear only in the first line of the csv file.

I also have some textboxes with content Format("created on: {0:dd/MMM/yyyy HH:mm} ", Now()) and  "Reisekosten Report" in the report header, which should not appear in the csv file.

To make it short: How can I influence the output?

 

Best regards

Simon

 

Todor
Telerik team
 answered on 02 Dec 2019
6 answers
362 views

Hello, 

Using inline parameter in web Service Data Source works only when I put the parameter directly like in image 1. If I put the parameter with a expression like in image 2 the response errors like in image 3. Image4 is the working report with the parameter value set 29 directly.

This is the Report.cshtml that I using:

<link href="//cdn.kendostatic.com/2019.1.115/styles/kendo.common.min.css" rel="stylesheet" />
<link href="//cdn.kendostatic.com/2019.1.115/styles/kendo.blueopal.min.css" rel="stylesheet" />

<script src="/api/reports/resources/js/telerikReportViewer"></script>
<style>
    #reportViewer1 {
        position: absolute;
        left: 5px;
        right: 5px;
        top: 50px;
        bottom: 5px;
        overflow: hidden;
        font-family: Verdana, Arial;
    }
</style>



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

<script>
        $(document).ready(function () {
            $("#reportViewer1")
                .telerik_ReportViewer({
                    serviceUrl: "/api/reports/",
                    reportSource: {
                        report: "@ViewBag.Report",
                        parameters: {
                            idEvento: 29
                        }
                    },
                    viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
                    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                    scale: 1.0
                });
        });
    </script>
Guilherme
Top achievements
Rank 1
 answered on 28 Nov 2019
1 answer
218 views
We have purchased the license for telerik devcraft very recently for our product development . Recently we have stuck with telerik report integration with angular 7 . We have followed the steps which is mentioned in the below link
 https://docs.telerik.com/reporting/angular-report-how-to-use-with-angular-cli 

But there is no luck in finding the solution .

Issue:- We have developed simple api for fetching the data. HTTP GET verb is used in the api. From angular application we are able to make call to the api and api is responding the json result but the same is not rendering in the browser .
Todor
Telerik team
 answered on 27 Nov 2019
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?