Telerik Forums
Reporting Forum
1 answer
574 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
328 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
262 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
268 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
186 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
220 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
252 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
443 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
152 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
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?