Telerik Forums
Reporting Forum
9 answers
2.3K+ 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
701 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
800 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
375 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
129 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
120 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
41 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
2 answers
428 views

VS2013, Telerik Reporting Q1 2015, EF 6

I'm attempting my first Telerik Report, but I'm running into a pretty big stumbling point. I have an MVC 5 web app and a separate project with my EF code first data objects. Now I've added a Telerik Reporting project and I'm attempting to create some reports using the entity objects. I added a project reference to my data project - I'm not sure if this is necessary and it shows a small yellow triangle on the reference for some reason.

While creating a new report I choose to use an Entity Data Source. I'm presented with the connection strings it finds in web.config from my web app so I choose the one I'd like to use. On the next screen where it's asking me to choose a context (DbContext or ObjectContext) the box that's supposed to list my contexts is completely empty.

I'm stumped. I guess I could go back to the stand alone report designer and just use SQL to build my reports, but I really want to be able to manipulate the data and do my data selection for my report in code since I already have all my nice POCOs and relationships all built with EF. Is there a good, complete, end-to-end walkthrough for this? There are bits and pieces of documentation, but I haven't found anything that is a complete example all in one place.

Stef
Telerik team
 answered on 19 Jun 2015
1 answer
86 views
Hi guys,

I'm trying to rotate the label that indicates the value of the frame along the x-axis at the bottom of the graph, but I can't find how to edit this... I would like to have the months displayed horizontally and not diagonally

Someone know how can I edit this property?
Stef
Telerik team
 answered on 19 Jun 2015
1 answer
305 views

Hello guys. 

We are storing the TRDX files in the Windows Azure Cloud Storage in a Asp.Net MVC application. Given the *.trdx files are not on the disk, we need to verify at runtime (in a class that implements IReportResolver) if the report has a subreport. If it has, we try to get the trdx (xml content) an set the reportSource of a subReport as a XmlReportSource. Actually, we need to replace a UriReportSource to a XmlReportSource. It works when we do not have parameter, but does not work when we have parameters. Look at the code bellow:

// find a detail section and a subReport on it.
foreach (var section in reportInstance.Items.Where(i => i is DetailSection))
    foreach (var item in section.Items.Where(i => i is SubReport))
    {
        var subReport = (SubReport) item;
         
        // if the subReport is an UriReportSource
        if (subReport.ReportSource is UriReportSource)
        {
            // we try to convert the UriReportSource to XmlReportSource
            var subReportUriSource = (UriReportSource) subReport.ReportSource;
             
            // get an object that represents a report in our system
            var subReportViewModel = reportService.GetSubReportFileName(reportId, subReportUriSource.Uri);
 
            // create an instance of our helper to get the content from the windows azure cloud storage
            var storage = CloudStorageFactory.Create();
 
            // get the xml content
            var xmlContent = storage.GetContent(subReportViewModel.FileName);
 
            // create a XmlReportSource with the xmlContent
            var xmlReportSource = new XmlReportSource() {Xml = xmlContent};
             
            // set the parameters
            foreach (var parameter in subReportUriSource.Parameters)
                xmlReportSource.Parameters.Add(parameter);
             
            // set on the ReportSource
            subReport.ReportSource = xmlReportSource;
        }
    }
 

I am not sure if I can do it at runtime, or what I am doing wrong but it is giving an error like this:

 
Internal Server Error:
An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.Invalid value of report parameter 'PersonID'.

 

Does anybody know what I can try? 

 

Internal Server Error:
An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.Invalid value of report parameter 'PersonID'.
Internal Server Error:
An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.Invalid value of report parameter 'PersonID'.
Internal Server Error:
An error has occurred while processing the report. Processing canceled. Check the InnerException for more information.Invalid value of report parameter 'PersonID'.
Stef
Telerik team
 answered on 19 Jun 2015
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?