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?

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

 

    

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?

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?

 

 

 

 

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

 

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>

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 .

I am implementing Telerik reporting in my already writen WPF Project. The Project has only microsoft WPF controls but when I make a report with telerik reporting and add resource dictionary sources from Telerik.ReportViewer.Wpf.Themes.dll in APP.XAML  file it effects all my Microsoft controls in entire project. I need solution that limit telerik themes to its report control only. Please guide me with detail I am newbie in Telerik reporting, Thanks

I am using telerik reporting R2 2019 version.

Code

 

APP.XAML

<Application x:Class="BMS.App"
             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
             Startup="Application_Startup" DispatcherUnhandledException="Application_DispatcherUnhandledException" 
        
             SessionEnding="Application_SessionEnding" Exit="Application_Exit" >
    <Application.Resources>
        <ResourceDictionary>
            <ResourceDictionary.MergedDictionaries>
                <ResourceDictionary Source="/Telerik.ReportViewer.Wpf.Themes;component/Themes/Fluent/System.Windows.xaml" />
                <ResourceDictionary Source="/Telerik.ReportViewer.Wpf.Themes;component/Themes/Fluent/Telerik.Windows.Controls.xaml" />
                <ResourceDictionary Source="/Telerik.ReportViewer.Wpf.Themes;component/Themes/Fluent/Telerik.Windows.Controls.Input.xaml" />
                <ResourceDictionary Source="/Telerik.ReportViewer.Wpf.Themes;component/Themes/Fluent/Telerik.Windows.Controls.Navigation.xaml" />
                <ResourceDictionary Source="/Telerik.ReportViewer.Wpf.Themes;component/Themes/Fluent/Telerik.ReportViewer.Wpf.xaml" />
            </ResourceDictionary.MergedDictionaries>
        </ResourceDictionary>
    </Application.Resources>
</Application>

This Code effect all my micrsoft controls

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I am using alll references from this folder only.

C:\Program Files (x86)\Progress\Telerik Reporting R2 2019\Bin

 

 

 

 

Hi,

We have UWP app that contains WebView element to show Telerik report. The WebView has HTML5ReportViewer which communicates via Telerik Rest Service to show the report. There are two questions I have in UWP.

- First question is how to download report?

- Second question is how to print the report(with having some printer settings in UWP)?