Telerik Forums
Reporting Forum
2 answers
212 views

Does the new viewer support reports in a class library? I thought this may work, however I am receiving this error:

Type 'Telerik.ReportViewer.Html5.WebForms.ReportSource' in Assembly 'Telerik.ReportViewer.Html5.WebForms, Version=9.1.15.624, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' is not marked as serializable.

 This is the code I am using to display the report. 

Protected Sub CmdReport1Click(sender As Object, e As System.EventArgs) Handles cmdReport.Click
    If Page.IsValid Then
        Dim typeReportSource As New Telerik.ReportViewer.Html5.WebForms.ReportSource
        Dim val As New Telerik.ReportViewer.Html5.WebForms.Parameter
        val.Name = "MYMONTH"
        val.Value = txtRep1Parameter1.Text
        typeReportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource
        typeReportSource.Identifier = "IntranetReports.Admin.OfficeManager.CeBooking, IntranetReports"
        typeReportSource.Parameters.Add(val)
        ReportViewer1.ReportSource = typeReportSource
    End If
End Sub

Thank you

Scott

Scott
Top achievements
Rank 2
 answered on 26 Jun 2015
1 answer
63 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
165 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
78 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.4K+ 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
737 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
847 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
417 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
148 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
126 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
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?