Hi. I try to use this example for create dynamically generated report. I'm want grouping output as described here.Only one change in code from documentation it change

to

 

As I understood this allow me output row with col1=1 in separate group with footer and header,  col1=2 in separate group with footer and header, and two col1=4 with separate group. But it not work as expected. I see one header, one footer and all data between this header and footer.
What I do wrong?
Thank you in advance.

I have the Color and BackgroundColor bound in conditional formatting. When the foreground is supposed to print white it just comes out black. It only happens on certain printers, however I can create a notepad document with the same colors and it prints correctly. Any advise on how to fix the issue?

Hi,

I've recently migrated from Q2 2011 to Q1 2013 and I can't seem to get the value of the parameter in code behind. I use this value to get the data in the ItemDataBinding event.

And I want to get the selected value in the ItemDataBinding event, but it is always null or it keeps the value if I set it 
manually.
this.ReportParameters["GroupBy"].Value.ToString()

If I add a textbox in the editor with its value set to :Parameters.GroupBy.Value then the selected field is bound correctly. 

Thanks for you help.

Edit: In fact I just realised that the way I'm getting the parameters value doesn't work at all and isn't specific to a report parameter with available values. So I've written my question again to be less specific.

I have a report where someone could pass in a parameter to show "Detail" for the record.  The "detail" is tied to a second  within the Telerik Report.  I am unsure of how to get it to fire and show as it should.  I have added the primary  and displays the records in the group header.  

Attached is an image of what my report looks like SQLDatasource1 is the primary  and uses parameters passed in to display.  If input parameter DetailFlag = true then I want to show the Detail Record which is tied to SQLDataSource2.  

Tried the following in the code-behind but not displaying.

Does Telerik Reporting for ASP.Net offer a built-in way to control access to reports based on either the user name or user role (using ASP.Net membership)? Is there a best practice for managing data access? I'm not sure that SQL Server security will be of much use, since the connection will typically be made with a service account for ASP.Net, rather than the individual user's account.

One of the reports on my company's product, which uses Telerik Reporting R3 2016, is intermittently generating an error about resolving the dsGiftCard object data source that it uses. Sometimes, the report viewer says that it is unable to create a report instance, while other times it says that it is unable to get the parameters. The error only occurs on our deployments and not on our local builds. Our local builds load the report much faster. Usually the report loads fine, but this error generates on such a random basis my team is having trouble tracking it and finding out the cause. We're hoping someone here at Telerik can help us resolve this issue.

exceptionMessage: "An error has occurred while resolving 'dsGiftCard' data source: An error occurred while invoking data retrieval method."
exceptionType: "Telerik.Reporting.Processing.Data.ObjectDataSourceException"
message: "An error has occurred."
stackTrace: " at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveAsMethodInvocationOnTarget(Type type, Func`1 resolveTarget, String dataMember, ObjectDataSourceParameterCollection parameters, Object& result) ↵ at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveAsMethodInvocation(Object dataSource, String dataMember, ObjectDataSourceParameterCollection parameters, Object& instance) ↵ at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.ResolveDataSource(Object dataSource, String dataMember, Boolean evaluateParametersValues) ↵ at Telerik.Reporting.Processing.Data.ObjectDataProviderBase`1.ResolveDataSource() ↵ at Telerik.Reporting.Processing.Data.ObjectDataEnumerable.ResolveEnumerable() ↵ at Telerik.Reporting.Processing.Data.ObjectDataEnumerableBase.GetEnumerator() ↵ at Telerik.Reporting.Processing.Data.SeedDataAdapter.GroupData(IEnumerable`1 rawData) ↵ at Telerik.Reporting.Processing.Data.SeedDataAdapter.Execute(IEnumerable`1 data) ↵ at Telerik.Reporting.Processing.Data.ResultSetAdapter.Execute(IEnumerable`1 data) ↵ at Telerik.Reporting.Processing.Data.MultidimentionalDataProvider.Execute(MultidimensionalQuery query) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameterProperties(P parameter, IReportParameter parameterDef, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.Calculate(P parameter, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateChildren(P parameter, IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameters(IDictionary`2 parameterValues) ↵ at Telerik.Reporting.Processing.DocumentParametersManager`1.CalculateParameters(IDictionary`2 values, Boolean ensureCalculated) ↵ at Telerik.Reporting.Processing.DocumentParametersManager`1.GetMergedParameters(IDictionary`2 values) ↵ at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource) ↵ at lambda_method(Closure , Object , Object[] ) ↵ at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters) ↵ at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() ↵--- End of stack trace from previous location where exception was thrown --- ↵ at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) ↵ at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) ↵ at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"

 

Here is the C# method that the data source gets its data from:

 

 

Hi,

 

One of our customer has an issue to selected item from report parameters dropdown.

 

When dropdown is opened first time, all items shows correctly. After item selection, the first item disappear!?

 

This happens only IE 11 (version 11.2244.14393.0), no problems with Firefox or Chrome

 

What could cause this behavior?

 

BR,

Auvo

 

 

 

 

Hello,

I am binding table one of columns with Panel that has textbox and picturebox. I am giving Picturebox1.value="{Fields.[RowIcon]}", where RowIcon is byte[] contains image byte. Text box value comes properly  as per its binging expr. but for picture box it says invalid image data while processing picutre box.

I also tried changing RowIcon type to Image. But got same error.

Please help.

Regards,
Manish

I have a Web Application using Telerik.Reporting.Services.WebApi with Html5 ReportViewer with a custom controller, where depending on the report type it uses a custom resolver.
There are 3 different report types and each one uses a HostAppId with a custom resolver. The storage is a Telerik.Reporting.Cache.File.FileStorage pointing to the same path for all 3 report types.

But after starting the application and generating the first report type, the other 2 types generates information in the storage path, but the report does not display any information, always being '0 pages loaded so far ...'.
It opens infinite requests - one after another - to an url like this "~/clients/085352-e708/instances/083615-c3d7/documents/085412-2b2a085412-5cbd/info" giving the same json response for them all:
{
"documentReady":false,
"pageCount":0,
"documentMapAvailable":false,
"bookmarkNodes":null,
"documentMapNodes":null
}

I believe that somehow by changing HostAppId, the cache is lost. How I fix this?

ReportBaseController

public class ReportBaseController<TReportResolver> : ReportsControllerBase
   where TReportResolver : IReportResolver, new()
{
   protected virtual string HostAppId { get; }

   protected string ReportCachePath => HttpContext.Current.Server.MapPath($"~/App_Data/reportcache");

   public ReportBaseController()
   {
       if (!Directory.Exists(ReportCachePath))
           Directory.CreateDirectory(ReportCachePath);

       this.ReportServiceConfiguration = new ReportServiceConfiguration
       {
           HostAppId = this.HostAppId,
           ReportResolver = new TReportResolver(),
           Storage = new Telerik.Reporting.Cache.File.FileStorage(ReportCachePath)
       };
   }
}

Controllers of the 3 different report types:

public class ReportSystemController : ReportBaseController<SystemReportResolver>
{
   protected override string HostAppId => "ReportSystem";
}

public class ReportClientController : ReportBaseController<ClientReportResolver>
{
   protected override string HostAppId => "ReportClient";
}

public class ReportListController : ReportBaseController<ListReportResolver>
{
   protected override string HostAppId => "ReportList";
}

Why are the two versions of Telerik.Reporting.OpenXmlRendering not included in the telerik nuget feed? This makes deployment especially difficult. Is there some way around this other than having to add the dll to my own source control?