Hi have a requirement to generate a grid of photos.  

I have managed to get the data in the shape where this can be grouped in a cross-tab.  The photos I need to bind to have a filename of {id}.jpg in a known folder.  I have created a user function that accepts the Fields.Id, retrieves this photo and returns an image (this is a technique I've used before successfully).

I have added a picturebox into the detail of the crosstab, but whenever I go to bind the "value" of the picturebox to the user function, Visual Studio crashes.  Stack trace below.  I suspect as this is in the detail it's trying to apply some aggregate to it.  Are there any workarounds to do this binding at runtime to get around this designer bug?

Application: devenv.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ArgumentNullException

Server stack trace: 
   at System.Linq.Enumerable.Cast[TResult](IEnumerable source)
   at Telerik.Reporting.Design.Common.Utils.AggregateFunctionHelper.GetAggregateFunctions(IServiceProvider provider)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.<GetAggregates>d__28.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.FillAggregates(Category funcCategory, IServiceProvider provider)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.CategoryAdapter.CreateHierarchy(IServiceProvider provider, Boolean isFieldsTreeVisible)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog.LoadCategories(IServiceProvider provider)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(System.Runtime.Remoting.Messaging.Message, Boolean)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(System.Object, System.Runtime.Remoting.Proxies.MessageData ByRef)
   at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog+LoadCategoriesDelegate.EndInvoke(System.IAsyncResult)

Is there a way to define multiple color palette for a same bar series and based on the parameters selected by user the graph shall automatically pick appropriate color palette for the series?

I am struggling to make our pie charts look good and be useful -- here are the two issues (somewhat related):

• The pie chart is connected to the same data source as a crosstab report, with the same groupings. Sometimes there are 20+ rows of data, and I want to display them all in the crosstab, but would like to only display the biggest 10 items on the pie chart, with the rest grouped under "Other." Is this possible?
• I would like to sort the order that wedges appear in the pie chart by size. Sorting by Field.MyNumber doesn't work because I actually want to sort on Sum(Field.MyNumber), but I get an error from the designer telling me I can't order by aggregate.

Are there solutions to these two items?

Ok, I have a report that is set to TextAlign = Justify.

I have a text box in the report that is set to TextAlign = Left. The text in the text box wraps to a second line.

When I run the report, the text is Justified, not aligned left, as specified for the text box.

Is this a bug, or does the TextAlign at the report level over-ride the alignment set at the text box level?

I've included screenshots that demonstrate this.

Thanks!

Hi Support,

We are tried to setup web application on new server

We have install the telerik reporting on new server but still we are getting the following error

"Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=10.1.16.615, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified."

For more error details please find the attached  snap

Please suggest/Guide

Thanks

Mahendra

Hello,

I am using standalone report designer and I use this line of code to toggle culture based on parameter

Culture = IIf(Parameters.Language.Value = "en","en-US","fr-CA") in databinding

This works well for numbers currencies, and percentages on tabs, cross tabs etc but NOT charts.

Does charting library have a different initialization process? It seems that once chart is created, the culture remains static.

P.S. Culture of the Chart is (Default), setting value is not in bold font. 

Please advise

Thanks

Hi,

I created report in telerik report designer R3 2016, where i added a table, the report is working fine but the exported file is giving missing edges.what should i do to resolve this?

I have attached an image of the same, please have a look.

My reports that I am using in an WPF application just to print directly to a printer have some issues after the upgrade. We also had an issues when we upgraded last year.

Here is where the report is called

      string orderIds = "153461,153567,153843,153845,153872,153942,153966,153985,154210,154252,154298,154363,154382,154411,154431,154437,154463,154471,154521,154538,154556,154560,154631,154650,154686,154687";  
var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

      var typeReportSource = new Telerik.Reporting.TypeReportSource();
      typeReportSource.TypeName = typeof(Accounting.Reports.RptPostedDeposits).AssemblyQualifiedName;
      typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumbers", orderIds));
      var px = new System.Drawing.Printing.PrinterSettings();
      reportProcessor.PrintReport(typeReportSource, px);

Then in my Needs_Datasource event of the report I have something like

      if (this.ReportParameters[0].Value.ToString() != "")
      {
        string sqlQuery = "Select O.OrderID, Case When D.PayorName = '' Then CAL.SubAccountName Else " +
          "SUBSTRING(CAL.SubAccountName, 0, 7) + '-' + D.PayorName End as Customer, D.EntryDate, D.PaymentNumber, D.PaymentTypeID, " +
          "D.TotalDeposit, D.AmountAppliedToInvoice, O.GrandTotal, D.PostedToCyma, ISNULL(O.PostedDate, ISNULL(O.ShipDate, GETDATE())) as PostedDate " +
        "From FCMDB.dbo.FcoOrders O " +
        "JOIN FCMDB.dbo.CustAccountLocations CAL ON CAL.AccountLocationsID = o.AccountLocationID " +
        "JOIN FCMDB.dbo.AcctDeposits D ON D.OrderID = O.OrderID " +
        "Where O.OrderID IN (" + ReportParameters[0].Value + ")";
        SqlConnection cn = new SqlConnection(MyConnection);
        cn.Open();
        SqlCommand cmdGet = new SqlCommand(sqlQuery, cn);
        DataTable dtGet = new DataTable();
        dtGet.Load(cmdGet.ExecuteReader());
        cmdGet.Dispose();
        cn.Dispose();

//This line we changed in 2016 because just setting the this.datasource would no longer reference the current report
        (sender as Telerik.Reporting.Processing.Report).DataSource = dtGet;
        //this.DataSource = dtGet;
      }

Now I need to access the parameter through the sender object. If I leave it the way it is currently the parameter is blank. Is this something that has been done intentionally? If so why isn't an email or something sent out about it or adding it into the whats new?