I am receiving the following error (used Fiddler to find it) when attempting to load ReportViewer on IIS 10 on Windows Server 2016. I do not receive the error when running locally (from VS 2015). I am using v12.0.18.227 of Telerik.Reporting, Telerik.ReportViewer.Mvc, and Telerik.Reporting.Services.WebApi. The process runs using telerikReportViewer-12.0.18.227.js.

This report has additional lookups defined for drop-downs (as partially displayed in "Localhost_working.png").

 

HTTP/1.1 500 Internal Server Error
Cache-Control: no-cache
Pragma: no-cache
Content-Type: application/json; charset=utf-8
Expires: -1
Server: Microsoft-IIS/10.0
X-AspNet-Version: 4.0.30319
Persistent-Auth: true
X-Powered-By: ASP.NET
Date: Tue, 26 Jun 2018 15:14:11 GMT
Content-Length: 5953
{"message":"An error has occurred.","exceptionMessage":"Exception has been thrown by the target of an invocation.","exceptionType":"System.Reflection.TargetInvocationException","stackTrace":"   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n   at Telerik.Reporting.Processing.Data.SqlProviderFactory.DeriveParameters(IDbCommand command) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlCommandProvider.cs:line 175\r\n   at Telerik.Reporting.Processing.Data.SqlCommandProvider.ResolveProcedure(IDbCommand command, SqlDataSourceParameterCollection parameters) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlCommandProvider.cs:line 311\r\n   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommandCore(IDbConnection connection, Boolean evaluateParameters) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlQueryProvider.cs:line 119\r\n   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateCommand(IDbConnection connection) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlQueryProvider.cs:line 91\r\n   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext() in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SimpleDataSources\\Sql\\SqlDataEnumerable.cs:line 117\r\n   at Telerik.Reporting.Processing.Data.SeedDataAdapter.GroupData(IEnumerable`1 rawData) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SeedDataAdapter.cs:line 144\r\n   at Telerik.Reporting.Processing.Data.SeedDataAdapter.Execute(IEnumerable`1 data) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\SeedDataAdapter.cs:line 119\r\n   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Execute(IEnumerable`1 data) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\ResultSet.cs:line 22\r\n   at Telerik.Reporting.Processing.Data.MultidimentionalDataProvider.Execute(MultidimensionalQuery query) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing.Data\\MultidimentionalDataProvider.cs:line 48\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.CalculateParameterProperties(P parameter, IReportParameter parameterDef, IDictionary`2 parameterValues, Boolean parentChanged) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 317\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.Calculate(P parameter, IDictionary`2 parameterValues, Boolean parentChanged, Boolean& valueChanged) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 267\r\n   at Telerik.Reporting.Processing.ReportParametersManager`1.RecalculateParameters(IDictionary`2 parameterValues) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\ReportParametersManager.cs:line 172\r\n   at Telerik.Reporting.Processing.DocumentParametersManager`1.CalculateParameters(IDictionary`2 values) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\DocumentParametersManager.cs:line 113\r\n   at Telerik.Reporting.Processing.DocumentParametersManager`1.GetMergedParameters(IDictionary`2 values) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Processing\\DocumentParametersManager.cs:line 129\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource) in c:\\temp\\reporting\\RBuild-18700\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.WebApi\\ReportsControllerBase.cs:line 166\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetExecutor>b__3(Object instance, Object[] methodParameters)\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.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.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.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.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.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()"}

Greetings.

I'm just learn how to use telerik reporting app, It still run fine when i'm test it on telerik report designer (pic 1), but when i'm run it on browser the parameter input field not show (pic2)..  i already have set parameter to visible on designer tho.

did i miss something ? , can someone help me ? .. i need it ASAP.

Thanks :)

here's my controller 

 

and my view :

 

 

I am trying to use Telerik Reporting in a WPF application based on the Prism MVVM platform.  After much trial an error, I was able to get the report viewer to display the report but could not get the report a second time without closing the window and reopening it.

In Prism, there can only be one Window control, so I had to change the report viewer to a UserControl. 

Has anyone been able to get this to work reliably in Prism?

Hi all

When rendering reports inside a WindowsService the CurrentUICulture is taken from the users configuration and CAN NOT be changed. Within a normal executable this works fine. In general.. To have the localisation depending on the threads culture is not always a good way to control the language output. Is there another way to force localisation for a certain culture? and if not, this would be a big issue to solve!

 

Many thanks

Sascha Bauer

Hello,

 

I'm using Angular Report Viewer and I'm getting the error as in attached image when I'm trying to load my report into the viewer using REST Web API service. 

I can see in dev tools that the url that is failing is.
http://localhost:55504/api/report/clients/706df770722/parameters

and that the request payload is {report: "test.trdp", parameterValues: {EmployeeID: 31, Year: 2018}}.

 

This is happening in development environment. I'm using latest VS 2017 and Telerik Reporting 12.1.18.620

Hi,

How can I customize the Telerik report parameter controls? I am using  AngularJs as the front-end development. We already customized the vertical parameter area into horizontal by overriding the custom CSS class of the report parameter area template. Can we access data from the Telerik report parameter API and manipulate using the angular js directive?

 

Hi,

I've created a report whose filter label may change.  I'm passing the filter label in as a parameter but when I go to set the label text, the filter label is not appearing when the page first opens and the report includes all data.  When I change the filter or dates and the report refreshes, the filter label is then displayed.  I'm setting the label to the parameter.FilterLabel.Value but again, it doesn't display until the report is refreshed after the initial report is displayed after opening the page.  Any ideas on how to get this filter label to display when the page opens?

 

I've include a pic of what the filter looks like when the page first opens and after a filter is selected.  I'm passing the string 'Department' in as a parameter.

 

Thanks,

Jim

 

I was successfully running Telerik Reporting R2 2016 (Telerik_Reporting_R2_2016_SP1_10_1_16_615_DEV.)   in my VS 2015. Recently I upgraded from VS 2015 to 2017 . Now I am unable to edit/create new reports in VS 2017 Report Designer as the Telerik Reporting Toolbox and Menu items are missing in VS 2017.

I can open the report file in Report Designer though.

Here is a snippet of a TRDX

    <PageHeaderSection Height="0.899999936421712in" Name="pageHeader">
      <Items>
        <TextBox Width="4.07916673024496in" Height="0.400000015894572in" Left="0.0208333333333333in" Top="0.0208333333333333in" Value="Workspaces" Name="reportNameTextBox" StyleName="PageInfo" />
        <PictureBox Url="~/images/logo.png" Width="1.79999987284342in" Height="0.700000047683716in" Left="4.63750012715658in" Top="0.0208333333333333in" Sizing="ScaleProportional" MimeType="" Name="pictureBox1" />
      </Items>
    </PageHeaderSection>

I am trying to specify the image relative the virtual directory (this is not a web site) of the place where the report controller resides (REST API)

What is the correct syntax?

Hi,
I am creating the report with standalone designer. 
My sample datasource will be like this below,

Data Source
-----------
Name,QtyValue,DateTime
S001,100,2018-05-01
S001,200,2018-05-02
S001,300,2018-05-03
S001,50,2018-05-04
S001,250,2018-05-05
S001,100,2018-05-06
S002,200,2018-05-02
S002,30,2018-05-04
S002,100,2018-05-05

In my report group footer, I would like to display the 
Maximum/Minimum Qtyvalue and the DateTime value for that maximum value. 
I tried to use the expression 
IIF(Fields.QtyValue =  Max(Fields.QtyValue), Fields.DateTime, "")

It didn't work. Can you guys please advise me how to achieve.

Expected
---------
Name: S001

Max                                        Min
Value         Date                     Value            Date
300            2018-05-03          50                 2018-05-04


Actual
-------
Name: S001
Max                                Min
Value  Date                    Value          Date
300                                 50              

Thanks in advance.