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!
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?
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?
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
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.
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()"}
Hi All,
I have been using report viewer from past many months with textbox layout for detail section.
Recently I switched from textbox layout to Table layout for detail section owing to issues like anchoring etc.
Now, I am facing a big issue of pagination where in all the data of the report is getting displayed on a single page.
There was no such issue with textbox layout.
Any help shall be appreciated.
Regards,
Anurag
Created a report in the standalone designer and need to utilize it form within Visual Studio. I have a parameter in both the SQL query and a report parameter, both named Cust_ID.
In trying to utilize the uriReportSource, as described in other forum posts, I get an error message as seen in the attached screenshot.
The statement.trdx is in the same directory as my view_statement.aspx page that is trying to render it within the rptstatement viewer.
This is my code:
Public Class view_statement Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim report As New Telerik.Reporting.UriReportSource() report.Uri = "statement.trdx" If Request("Cust_ID") IsNot Nothing Then Dim CustID As Integer = 0 If Integer.TryParse(Request("Cust_ID").ToString(), CustID) Then report.Parameters.Add(New Telerik.Reporting.Parameter("Cust_ID", CustID)) End If End If rptStatement.ReportSource = report End If End SubEnd Class
Where am I going wrong?
Thank you,
David
My site is deployed to IIS and is hosting the HTML5 ReportViewer. When accessing the ServiceURL over HTTP everything is working. When access the ServiceURL over HTTPS I'm getting an error "CANNOT POST /myreports/api/reports/clients".
Am I missing a step here ?
BTW - My site is a NodeJS site, hosted on IISNode, with an Angular front-end.
Thanks,
Ciaran