Sir, I have taken a table with four textboxes in it, which are assigened different fields that are fetched from the database by using the NeedDatasource event of the table.
Private Sub table1_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles table1.NeedDataSource, table1.NeedDataSource
Dim ds2 As New DataSet()
Dim table As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)
objReporting = New Reporting
Dim category As String
Dim category1 As String
category = Me.ReportParameters("officecode").Value
category1 = Me.ReportParameters("Postcode").Value
objReporting.OfficeCode = category
objReporting.OfficeGroup = category1
ds2 = objReporting.FetchSalary()
Dim view As DataView = ds2.Tables(0).DefaultView
view.Sort = "TotalSalary DESC"
table.DataSource = view
End Sub
Me.lblPresentPost.Location = New Telerik.Reporting.Drawing.PointU(New Telerik.Reporting.Drawing.Unit(0.099999986588954926, Telerik.Reporting.Drawing.UnitType.Inch), New Telerik.Reporting.Drawing.Unit(0.40000009536743164, Telerik.Reporting.Drawing.UnitType.Inch))
Me.lblPresentPost.Name = "lblPresentPost"
Me.lblPresentPost.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(0.91458332538604736, Telerik.Reporting.Drawing.UnitType.Inch), New Telerik.Reporting.Drawing.Unit(0.17500001192092896, Telerik.Reporting.Drawing.UnitType.Inch))
Me.lblPresentPost.Value = "= Fields.presentpost"
for further details please see the attached doc file
thanks
Ankit
I have attempted to install (after downloading) Telerik_Reporting_2009_3_1211_dev.msi.
I turned all options on to be installed. The installation completed successfully.
From start menu, I selected, Visual Studio 2008 Examples project.
When I attempt to view the WebDemo:
1. I see the choice of reports, I clicked on the Invoice and received:
| Server Error in '/WebDemo' Application. |
| -------------------------------------------------------------------------------- |
| Attempted to read or write protected memory. This is often an indication that other memory is corrupt. |
| Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. |
| Exception Details: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. |
| Source Error: |
| Line 13: { |
| Line 14: Type reportType = Type.GetType(reportName); |
| Line 15: IReportDocument report = (IReportDocument)Activator.CreateInstance(reportType); |
| Line 16: this.ReportViewer1.Report = report; |
| Line 17: this.Page.Title = "telerik Report Viewer - " + reportType.Name; |
| Source File: c:\Program Files\Telerik\Reporting Q3 2009\Examples\CSharp\WebDemo\ReportViewer.aspx.cs Line: 15 |
| Stack Trace: |
| [AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.] |
| System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0 |
| System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86 |
| System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230 |
| System.Activator.CreateInstance(Type type, Boolean nonPublic) +67 |
| System.Activator.CreateInstance(Type type) +6 |
| ReportViewer.Page_Load(Object sender, EventArgs e) in c:\Program Files\Telerik\Reporting Q3 2009\Examples\CSharp\WebDemo\ReportViewer.aspx.cs:15 |
| System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 |
| System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 |
| System.Web.UI.Control.OnLoad(EventArgs e) +99 |
| System.Web.UI.Control.LoadRecursive() +50 |
| System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627 |
2. I have attached what I see from silverlight
3. When I try the windemo I see an exception on this line
IReportDocument reportDocument = Activator.CreateInstance(t) as IReportDocument;
in this block of code
| void OnCellContentClick(object sender, DataGridViewCellEventArgs e) |
| { |
| if (0 == e.ColumnIndex && e.RowIndex >= 0) |
| { |
| DataGridViewCell cell = this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]; |
| Type t = cell.Tag as System.Type; |
| if (null != t) |
| { |
| IReportDocument reportDocument = Activator.CreateInstance(t) as IReportDocument; |
| if (null != reportDocument) |
| { |
| MainForm frm = new MainForm(reportDocument); |
| frm.WindowState = FormWindowState.Normal; |
| frm.Show(this); |
| } |
| } |
| } |
| } |
I have attached a screen shot of the exception
I am running Windows 7. VS 2008.
I was looking to get the reports by passing parameter in Combobox to storedprocedure to get result.
Please help me with example.
Regards,
Venkat
Private Sub txtOptionID_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtOptionID.ItemDataBound
Dim txtOpt As Telerik.Reporting.Processing.TextBox = DirectCast(sender, Telerik.Reporting.Processing.TextBox)
If txtOpt.Value.ToString ="1"
txtRiders.Value = "New Item 1"
End If
End Sub
Your help is, as always, appreciated.