Telerik Forums
Reporting Forum
1 answer
2.6K+ views

HI Guys,

 

I am new to telerik report designer, i have trying to create a report that consists of 3 sections.

Section 1 is a summary of a team, section 2 is the average of staff, and staff stats.

I am having difficulty with the average row as i need to sum the values of each agents "Calls to Success" stats and divided by the number of agent which is 3.

So i should be getting 5.14.

 

Any idea guys.

 

Thanks

 

 

Neli
Telerik team
 answered on 10 Dec 2019
2 answers
197 views

Hi to all. 
I'm new here.

I want to show reports dynamically. In Windows Forms I have no problems but in MVC is more confusing I think.
I call a service (WCF) that returns a Telerik.Reporting.Report object. 
It has all I need, datasource,  report parameters etc.

Then in windows all I needed to do was (figura1) and the result is awesome (figura0)

In MVC  the page recieve a report (figura2)
This report is saved here (figura3)
But when I show the report in the viewer it is empty (figura4)

Sb can help me please.
Thanks in advance

Christian
Top achievements
Rank 1
 answered on 09 Dec 2019
1 answer
142 views
How do I create something like this in a table or cross table in telerik reporting?


Column 1|Column 2|Column 3|Column 4
Group A
Item 1 
Item 2                                                          
                                Sub Total     Total


Group B
Item 1 
Item 2                                                         
                                Sub Total   Total
Simon
Top achievements
Rank 1
 answered on 09 Dec 2019
3 answers
485 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
459 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
673 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
378 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
302 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
331 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
227 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
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?