Telerik Forums
Reporting Forum
1 answer
117 views

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


Steve
Telerik team
 answered on 01 Feb 2010
1 answer
105 views
Hi All,

I'm planing to use Telerik Reporting for some Invoices in ASP.NET. After buying developer version of reporting API, Do I need any additional tool or API for end user? I think that these kind's of reporting APIs require some server version. I mean from the server that Crystal Reports Servers.

Regards

Ert 
Steve
Telerik team
 answered on 01 Feb 2010
2 answers
155 views

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.

Massimiliano Bassili
Top achievements
Rank 1
 answered on 01 Feb 2010
1 answer
113 views

I was looking to get the reports by passing parameter in Combobox to storedprocedure to get result.

Please help me with example.

Regards,

Venkat

sitefinitysteve
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 30 Jan 2010
3 answers
155 views
I need to load a textbox with data based on the contents of another texbox.   I want to load the unbound textbox txtRiders based on the value of the bound textbox txtOptionID.  Here's what I tried:

 

 

    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.

 

Bob Bruce
Top achievements
Rank 1
 answered on 29 Jan 2010
1 answer
161 views
Hi, I have downloaded the latest Reporting Telerik Reporting 2009 to try it out in my company on an existing asp.net solution. 

I attach the report to my datasource through odbc and generate a report.  Looks fine in the designer and preview. It pages to the next page in the preview fine.  When I run the solution and open the report in IE 8 or Firefox 3.6 the first page of the report is fine but when I hit the next arrow it brings up the "Report is unavailable or session has expired.".  

The browser accept all cookies
I am using session variables all over the place.

I have looked through the forums and upped the session to 9999 (nothing) .  Tried various things with the session state (nothing).  Not sure where to go from here.

Thanks
Steve
Telerik team
 answered on 29 Jan 2010
1 answer
370 views
I have a master report that has no datasource.  It simply contains 2 subreports.  I want to set the datasource for my subreports programatically from my web application.  I need to do this because the datasources are web services which I'm converting to datasets. The code I have below is running but no data is shown on the report.  When I debug and step through the code the subreports have the correct datasets as their datasouces.  Any ideas on what I'm doing wrong?  Do I need to do something to the main report before running it?

        // get a reference to the master report
        Telerik.Reporting.Report rptMain = new my_report();

        // get a reference to the subreports
        Telerik.Reporting.SubReport rptSub1 = (Telerik.Reporting.SubReport)rptMain.Items.Find("subReport1", true)[0];
        Telerik.Reporting.SubReport rptSub2= (Telerik.Reporting.SubReport)rptMain.Items.Find("subReport2", true)[0];

        // get the datasets for the subreports by converting xml from web service calls into datasets
        DataSet ds1 = GetDataSetForSubReport1();
        DataSet ds2 = GetDataSetForSubReport2();

        // set the subreport datasources
        rptSub1.ReportSource.DataSource = ds1;
        rptSub2.ReportSource.DataSource = ds2;
 
        // open the report as a pdf file
        ReportProcessor reportProcessor = new ReportProcessor();
        RenderingResult result = reportProcessor.RenderReport("PDF", rptMain, null);
        ...




 

Steve
Telerik team
 answered on 29 Jan 2010
1 answer
142 views
Hi, Telerik,

My application opens a radwindow which has a reportviewer that displays a report. I just want to close the radwindow once the user press ESC key.
I have done this with a radwindow once a control has the focus inside, but now I have no control to set the focus inside the reportviewer to obtain this.
Is there a way to set the focus to any control of the ReportViewer with Javascript, for example: the navigation buttons, the exporting dropdownlist or the Export, Refresh or Print buttons in the toolbar of the ReportViewer?

Please, help me with this.

thanks a lot,
Daniel.
dany7487
Top achievements
Rank 1
 answered on 28 Jan 2010
5 answers
338 views
hai!

How to create telerik reporing using xml data.....can anyone help me?...... 

thanks,
N.Devi
David Copp
Top achievements
Rank 1
 answered on 28 Jan 2010
1 answer
110 views
Hello,

Similar to the Page.IsPostBack property for ASP.NET, is there a way to distinguish between the initial load of a report verses subsequent clicks of the report preview click, within the report definition code behind?

Thanks.
Steve
Telerik team
 answered on 28 Jan 2010
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?