Telerik Forums
Reporting Forum
4 answers
326 views
I'm writing to see if anyone else has experienced this issue before or if Telerik has been contacted by any other clients with a similar problem.  We have several reports that ran just fine a number of weeks ago which now return errors from Oracle.  All of the reports that are having problems utilize stored procedures.  The reports run without issue in Studio, but when executed from a web application (both locally and test server) the following message is returned every time "An error has occurred while processing Report 'ReportName': ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'ProcedureName' ORA-06550: line 1, column 7: PL/SQL: Statement ignored".  In trying to isolate the issue I created a basic report that calls a SQL Data Source with a stored procedure which just has a select * from tablename statement and only contains a cursor parameter 'CUR_RESULT OUT SYS_REFCURSOR' it runs fine in Studio, but the same error occurs in the web application.  If I move the sql statement to the report instead of the stored procedure it runs fine in both Studio in from within the web application.  I don't know if something changed on our Oracle server or Windows Update.  I've tried with three versions of Telerik reporting including the latest.

When I use a sql monitor and run the report from Studio I can see a call to bms_utility.name_resolve with the procedure name and then the actual procedure call. 

begin dbms_utility.name_resolve('Schema.ProcedureName',1,:schema,:part1,:part2,:dblink,:part1type,:objectnum); end;
begin Schema.ProcedureName(CUR_RESULT=>:CUR_RESULT); end;

I'm unable to currently profile or monitor when running the report from in a web application on IIS to see what calls are made and results returned.

Thanks

Stef
Telerik team
 answered on 18 Sep 2015
3 answers
565 views

I have a problem unsing Telerik.ReportViewer.WPF.ReportViewer. 

I have a report with a table wich is goint to show a very large text in each item... but in report viewer text shows cut off, when export report to PDF text shows normal. How can i fix ???

Stef
Telerik team
 answered on 18 Sep 2015
1 answer
115 views
I am using Telerik Reporting Q2 2015 and it works perfect when running it out of VS in debug mode.  Once I deploy it to an intranet site I start receiving an error

Internal Server Error:
An error has occurred.
Access to the path 'C:\windows\TEMP\Application1\9.1.15.624\LCT\value.dat' is denied.  

Since the server and the dev machine are one in the same (at this point) I was confused why I would get this error.  On the surface this appears to be a permissions issue, but I'm not sure.
Stef
Telerik team
 answered on 18 Sep 2015
6 answers
423 views

Hi,

 I have a SalDataSource, and I ​wrote queries inside there instead of store procedure. Everything works, the reports generates without any issue but in the report design, I can not see the list of the fields, I need to type it manually, is there anyway to get around it so I can see the fields because my query is very complicated and I need to use temp tables, moreover, the project team decide not use any store procedure. thanks

 To make is simple, here is the sample to reproduce the issue:

1. sqldatascource =

"select * into #abc FROM tableAbc

select * from #abc"

2. In the "field expression", I want to display the value in fieldD column by using : "Fields.fieldD" but it is empty, I cannot click on anything. However, I can manually type it and the report works without any issue.

 

thanks!

 

Robert
Top achievements
Rank 1
 answered on 17 Sep 2015
1 answer
113 views

I have an kendo report where i load a table. My problem here is that i want to load another table inside that table. I want to call my action method that looks like this:

 

     [DataObjectMethod(DataObjectMethodType.Select)]
        public IList<QuoteInfoItemDto> GetQuoteInfoItemsAccessories(int projectItemId)
        {
            return quoteItemModel.GetAccessories(projectItemId);
        }

The problem here is that i use an parameter projectItemId but the projectItemId is always the same and it's always of the last item in my (parent) table. How can i post the id of the current (parent)table so that i can fetch the data from my actionmethod to the (child) table?

Nasko
Telerik team
 answered on 17 Sep 2015
8 answers
161 views
I've got a report with multiple tables in it.  It's worked perfectly in v Q2 2010.

I just upgraded to Q3 2010 Reporting and now get the following table errors on multple tables (some table render fine, others return the following error:

(the table is displayed as a red box with the following error)

An error has occured while processing Table 'table 10':
Group with name 'Group6' already exists.  Groups should have unique names.

I followed the upgrade instructions for major release.  Everything else seems to be working fine, except the error above.  Any suggestions? Thanks in advance.
Nasko
Telerik team
 answered on 17 Sep 2015
1 answer
96 views

In trying to use the HTML 5 Web Form Viewer from the 2015 Q2 release I have ran into one issue. What I am trying to do is use viewer as a generic viewer for one of several reports that will will be loaded later. Each report is different with different parameters, etc.

I am not looking to set a report source at page load or beforehand. But everytime I do not set the report source it receive and Object reference not set....

Is it possible to use html 5 web report viewer server control without setting the reportsource before runtime?

Nasko
Telerik team
 answered on 17 Sep 2015
1 answer
56 views

Hello Telerik,

 I have certain group hierarchy in cross tab report. I want to show group data value always for the child record also .  Please see the attached image for more clarification.

Thanks,

Pritesh Akhani

Nasko
Telerik team
 answered on 17 Sep 2015
1 answer
324 views

Hi,

I am using object datasource in my application and ReportDesigner as described here:

http://www.telerik.com/support/kb/reporting/details/how-to-use-external-assemblies-with-custom-user-functions-in-the-report-designer

My solution is to copy reportdesigner exe and config file into my project dir and add relative path to build dir (bin/Debug) of my application.

This was ok for 2015 Q1. When I switched to 2015 Q2 reportdesigner stopped working with this exception:

[2015-09-15 09:58] FATAL: An error has occurred. Restarting...
System.ArgumentException: 'Telerik.Windows.Controls.TransitionEffects.FadeTransition' is not a valid value for the 'Telerik.Windows.Controls.RadFluidContentControl.Transition' property on a Setter.
   at System.Windows.Setter.Seal()
   at System.Windows.SetterBaseCollection.Seal()
   at System.Windows.Style.Seal()
   at System.Windows.StyleHelper.SealIfSealable(Object value)
   at System.Windows.ResourceDictionary.SealValue(Object value)
   at System.Windows.ResourceDictionary.SealValues()
   at System.Windows.ResourceDictionary.AddOwner(DispatcherObject owner)
   at System.Windows.ResourceDictionary.PropagateParentOwners(ResourceDictionary mergedDictionary)
   at System.Windows.ResourceDictionary.OnMergedDictionariesChanged(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
   at System.Collections.ObjectModel.ObservableCollection`1.InsertItem(Int32 index, T item)
   at Telerik.ReportDesigner.App.MergeResourceDictionaries()
   at Telerik.ReportDesigner.WorkbenchHost.RunWorkbench()
   at Telerik.ReportDesigner.WorkbenchHost.Start()


Finding cause of this problem was not easy. It looks like this line in reportdesigner config file:

<probing privatePath="bin\Debug"/>

makes reportdesigner to load telerik assemblies from this location instead of program files and reportdesigner uses different version of telerik assembiles than my application.

I changed probing to reporting\bin\Debug where my assembly for reporting is build and problem was fixed. Of course this works because my reporting.dll assembly does not depend on telerik libraries.

But proper solution force reportdesigner to load all telerik assemblies with version it was compiled against.

Nasko
Telerik team
 answered on 17 Sep 2015
3 answers
215 views

Getting exception after adding new report in report book

 

{"message":"","exceptionMessage":"Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index","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.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\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.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\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.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"}

Stef
Telerik team
 answered on 17 Sep 2015
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?