I have been unable to get a Report Preview to work in Visual Studio (I am using 2017). The specific problem is that when I run the preview, I get the error "Could not load file or assembly '(my assembly), Version=(the version), Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."

We require this custom assembly for various common lookups and data access, including accessing an S3  bucket using AWSSDK.S3.

Anyway, I have searched the web and these forums, and have tried dozens of solutions, none of which work. To prevent needless repletion of solutions that don't work, some solutions I have tried are on these links:

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

https://www.telerik.com/forums/report-preview-fails-due-to-dependency

https://www.telerik.com/forums/designer-use-when-code-references-external-dlls

There are others, too but all basically the same thing. Either the solution tells me to add the runtime assemblyBinding and AssemblyReferences to the app.config, or to put the assemblies in the folder where the Report Designer executable is (i.e., "C:\Program Files (x86)\Progress\Telerik Reporting R2 2018\Report Designer"). That later is pretty dumb, as we would need to copy it there each time we rebuild the assembly, and I hope its not the actually solution... Regardless, I tried both of these solutions, and both together at the same time, and they simply do not work. I continue to get the error.

Most of the posts about this are from years ago, however, so perhaps things have simply changed, and those solutions do not work any more. I am sure we're not the only people trying to use telerik reports that call out to custom libraries.

So, the question is, how do we get the Report Preview to work in VS2017 when the report needs to access functions in an external, custom assembly?

Thanks in advance!

Since the null-coalescing operator (??) and the IsNull function appear to do the same thing, I was wondering if there is a performance benefit of using one over the other.

Hello, I have report parameter and I dynamically change the data source in available values, then I'd like to pick the first value (it could be various) as default. How can I implement this since the attribute ReportParameters["proc"].Value just accept an object?

Is the only option to query the data manually from code and then send first item?

Thank you for your attention!

We have a report created with several CSV data sources. In one CSV data source there are two rows by default, but in the we only need the first row only. We cannot change the CSV data source because it is generated by a separate application. Is selecting only first row only to appear in the report can be done by the designer is this feature does not yet supported by it. 

 

Thank you. 

Hi, I have a question! ¿What happened after the 30 days trial ends? ¿If I already compile a solution those controls keep working normally or they have a kind of error after that?

Hi All,

We have experienced some issues with Telerik reporting service tool and that the logs are given below.

{"message":"","exceptionMessage":"Client with ID '044210-0ccb' not found. Expired.","exceptionType":"Telerik.Reporting.Services.Engine.InvalidClientException","stackTrace":"   at Telerik.Reporting.Services.Engine.PersistableCollection`1.get_Item(String itemID)\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.TouchClient(String clientID)\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.CreateReportInstance(String clientID, String report, Dictionary`2 parameterValues)\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.CreateInstance(String clientID, ClientReportSource reportSource)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

Can you please check this as soon as possible and provide your inputs to get it resolved.

Here's a video showing that. I'm using the integrated reporter from Visual Studio.

I was tasked with prototyping a new Telerik report using version 2018 R3 SP1 in Visual Studio 2017. I've searched the forum and the web but so far have not found a definitive answer to this question.

The report is somewhat complicated, with several sections, but the main section was best implemented as a banded report with a Graph in the detail section. Our existing reports use ObjectDataSource objects for the DataSource and this new report will follow suit. I tried passing the banded report a C# List<PrototypeItem> instance where the classes are:

public class PrototypeItem
{
public int Id { get; set; }
public string Location { get; set; }
public string Name { get; set; }
public string Type { get; set; }
public List<NumItem> Items { get; set; }
}

public class NumItem
{
public DateTime X { get; set; }
public double Y { get; set; }
}

PrototypeItem.Id is used as the group property (= Fields.Id) to distinguish the report bands. I found I could create a DataSource binding for the detail Graph, which I set to = Fields.Items. I set the Graph to have a LineSeries linked to a CartesianCoordinateSystem, a SeriesGroup and a CategoryGroup. The latter group I set to have Groupings = Fields.X and Sortings = Fields.X Asc expressions. The series had X = Fields.X and Y = Fields.Y.

When I run the report, it appears to give me the information I expect, with individual graphs having the X/Y data for the Id item in each band.

What I would like to do now is extend this report to provide more information in the graphs. In particular, I am interested in adding a straight horizontal line (possibly several) at a value that indicates to the user when the X/Y data has exceeded a certain "alert" level. However, I can't figure out how best to do this.

One approach I tried and found to work (albeit with limitations) was to add a another property to the NumItem class to define the "alert level". I added a second LineSeries to the Graph, linked it to the same category and series groups and defined the series X = Fields.X and Y = Fields.AlertLevel. The problem I have with this approach is that the horizontal line does not span the graph's entire X range if the main graph data does not also do so. I found that I could add two data points to the Items data list, one for the start date and another for the end date. While the alert level line spans the graph, unfortunately, this also introduces odd discontinuities in the raw data line between the end points of the graph and the first or last data points.

Ideally, it would be best to pass two line series, one for the raw X/Y data and a second for the alert level with just two data points: start date and end date as X values and the Y values as the alert level. I cannot determine if reporting supports this sort of operation. The main problem involves the DataSource binding for the Graph. How would one define classes to and set properties to make the Graph object "aware" of two (or more) line series?

I attempted one modification to my classes above. I changed PrototypeItem to replace List<NumItem> with a GraphData class property where:

 public class GraphData { List<NumItem> Items { get; set; } }

and changed the Graph binding expression to be = GD.Items (instead of = Items). When I ran the report this "sort of" worked but behaved strangely: each graph displayed a data line but all the graphs were identical (rather than the individual data for each Id). This also gave no indication how to bind a second List of NumItems in GraphData to a second line series.

I also occurred to me that I could try to create a separate report ObjectDataSource to retrieve the Graph data. However, I could not determine how to link the banded property Id to the function call so I did not attempt this.

Any thoughts about how to extend my report graphs?

Thanks.

I am currently using Report designer R2 2018. We have a table which spans across multiple pages. But at the end of each page, we can see left and right border printed even when there is no data. (shown in the image). Is this a normal behavior is this something we are doing wrong while designing the report? 

Hi,

We have a winform application which used telerik to show few reports.

When we try to view the reports with 150% scaling the reports are all skewed to the left with huge white spaces to the right.

One solution we found is to make our application DPI aware, that seems to fix the report issues but since our application is not built for scaling we cannot make it DPI aware without huge re writes!

Is there a way to fix with without making our application DPI aware?