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

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.
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.
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?

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

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?

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
