Telerik Forums
Reporting Forum
4 answers
521 views

Hello,

Long time reader, first time poster.

I have been searching the web for reporting to be used in both ASP.NET (preferably using MVC Razor) and supports exporting both the data and the charts/graphs associated with the data into Excel.

 

So far, the closest I have come is sealreport.org (demo here: http://demo.sealreport.org/temp/Dashboard_-_Sales_t0n4u_htm.htm), but since I have already used Telerik's Kendo solution in the past, I would prefer to leverage your reporting solution.

 

My asks:

1. Does Telerik reporting have the ability to export reports to Excel that includes both the data used to create the reports, as well as excel-interactive graphs themselves (see http://demos.telerik.com/reporting/dashboard... it just downloads images. I would add the .XLSX file generated by sealreport, but only images are allowed).

2. Is it possible to use an HTML5-like styling with the reporting (CSS styling, or something, reactive, etc - my only experience is that it is very structured and limited with what you can do in the designer)?

 

Please and thank you.

 

Best,

ZH

 

 

Edward
Top achievements
Rank 1
Veteran
Iron
Iron
 answered on 16 Feb 2017
7 answers
258 views
Hi!

I've been trying to follow the steps in the documentation, but when I try to run the service all i get is a TypeInitializationsException
when

new ReportsHost().Init();

is called, because of a MissionMethodException inside the ServiceStack dlls

Method not found: 'Void ServiceStack.Text.JsConfig.set_DateHandler(ServiceStack.Text.JsonDateHandler)'.

Any Idea how to solve this?

Thanks,
Roxana
Stef
Telerik team
 answered on 15 Feb 2017
3 answers
483 views

Hi Forum,

Has anyone found that when exporting a report from the viewer and choosing the "Excel Worksheet" option from the format dropdown that all negative values in a report grid are preceded by a single apostrophe (')?  I know single apostrophes in excel are used to escape formulas, but the negative sign (-) should not be interpreted as a formula in excel when placed in front of a numeric value so I'm not sure why there would be a need to add apostrophes.

Thanks,

Derek

Stef
Telerik team
 answered on 15 Feb 2017
1 answer
46 views
Hi,

In our application we perform a report refresh by using ReportViewer.RefreshReport(). After this refresh the preview is always jumping to the top position of the report.
Is there a way to keep the old position so the user hasn’t to scroll down after every refresh? For example by jumping back to the cursor position which I already know from the OnInteractiveActionEnter event?

Thanks and kind regards,
Markus
Stef
Telerik team
 answered on 15 Feb 2017
3 answers
336 views

Dear Telerik team

 

Our report layout is according to the images in the appendix and displays a list with mechanical checkpoints:

- tableCheckpoint (always displayed)

- panelSpareparts (only visible if Fields.Parts.Count > 0)

- panelImage (only visible if Fields.ImageRows.Count > 0)

 

Further:

- All dockings are set to "Top"

- The parent panel "panelCheckpoint" has a binding for Height: = '12mm'

 

The parent panel "panelCheckpoint" is resizing correctly except for the case panelImage = visible and panelSpareparts = not visible (see image).

I tried to set "panelCheckpoint" binding Height by formula (to a manually calculated value) but if the Height value is smaller than '12mm' the list is not showing all checkpoints (is this a bug?).

Any suggestion what I should do?

Thanks and regards

Markus

Stef
Telerik team
 answered on 15 Feb 2017
1 answer
272 views

Hello,

we are currently trying out Telerik Reporting / Report Server for usage in our product. Our software product publishes an read only OData service as an interface for report generators. Because Telerik Reporting has no built-in Support for OData we tried to use the "cdata OData ADO.NET Provider" in the standalone designer.

When adding a SQL Data Source to a Report we are successfully able to select the cdata Provider and connect to the OData Northwind sample Service (see screentshot #1). But then in step #3 "Configure data source command" the query builder is not available and the select statement fails with an error message (see screenshot #2). The select Statement works fine in Visual Studio Server Explorer.

Is there anything we can do to get it working?

 

Best regards
Holger

Stef
Telerik team
 answered on 14 Feb 2017
9 answers
348 views
when I export a simple list of items to an excel worksheet (I bound to a collection of business objects, accepted basically the defaults). I get an error that excel recovered unreadable content and that it needs to repair.

The log shows the following:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<
logFileName>error530880_01.xml</logFileName>
<
summary>Errors were detected in file 'SignalListReport2.xlsx'</summary>
-<
repairedRecords summary="Following is a list of repairs:">
<
repairedRecord>Repaired Records: Cell information from /xl/worksheets/sheet.xml part</repairedRecord></repairedRecords>
</
recoveryLog>

How do I fix this?
Stef
Telerik team
 answered on 14 Feb 2017
1 answer
1.2K+ views

In the Designing Reports doc, it says:

 Now() Returns the current date and time on the computer processing the report, expressed as the local time.

I have a server to generate the report,  so the Now() = server local time.   Server can be deployed to anywhere ( UTC offset can be any value)

I want to show client local time Now() in the report.  How can I implement it? 

Stef
Telerik team
 answered on 13 Feb 2017
1 answer
84 views

Hi,

We encounter the issue with DatePickerFor in Google Chrome. When we use date control in MVC View as follow, it's not populating date value from the database.

@Html.Kendo().DatePickerFor(r => r.ReturnDate)

It's give us blank in edit screen as well. Can you please provide solution for that?

 

Thanks

 

Stef
Telerik team
 answered on 13 Feb 2017
1 answer
312 views

Hi,

I have used Telerik label report with Avery 5160 and it give me following format for 7 records.

A D G

B E

C F

I need the layout like follow. How can I get that?

A B C

D E F

G

Please provide information to change the layout.

 

Regards,

Mark

Stef
Telerik team
 answered on 13 Feb 2017
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?