Telerik Forums
Reporting Forum
1 answer
81 views

Hello Telerik team, 

This issue focuses on one that arises when attempting to export a report in CSV format. 

 As you will see from the attachments, we have a report where two totals are listed on the last two rows of the Report Viewer.  When this report is exported to CSV, those totals are instead duplicated numerous times as two additional rows to the right of the report.

 

 Several files are attached and I believe they will speak for themselves.  This is a significant issue for my company and we are hoping to be able to solve this issue in the very near future. 

 Please let me know if there is a way we can remedy this problem ourselves.  All of the relevant files are attached. 

Thank you for taking the time to review our problem, and we are looking forward to your prompt responses and feedback.

Warmest regards,

 

Tariq Abulaila

Software Engineer,

NCR Corporation Small and Medium Business Team

 

 

 

 

Nasko
Telerik team
 answered on 26 Jun 2015
1 answer
186 views

I am having trouble adding a sub report to my report.  I have created a subreport web page (VB.net).  Here is the code that works for adding the details but the subreport doesn't get displayed.  The top table is the subreport.  Any help is greatly appreciated.

'bottom table
Dim rptReport As New rptMSVS
rptReport.DocumentName = tmpStartDate.ToString("MM.dd.yyyy") 'tab name
rptReport.DataSource = dtBottom

'top table
Dim rptSummary = New sbrSummary
rptSummary.DataSource = dtTop

Dim reportBook As ReportBook = New ReportBook
reportBook.Reports.Add(rptSummary)
reportBook.Reports.Add(rptReport)

'add the sheet to the report
rptMSVS.Reports.Add(rptReport)
rptMSVS.Reports.Add(rptSummary)

 

'display the Report
Dim rptProcessor As New Telerik.Reporting.Processing.ReportProcessor()
Dim instance As New InstanceReportSource()
Dim hshTable As New Hashtable()
instance.ReportDocument = rptMSVS
Dim result As Telerik.Reporting.Processing.RenderingResult = rptProcessor.RenderReport("XLS", instance, hshTable)

rptViewer.ReportSource = instance
rptViewer.DataBind()

Mark
Top achievements
Rank 1
 answered on 25 Jun 2015
3 answers
95 views

I recently upgraded from Q1 2014 to Q2 2015 and now I am having issues on any reports that I prompt for parameters. In the past when I opened the report, I would get an error, but the user could enter the parameters and then properly run the report (See ss1.png). Now I just get an error and no parameters (see ss2.png). Here is what I use for my display code in my MVC Razor page:

 

         @(Html.TelerikReporting().ReportViewer().Id("reportViewer1").ServiceUrl("/api/reports/").TemplateUrl("/scripts/reportviewer/templates/telerikReportViewerTemplate-9.1.15.624.html").ReportSource(new TypeReportSource() { TypeName = "PortalReports.HelpDesk.DeptTicketSummary, PortalReports"}).ViewMode(ViewModes.INTERACTIVE).ScaleMode(ScaleModes.FIT_PAGE_WIDTH).PersistSession(false))

 

What am I missing? The only thing that has changed is the version.

Nasko
Telerik team
 answered on 25 Jun 2015
9 answers
2.5K+ views
Hi,

I am trying to load a simple report in a asp.net mvc web application using TypeReportSource.
But it shows "Internal Server Error: Value cannot be null. Parameter name: key" while making request to the following url

http://localhost:47829/api/reportsApi/clients/154917-9738/instances/154821-14b1/documents/154821-7d50154821-9a39/info

The response:

{"message":"","exceptionMessage":"Value cannot be null.\r\nParameter name: key","exceptionType":"Telerik.Reporting.Services.Engine.DocumentRenderException","stackTrace":"   at Telerik.Reporting.Services.Engine.Document.GetDocumentInfo()\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.GetDocumentInfo(String clientID, String instanceID, String documentID)\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetDocumentInfo(String clientID, String instanceID, String documentID)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"}

how to resolve this error? same report is working perfectly with wpf application.

Telerik Reporting version Q1 2015 SP1.

Thanks
Doug
Top achievements
Rank 2
 answered on 24 Jun 2015
9 answers
780 views

Hi

I've downloaded trial verion of telerik reporting to try functionality what I need. On demos I haven't seen option to export report to DOCX (i don't know why) also when I tried to export it manualy with RenderingResult result = reportProcessor.RenderReport("DOCX", reportToExport, null); but  I've always seen "DOCX rendering format is not available." message.

Could the trial version be a reason?
Have someone had issue like this?

Best regards
Waclaw

Stef
Telerik team
 answered on 24 Jun 2015
2 answers
919 views

Hi,  Using a textbox in the report to display a date, we can use {0:d} to get a short date, e.g. 01/02/2015, but in our app we allow the user to specify their own format string on a per user basis, so we pass that in as a parameter (typically to get an even shorter format, e.g. 01/02/15).  In the Format field for a TextBox is it possible to use an expression, e.g. =Parameters.dateFormat.Value ? 

 As background we are evaluating converting from SSRS to Telerik reporting, and in SSRS this is possible by just using Parameters.dateFormat.Value in the Format field, but in Telerik this does not seem to work.  I can see that this is possible to do in the Value field using an expression on the lines

 =sFields.startEventDtm.ToString(Parameters.dateFormat.Value)

 But this will fail with a null reference exception of startEventDtm is null, whereas using  a format string will handle the null neatly.

Scott Waye
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 23 Jun 2015
13 answers
495 views

I have a VB.NET web application (4.0) Telerik Reporting Q1 2013.  What I need to do is something like tabs in excel where each tab is a different date.  I have datatables to bind the report to.  The online documentation is not as good as I hoped it would be so any direction would be greatly appreciated.

Thanks

Nasko
Telerik team
 answered on 23 Jun 2015
4 answers
177 views

Hi there,

 I am trying to figure out couple of things on reports that are driving me crazy for past few days. Any pointers would be appreciated:

Background-

We are using Telerik.Reporting to display stacked column charts. The data is bound using a stored proc and bound to the chart using declarative properties. The data returned back by sp is fairly simple:

Type  Name Total

T1      N1      20

T1      N2      05

...

T2     N1       03

T2     N3       05

...

The sp parameters are bound to report parameters and we have a filter on Type (i.e. at a given point of time you are viewing the graph for one type). The graph is on Name and total (Y-axis). Now the issues that we have is:

1. Setting individual bar width dynamically - the number of names that can be returned are dynamic, if only two names are returned the individual bar's width is too much making it look ugly. What we would like to accomplish is setting max-width of a bar somehow.

2. Y-axis scale - If we don't set the scale and the Total returned is a small number, it shows the scale in decimal which doesn't make sense for most of our reports (since they are on Person and other whole numbers). I don't want to hard-code the "MajorStep" of Scale to a number since I still want the scale to be adjusted dynamically based on the "Total" that is being returned, so if the "Totals" are 500, 100 I would rather prefer the MajorStep to be 50. Basically, I want to limit the number of Major ticks and then step the Step based on that, something like say I want to have only 10 major ticks and if the highest total returned is 550, I would want to set  my Major step to 550/10 = 55 or somewhere around that.

Let me know if any further information is needed.

Nasko
Telerik team
 answered on 22 Jun 2015
1 answer
145 views

I have downloaded the reporting demo version for VB.Net. On opening either Telerik report Q1 2015(Blank) or Telerik report Q1 2015 Wizard I'm getting  error: Framework is not supported.

I'm running VS Professional 2013 version: 12.0.30723.00 update 3

.Net framework version 4.5.51650 multi targeting pack

Stef
Telerik team
 answered on 22 Jun 2015
1 answer
76 views

I try to create simple ASP MVC application with Telerik Reporting. But I do not see report. And There are not errors.

 

Here is source code

** The linked is removed by admin. Please do not publish publicly telerik Dev assemblies - Telerik End User License Agreement for Telerik Reporting and Telerik Report Designer***

Please help

Stef
Telerik team
 answered on 19 Jun 2015
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?