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