Telerik Forums
Reporting Forum
1 answer
81 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
163 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
106 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
222 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
101 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
302 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
53 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
192 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
3 answers
104 views
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:

ProjectID & Phase & JobName, etc (tblCWMods)
        LetterID & Modification (tblCWModItems)
                downloadName & description (tblCWModFiles)
        LetterID & Modification (tblCWModItems)
                downloadName & description (tblCWModFiles)


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.
Amanda
Top achievements
Rank 2
 answered on 24 Jun 2009
2 answers
1.3K+ views
Hi
I want to give page number in each pages footer.how can i achieve this?
Please help.
vin
Top achievements
Rank 1
 answered on 24 Jun 2009
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?