Telerik Forums
Reporting Forum
1 answer
195 views

Good Evening All,

 

Hope you are keeping well in the current climate.

I have a form with a report viewer on that am i am trying to set the report that viewer will display at runtime.  I have the following code to do this.

 

Dim ReportViewer As New FrmReportViewer
Dim NotificationReport As New rptNotificationPrintOut
Dim strCommand As String = "SELECT tblNotifications.URN, tblNotifications.Sender, tblNotifications.Reciever, tblNotifications.Date_Sent, " &
"tblNotifications.Time_Sent, tblNotifications.Title, tblNotifications.Details, tblNotifications.Notification_Type, tblusernotifications.status " &
"FROM tblNotifications INNER JOIN tblUserNotifications On tblNotifications.URN = tblUserNotifications.Notification_ID WHERE " &
"tblUserNotifications.User_ID = '" & strUserID & "'"
 
Dim sqlReportDataSource As New SqlDataSource(strCommand, strConnectionString)
NotificationReport.DataSource = sqlReportDataSource
 
Dim DisplayReport As New InstanceReportSource
DisplayReport.ReportDocument = NotificationReport
ReportViewer.ReportViewer1.ReportSource = DisplayReport
 
ReportViewer.Show()

 

This code is displaying the report viewer form however it is not loading and displaying the report.

Thanks in advanced for the assistance

Frosty

Todor
Telerik team
 answered on 20 May 2020
3 answers
307 views

Hi,

I have been following https://docs.telerik.com/reporting/web-report-designer-setup-in-net-core to add the web report designer to an aspnetcore project both on .net core 2.1 and 3.1 and I am getting javascript errors because of these files:

<script src="..../js/telerikReportViewer"></script>

<script src="..../js/webReportDesigner"></script>

The article does not explain where are these references and how they work. And also why do you have to register services  in a different class instead of the ConfigureServices method of Startup.cs?

Peter
Telerik team
 answered on 18 May 2020
9 answers
691 views

I'm trying to set things up for the first time in a .Net Core ASP 3.1 Application.

My ReportsController appears to be recognized properly (the constructor is called with the IReportServiceConfiguration) and the client attempts to call:

 

api/reports/resources/js/telerikReportViewer (with a ?_=<number> on the end)

 

But i'm getting this error:

"Message": "An error has occurred.","ExceptionMessage": "An item with the same key has already been added. Key: Cache-Control"

 

Full:

{

"Message": "An error has occurred.","ExceptionMessage": "An item with the same key has already been added. Key: Cache-Control","ExceptionType": "System.ArgumentException","StackTrace": " at System.Collections.Generic.Dictionary`2.TryInsert(TKey key, TValue value, InsertionBehavior behavior)\r\n at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)\r\n at Microsoft.AspNetCore.HttpSys.Internal.HeaderCollection.Add(String key, StringValues value)\r\n at Telerik.Reporting.Services.AspNetCore.ReportsControllerBase.GetResourceCore(String folder, String resourceName, Type type)\r\n at Telerik.Reporting.Services.AspNetCore.ReportsControllerBase.GetResource(String folder, String resourceName)\r\n at lambda_method(Closure , Object , Object[] )\r\n at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)"

}

Ivan Hristov
Telerik team
 answered on 18 May 2020
0 answers
120 views

hello 

i want to Displaying data with alternating-style rows and  i used your code RowNumber()%2 = 1 or 0 in conditional formatting but is it not working for me!

i show you in this video 

Video Link

please help me

Sardar
Top achievements
Rank 1
Veteran
 asked on 18 May 2020
3 answers
1.9K+ views

Hi,

I use a multi-value Parameter to select a subset of data in an IN clause.

On SQL Server if the User selects a lot/all of the possible values, this occasionally leads to the following error:

 

Too many parameters were provided in this RPC request. The maximum is 2100.

 

Since SQL Server does not support arrays as parameters, I assume the reporting engine does some magic to rewrite the parameters to

IN(@p1, @p2, @p3 ...)

Is there a way to workaround the problem, for example by using a temporary table with the parameter values?

Regards

Erwin

 

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 15 May 2020
1 answer
484 views

Is it possible to display server timezone in this format "DD-Mmm-YYYY hh:mm:ss timezone" in Telerik Reports

For Example -

Example 1: "13-May-2020 03:30:53 AM EST".
Example 2: "13-May-2020 12:30:53 AM PST".
Example 3: "13-May-2020 01:30:53 PM IST".

Nasko
Telerik team
 answered on 15 May 2020
2 answers
410 views

Hello,

We have a web application (front end - Angular and back end - .Net c#) that will work on Cloud.
We are using Telerik report designer to create reports. Currently user can view designed Telerik reports inside application through telerik Angular report viewer.

What we want to do: we want user (not developer) to be able to change Telerik report inside application and save them for later use.

We know that Telerik Web Report Designer allows us to customize reports inside web application. 

But there are no resources or documentations on how to implement it in an Angular application.

we wonder if anyone has tried Web Report Designer on Angular applications before and appreciate

if they can share their knowledge/experience.

Thank you

Ray
Top achievements
Rank 1
 answered on 15 May 2020
1 answer
242 views
Is there a way to add conditional logic in Report Parameters dropdown?  For Example, i have a Report parameter dropdown which has values like 'Select All', 'One','Two','Three','Four'. Also i have made this dropdown to be multi select.
Now if i select 'Select All' option, the other values in the dropdown should be disabled and if i select other values like 'One','Two' or 'Three', then 'Select All' option should be disabled.
Is this feasible in Report parameters of Teleik Reporting?
Katia
Telerik team
 answered on 15 May 2020
8 answers
274 views

Hello, i was trying to implement the designer in a NETCore 3.1 application but the examples in the code and in the site documentation only points to NETCore 2.1

When i try to change the example to NETCore 3.1 i have a lot of errors.

Is there anyway you can point me in the direction of how to achieve this? Thank you

Peter
Telerik team
 answered on 15 May 2020
7 answers
299 views

Hello, i am trying to use WebReportDesigner in my NetCore Angular application, but i don't seem to get it to work whatever i do.

Can you please provide an example on How can i achieve this? Thank you very much

Veronika
Telerik team
 answered on 14 May 2020
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?