Telerik Forums
Reporting Forum
3 answers
153 views

Hi All,

 

I have created a report in visual studio with two static datasources on it for testing purposes while in development to ensure that the report shows the data correctly.  I have two one for the main report and then there is a table on the report which has another datasource.  If i preview the report everything works as i would expect.  I then have the following code to create the form and assign the datasources dynamically at runtime so that i can select the correct data from the mysql database based on users input.

Dim ReportViewer As New RadfrmReportViewer
           Dim NotificationReport As New rptDCN
           Dim strMainDataCommand As String = "SELECT * FROM tbldcns WHERE dcn_id = '" & lstDCNs.SelectedItem.Tag & "';"
           Dim strPartsDataCommand As String = "SELECT part_name FROM tbldcn_inc_prts WHERE dcn_id = '" & lstDCNs.SelectedItem.Tag & "';"
 
           Dim mysqlReportMainDataSource As New SqlDataSource(strMainDataCommand, strDBConnectionString)
           Dim mysqlReportPartsDataSource As New SqlDataSource(strPartsDataCommand, strDBConnectionString)
 
           NotificationReport.DataSource = mysqlReportMainDataSource
           NotificationReport.rpttblParts.DataSource = mysqlReportPartsDataSource
           NotificationReport.txtFooter.Value = "Printed on {Now()} By " & System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Replace(Environment.UserName, ".", " "))
 
           Dim DisplayReport As New InstanceReportSource
           DisplayReport.ReportDocument = NotificationReport
           ReportViewer.ReportViewer1.ReportSource = DisplayReport
           ReportViewer.ReportViewer1.ZoomMode = Telerik.ReportViewer.WinForms.ZoomMode.FullPage
           ReportViewer.ReportViewer1.RefreshReport()
 
           ReportViewer.Show()

 

However when i now run the application and run the code i am getting the error that's attached.

 

 

 

I have double checked the SQL strings and the connection string including copying and pasting them exactly into the static data sources and its still not working.  I'm sure that i am doing something wrong but i can't see what at all.  Please can someone assist me with this.

 

Also the strDBConnectionString variable is also used in several other locations including to populate a listcontrol which allows the user to select the item they wish to generate the report for and that is all working as expected.

I have also double checked the SQL and connection strings at runtime to ensure that they are populating correctly.

Thanks in advanced

Luke

Todor
Telerik team
 answered on 01 Jun 2020
1 answer
1.7K+ views

Hello,

Is there a way to make a part of the expression value as Bold in the Edit Expression window in Telerik reporting.

As shown in the screenshot, I need to format a piece of the expression to Bold font.

In the Edit expression for the Legend value "= Fields.LegendName + '  ' + Fields.TotalCnt"

I want something like 'ABC 30' where ABC is the Fields.LegendName and 30 is the Fields.TotalCnt

I need to make the value 30 as bold.

Neli
Telerik team
 answered on 01 Jun 2020
2 answers
177 views

I am using a Telerick graph inside my WPF application.  I am not seeing a way to enable scrolling either horizontal or vertical on the graph.  I am not using xaml. My report is called EmployeeReport (EmployeeReport.cs, EmployeeReport.Designer.cs, EmployeeReport.resx)  Just to review, my EmployeeReport.cs is implementing the interface Telerik.Reporting.Report.  The constructor of EmployeeReport.cs receives an IEnumerable which is applied as the datasource to the graph.  

The graph values change and the graph size is staying the same. All the items are getting mixed together.  

Summary, how do adjust the graph to be one size and scroll  both horizontal or vertical.

 

Rich Schone
Top achievements
Rank 1
Veteran
 answered on 29 May 2020
2 answers
688 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
704 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
596 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
105 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
384 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
886 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
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?