Telerik Forums
Reporting Forum
3 answers
507 views
Is there a possibility to add condition to 'Action' setup? For example if Fields.* <> 0 then navigate to report/url, if not set 'Action' to none.
Neli
Telerik team
 answered on 09 Dec 2019
1 answer
479 views
I am using the HTML5ReportViewer and the reporting REST API
How can I add some custom HTTP headers to html5 report viewer to send it to the report service?
Todor
Telerik team
 answered on 09 Dec 2019
1 answer
720 views

Hi.

I'm using the standalone designer to design my report.  When I export to Excel, the gridlines are not visible (see attachec file, Gridlines.PNG).  How can I make them visible during export ?

Best regards,
Kalli Kaldi

 

Ivan Hristov
Telerik team
 answered on 09 Dec 2019
1 answer
411 views

Hello

I have a need to create a report, in PDF format, where the first page has a coloured panel down the right side with image, text near the top and logo/contact details down the bottom.  On the left side is the main information of the report.

The report has only main data row so I've currently got it all in the details section.

The first page shows fine, however on subsequent pages (of which i don't know how many there are), i need to:

1. continue the panel to the bottom of the page, and

2. the contact details section from the first page needs to show at the bottom of the right hand panel. 

Currently, the panel on the next page ends where the details section ends, not at the bottom of the page.  Is there a way to extend the panel to the bottom?

Is there a way to show fields/images at the bottom of the side panel?  I can't use a footer as it would mean there is too much white space on the left that should e used for the main part of the report.

I hope that makes sense to you.

Thanks for any help

Todor
Telerik team
 answered on 06 Dec 2019
3 answers
325 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
356 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
255 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
258 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
307 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
508 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
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?