Telerik Forums
Reporting Forum
2 answers
646 views

I'm using the standalone Telerik Report Designer and I have to display items like below.

Let's say I have two tables Company, Employee.

 

CompanyName | NumOfEmployees | Location 

Google |  1,000 | United States

Apple | 900 | Unites States

Samsung | 700 | Korea

 

CompanyName | EmployeeName | Age

Google | James | 39

Google | Jane | 23

Apple | Catherine | 30

Samsung | Bob | 23

Samsung | Jully | 32

Samsung | Nicolas | 43

 

I wanna display like below

 

Google   |    United States   | 1,000 employees

         James |   39

         Jane    |   23

 

Apple     |    United States   | 900employees
         James |   39
         Catherine | 30

 

Samsung  |   Korea     | 1,000 employees

         Bob | 23

         Jully | 32
         Nicolas | 43

 

 

I have 2 stored procedures, one for company list and the other for employee list with the company name parameter.

How can I do this?

Donald McLean
Top achievements
Rank 2
 answered on 28 May 2020
18 answers
1.2K+ views
I've been experimenting using the stand alone report designer with an objectdatasource. After updating the ReportDesigner config file to include the assembly names, the only assemblies that appear are those that are created with the .net framework. Assemblies created with .net core are not visible. Is this correct behavior? Or is there something I need to add to the the .net core class library so they are visible?
Todor
Telerik team
 answered on 26 May 2020
2 answers
647 views
Hello,
I'm trying to use conditional formatting to uniquely format a whole row in a report. The condition I'm using is a property of the row itself, not of any particular value. In this case, the boolean property I'm using to determine whether to format the row is called, "IsSummaryRow".  If it's true, then I format the row.  The problem I'm coming across is when there are blank or missing values in the row (which is common), the conditional formatting doesn't get applied. The boolean property is not affected by the other values in the row. I'm using an object data source.
I've attached a screenshot so you can see what I mean. 
I'd appreciate your help.

Chris
Kieron
Top achievements
Rank 1
 answered on 25 May 2020
12 answers
563 views

Hi all,

I have installed Telerik controls first and then installed Telerik reporting on win 7 64bit but only telerik report are not showing in visual studio 2008 and 2010 both.

Kindly let me know how to resolve this issue , I have to develop sample report and give the demo as my company is willing to purchase any RAD controls, I have proposed Telerik controls as I'm familiar with it.

Thanks

Leo

Todor
Telerik team
 answered on 22 May 2020
0 answers
89 views
Hey y’all, i currently have a textbox on my first page that can hold quite a few words. If all the space is taken, these words are cut off. I would like to put these cut off words on a second page in a new textbox(I guess a new textbox?) is this possible? Thank you
Dylan
Top achievements
Rank 1
 asked on 21 May 2020
1 answer
345 views

Reporting version 2019 R3 SP1 (13.2.19.1213)

In the Standalone Designer, with a .trdp file open, you can see the fields from the data source in the Data Explorer. For me, these come from a stored procedure.

If change the stored procedure to add/remove columns, then click the "Refresh" icon at the top of the Data Explorer, nothing happens; Data Explorer still shows the old items. Closing/re-opening the Reporting tool will fresh the Data Explorer list. You should not have to close/re-open. Isn't that what the "Refresh" button is for?

Todor
Telerik team
 answered on 21 May 2020
7 answers
843 views

Hello

I have issue when I use report parameters programmatically.

When I chose Category return 3 record it show 3 similar table

I want when I chose Category return 3 record it only show 1 table.

Thanks

Thien

Katia
Telerik team
 answered on 21 May 2020
1 answer
168 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
279 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
657 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
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?