Telerik Forums
Reporting Forum
1 answer
170 views
I'm using an object as my data source.  The object has a function that returns another object.  I wish to use a function return value of that returned object as the value in a TextBox, but the report is not happy and shows an exception box pertaining to not being able to find the lower function.  For example, my TextBox value field looks something like this: =GetSubObject().GetValue( p1, p2).  The report would be  complaining "The expression contains undefined function call GetValue."
Is there any way to do this?  I'm guessing a subreport that uses the GetSubObject return value as its data source would be an option?
Chris Gillies
Top achievements
Rank 1
 answered on 26 Jun 2009
1 answer
219 views
Hi .
 This is suriya .,
 sir i have doubt in retriving the next row record and calculating in another field....

Date                        days
4-Jan-2009 0
7-Jan-2009 3
9-Jan-2009 2
10-Jan-2009 1

i need the above answer, but u have the date field only., it is possible or not in teleriks.,
please reply as soon as possible.,

By
Suriya narayanan

Steve
Telerik team
 answered on 26 Jun 2009
1 answer
104 views
Hi ,

I have made the Master /Detail sub report and execute well in my local machine ,however when i publish the code and try to view the Master /Detail report i am not getting the sub report content while i am getting only the master table content at the same time all my reports are executing at local and in publish code i do not understand why this is happening only for Master/Detail subreporting.

I am using the following trial version.

Telerik_Reporting_2008_3_1402_trial

Thanks,
Neeraj.
Steve
Telerik team
 answered on 26 Jun 2009
3 answers
180 views
      SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=cmdiapp;Password=adiadmin");  
            Telerik.Reporting.Processing.SubReport report3 = (Telerik.Reporting.Processing.SubReport)sender;  
 
            SqlCommand selectCommand;  
            selectCommand = new SqlCommand("sprocgetYears", connSomsys);  
            selectCommand.CommandType = CommandType.StoredProcedure;  
            selectCommand.Parameters.AddWithValue("@ousername_vc", this.ReportParameters["ousername_vc"].Value);  
            SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);  
            DataSet dataSet3 = new DataSet();  
            adapter.Fill(dataSet3);  
            
           //Now I would like to do something like the following but cannot, need help with this part...  
            report3.Table1.DataSource = dataSet3;  
             
I have a subreport that contains a table. I need to be able to set the datasource for this table from within the Parent report code behind. I believe i may need to do something with the Item DataBinding events but am not 100% certain. I am using stored procedures and calling them programmatically. Below is a code snippet where near the bottom of the snippet I need to access the table and its datasource that lives in the subreport. Any help would be greatly appreciated

Jason
Steve
Telerik team
 answered on 26 Jun 2009
1 answer
131 views
Does the Report Wizard support binding to Stored procedures? If not, what is the best practice?

Thanks
Steve
Telerik team
 answered on 26 Jun 2009
1 answer
250 views
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?
Jon
Top achievements
Rank 1
 answered on 25 Jun 2009
2 answers
133 views
Hi Telerik Team,

 I need to show the record as 
1 2 3 4
5 6 7 8
......

instead of vertically.

I already posted this query day before yesterday. But it was missing in the forum. Kindly respond me. 

Regards,
Katte.
Steve
Telerik team
 answered on 25 Jun 2009
1 answer
334 views
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?
Steve
Telerik team
 answered on 25 Jun 2009
1 answer
65 views
Hi

 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 cant able to paste screen shot?

Regards,
Abdul Ajees 
Steve
Telerik team
 answered on 25 Jun 2009
1 answer
233 views
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.

Thank you
Tom
Top achievements
Rank 1
 answered on 24 Jun 2009
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?