I'm trying to pass a DataSet with two Data Tables to fill text boxes in the report header and report lines of the report. When I step the code and do a watch on the report, the text values are showing the correct values from the dataset, but when the report is displayed on my web form they are not there. It will just use the value of the textbox frpm design time? How do I get the report viewer to display the report with updated textbox values? I set the a report object equal to the method to update the textboxes that returns the updated report, then set that to the reportviewer's report property as I've seen in examples, but the textbox values are not updating?
I read earlier last year that you could not hide the toolbar in the ReportView control...is this still the case in the latest builds of the product? Also, is it possible to get the control not to display any scrollbars but the contents of the report, as is?
I am new in telerik reporting.i was create one report in webapplication
i have 12 text boxes in report . i need to arrange properly becz if i export to excel
the report will be collopsed and the text should not comes into single cells
how to arrange report rows into stright line
I need the ability to pass a RecordID to a report from a grid. The report is defined in a separate class (with a reference in the project containing the web forms) with the following code behind:
Imports System.ComponentModel
Imports System.Drawing
Imports System.Windows.Forms
Imports Telerik.Reporting
Imports Telerik.Reporting.Drawing
Partial Public Class GoalsCalculatorReport
Inherits Telerik.Reporting.Report
Public Sub New()
InitializeComponent()
Me.DataSource = Nothing
End Sub
Private Sub GoalsCalculatorReport_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.NeedDataSource
'Transfer the ReportParameter value to the parameter of the select command
Me.SqlDataAdapter1.SelectCommand.Parameters("@PandLID").Value = Me.ReportParameters("PandLID").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@NetProfitGoal").Value = Me.ReportParameters("NetProfitGoal").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@RaiseFeesByPct").Value = Me.ReportParameters("RaiseFeesByPct").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseCrownsPerWeek").Value = Me.ReportParameters("IncreaseCrownsPerWeek").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@ImproveAcceptanceRatePct").Value = Me.ReportParameters("ImproveAcceptanceRatePct").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@ReduceOverheadExpensePct").Value = Me.ReportParameters("ReduceOverheadExpensePct").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseNewPatientsFromMarketing").Value = Me.ReportParameters("IncreaseNewPatientsFromMarketing").Value
Me.SqlDataAdapter1.SelectCommand.Parameters("@IncreaseNewPatientsFromReferrals").Value = Me.ReportParameters("IncreaseNewPatientsFromReferrals").Value
'Take the Telerik.Reporting.Processing.Report instance and set the adapter as
'it's DataSource
Dim report As Telerik.Reporting.Processing.Report = CType(sender, Telerik.Reporting.Processing.Report)
report.DataSource = Me.SqlDataAdapter1
End Sub
End Class
And I've been using the following code to send grid data to another web form. I just don't know how to use a value from the grid in a report such that when I click on (a button on) a separate record of a grid, the report will show me the data for that particular record.
Protected Sub RadGridPLPS_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGridPLPS.ItemCommand
Dim itmITEM As Telerik.Web.UI.GridDataItem = CType(e.Item, Telerik.Web.UI.GridDataItem)
Dim cell As TableCell = itmITEM("PandLID")
' Response.Write(cell.Text)
Select Case e.CommandName
Case "Edit"
Context.Items("PandLID") = cell.Text
Server.Transfer("PLPStatEntry.aspx")
Case "Summary"
Context.Items("PandLID") = cell.Text
Server.Transfer("Summary.aspx")
Case "Analysis"
Context.Items("PandLID") = cell.Text
Server.Transfer("PracticeAnalysis.aspx")
End Select
End Sub
I would also like to use a similar process to be able to send data from the same web form (that contains the report viewer control) to the report. For example to create my own selection criteria fields and pass them to the report.
I have 3 tables that I need to pull information from for the report I'll be making (using Telerik Reporting).
tblCWMods (fields ProjectID, Phase, JobName, Dealer, etc.), tblCWModItems (fields ProjectID, Phase, LetterID, Modification), and tblCWModFiles (fields ProjectID, Phase, LetterID, downloadName, description). In my report I need the info from tblCWMods as the main part or grouping. For each report there will only be one main group. Within that, I may have several entries from tblCWModItems (related by ProjectID & Phase to tblCWMods) each having a unique LetterID. Within those groups there may be several entries from tblCWModFiles (related by LetterID to tblCWModItems). So my groups should be like this in the report:
I'm just wondering how I would go about grabbing all this information from my sql database and then apply it to a new report. I think I'm talking myself in circles on this one and have confused myself!! :) I'm using vb.net 2008 and I'm a beginner using Telerik Reporting. So any information would definitely be appreciated!! Please let me know if any other information is needed. Thanks in advance.
I am using Linq to SQL to populate generic non LINQ classes to display report data. I created a method to return a List<T> of the class to the Report Datasource in the report constructor. I also have a subreport in the details section of my report where I want to populate with data related to each line item of the main report. The problem is the NeedDataSource is only called once and results in the first line item contains nothing in the subreport and every line item after that has data from the first line item.
My question is, how do I get a subreport in the details section to contain data related to its containing line item?
I would like to migrate some complex reports from Crystal to telerik. But one feature gives me a headache.
We have created hundreds of text modules containing preformatted text with MS Word and stored them in a BLOB column as OLE Object. Crystal ist able to extract those OLE objects and renders them to display them in the report.
Can this also be done with telerik?