Telerik Forums
Reporting Forum
6 answers
462 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
129 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
198 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
108 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
68 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
355 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
233 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
3 answers
350 views

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

Nasko
Telerik team
 answered on 17 Sep 2015
2 answers
119 views

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 Sub
 
End Class

 

Where am I going wrong?

Thank you,

David

David
Top achievements
Rank 1
 answered on 16 Sep 2015
1 answer
413 views

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

 

Stef
Telerik team
 answered on 16 Sep 2015
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?