Telerik Forums
Reporting Forum
0 answers
92 views
I have a library for my reports as suggested by Telerik best practices. I had a consultant come in and change my Build Output Path to point to my bin folder of the project that uses the reports. Now every time I am in design mode I have to do a Build on hte library before I can see if my changes did what I want. I want to change the output path back to the way it was before but don't really know where it should go.
AkAlan
Top achievements
Rank 2
 asked on 24 Sep 2010
1 answer
133 views
how do I get the documentation for "telerik report" and its components in order to generate the report via cs code, not the editor of the report?

remembering that technology use silverlight.

Thank you!

Steve
Telerik team
 answered on 24 Sep 2010
1 answer
160 views
I have a mailmerge form that is currently in  MS Word 2003 format. I am trying to create that functionality on a form with Telerik Reporting. I have tried copying and pasting into a textbox control, that fails to keep any of the formatting. I have also tried in several ways to paste into an HTML Textbox. I have copied the word document directly and also tried saving to html and pasting the html code into the controls value property html editor. In both cases the html generated is creating numerous errors. The form displays correctly initiallly then error message appears and sometimes the html dissapears entirely from the html textbox's value property. Any changes I make in the design view or html view will not persist when I ok out of the designer.

Ay help with this matter will be greatly appreciated.

Michael Schwartz
Steve
Telerik team
 answered on 24 Sep 2010
1 answer
80 views

A

10

 

 

 

20

 

 

A Total

30

AVG

0.25 (30/120)

B

20

 

 

 

30

 

 

 

40

 

 

B Total

90

AVG

0.75(90/120)

Total

120

 

 


Hello Sir,

I've a problem,
Above sample is a group like Report
The row of A Total and B Total are calculated(Sum) in TextBox control,
I want to use the row of  A Total and B Total to combine generate the value of AVG column automaticly as above sample.
How shoud I do ?
Pls help me,thanks :)

Regards.
Peter
Telerik team
 answered on 24 Sep 2010
3 answers
198 views
I am creating a schedule for games using the reporting and am unable to find solution for this.  i attempted keeptogether = false in the detailsection, but i get an invocation exception. 

i am building and populating tables dynamically and adding each to the detailsection.
issue is that i get up to 4 blank pages in between each new page with a table of game times on fields.
here is my man procedure to do so:

Public Sub BuildTable(ByRef t As Telerik.Reporting.Table, ByVal d As System.Data.DataTable, ByVal day As String, ByVal totaltables As Integer)

        t.Body.Rows.Add(New Telerik.Reporting.TableBodyRow(New Telerik.Reporting.Drawing.Unit(80, Telerik.Reporting.Drawing.UnitType.Pixel)))

        '
        'build report items for table
        '
        For Each c As System.Data.DataColumn In d.Columns
            c.ColumnName = c.ColumnName.Replace(" ", "_")
        Next

        For Each c As System.Data.DataColumn In d.Columns

            'we build the textbox for header
            Dim txtbox As New Telerik.Reporting.TextBox
            txtbox.Name = c.ColumnName
            txtbox.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(80, Telerik.Reporting.Drawing.UnitType.Pixel), New Telerik.Reporting.Drawing.Unit(50, Telerik.Reporting.Drawing.UnitType.Pixel))
            txtbox.Style.BackgroundColor = System.Drawing.Color.FromArgb(CType(CType(224, Byte), Integer), CType(CType(224, Byte), Integer), CType(CType(224, Byte), Integer))
            txtbox.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
            txtbox.Style.Font.Bold = True
            txtbox.Style.Padding.Bottom = New Telerik.Reporting.Drawing.Unit(5, Telerik.Reporting.Drawing.UnitType.Pixel)
            txtbox.Style.Padding.Left = New Telerik.Reporting.Drawing.Unit(10, Telerik.Reporting.Drawing.UnitType.Pixel)
            txtbox.Style.Padding.Top = New Telerik.Reporting.Drawing.Unit(5, Telerik.Reporting.Drawing.UnitType.Pixel)
            If c.ColumnName.Trim = "Start" Then
                txtbox.Value = day
            Else
                txtbox.Value = Replace(c.ColumnName, "_", " ")
            End If


            'we create value textbox
            Dim txtvalue As New Telerik.Reporting.TextBox
            txtvalue.Name = "Value" & d.Columns.IndexOf(c).ToString
            txtvalue.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(50, Telerik.Reporting.Drawing.UnitType.Pixel), New Telerik.Reporting.Drawing.Unit(50, UnitType.Pixel))
            txtvalue.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
            txtvalue.Style.Padding.Left = New Telerik.Reporting.Drawing.Unit(5, Telerik.Reporting.Drawing.UnitType.Pixel)
            txtvalue.Style.Padding.Top = New Telerik.Reporting.Drawing.Unit(5, Telerik.Reporting.Drawing.UnitType.Pixel)
            If c.ColumnName.Trim = "Start" Then
                txtvalue.Value = "=thunder.apps.sa.reports.dal.reports.ConvertStartTime(Fields." & c.ColumnName & ")"

            Else
                txtvalue.Value = "=Fields." & c.ColumnName

            End If

            'we add new column
            t.Body.Columns.Add(New Telerik.Reporting.TableBodyColumn(New Telerik.Reporting.Drawing.Unit(90, Telerik.Reporting.Drawing.UnitType.Pixel)))

            t.Body.SetCellContent(0, d.Columns.IndexOf(c), txtvalue)



            'table group
            Dim tg As Telerik.Reporting.TableGroup = New Telerik.Reporting.TableGroup
            tg.ReportItem = txtbox
            tg.Name = "Group" & d.Columns.IndexOf(c).ToString

            t.ColumnGroups.Add(tg)
            t.Items.Add(txtvalue)
            t.Items.Add(txtbox)

        Next

        Dim tgroup As Telerik.Reporting.TableGroup = New Telerik.Reporting.TableGroup
        tgroup.Grouping.AddRange(New Telerik.Reporting.Data.Grouping() {New Telerik.Reporting.Data.Grouping("")})
        tgroup.Name = "DetailGroup"

        t.RowGroups.Add(tgroup)

        'additional table specs
        t.DataMember = ""
        t.DataSource = d

        Dim y As Integer = totaltables

        't.Items.AddRange(New Telerik.Reporting.ReportItemBase() {Me.TextBox8, Me.TextBox9, Me.TextBox10, Me.TextBox12, Me.TextBox14, Me.TextBox16, Me.TextBox18, Me.TextBox5, Me.TextBox11, Me.TextBox15, Me.TextBox13, Me.TextBox6, Me.TextBox7, Me.TextBox17, Me.TextBox19, Me.TextBox20})
        t.Location = New Telerik.Reporting.Drawing.PointU(New Telerik.Reporting.Drawing.Unit(0, Telerik.Reporting.Drawing.UnitType.Inch), New Telerik.Reporting.Drawing.Unit(y, Telerik.Reporting.Drawing.UnitType.Pixel))
        t.Name = day.Replace("/", "")

        '  t.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(width, Telerik.Reporting.Drawing.UnitType.Pixel), New Telerik.Reporting.Drawing.Unit(height, Telerik.Reporting.Drawing.UnitType.Inch))
        ' t.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
        t.KeepTogether = False
        t.Anchor = AnchorStyles.Left

    End Sub

Peter
Telerik team
 answered on 24 Sep 2010
3 answers
120 views
I've now spent a full day simply trying to get some data to my subreport.  I'm using the following code, which seems to do absolutely nothing.  What am I doing wrong??

Public Sub New()
    InitializeComponent()
End Sub
Private Sub admin_invoice_details_ownitnow_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource
    Dim SQL As New StringBuilder
 
    SQL.AppendLine("       SELECT  ISNULL(products.itemid, 0) AS lotid,")
    SQL.AppendLine("                invdesc.itemdesc,")
    SQL.AppendLine("                invdesc.amount")
    SQL.AppendLine("        FROM    invdesc")
    SQL.AppendLine("                INNER JOIN products ON products.ProductID = invdesc.itemid")
    SQL.AppendLine("        WHERE   invdesc.invoiceid = @invoiceid")
 
    Dim sqlDataSource1 As New SqlDataSource()
    sqlDataSource1.ConnectionString = HttpContext.Current.Session("Conn")
    sqlDataSource1.SelectCommand = SQL.ToString
    sqlDataSource1.Parameters.Add("@invoiceid", DbType.Int32, "=Parameters.invoiceid")
    Me.DataSource = sqlDataSource1
End Sub
Steve
Telerik team
 answered on 24 Sep 2010
2 answers
74 views
1 answer
125 views
When playing around with Conditional Formatting for a TextBox in the reporting table I found a slight bug that caught me up.

Click the .. on Conditional Formatting

Conditional Formatting Rules window is displayed as shown in window1.jpg

Next click New Rule...

Edit Formatting Rule... Window is displayed as shown in window2.jpg

Click New add in a condition and click the style... button

Choose the Text option.

As shown in Window3.jpg

Change the font name to Tahoma, and color to Red, and click cancel.

Cancel button commits changes as if the user clicked Ok.

I got burned on this once as I didn't mean to change the condition but it changed.

Thanks,
-Scott Cline

Peter
Telerik team
 answered on 23 Sep 2010
1 answer
80 views
Hi!

I have a rendered report and I like to show this report now in full screen. (without rendering the Report again.)

My idea was to use the ChildWindow of the SL toolkit and replace the DataContext of the ReportViewer in the ChildWindow with the DataContext of my first ReportViewer.
Unfortunately it is not working. There is no error message, only the text "No Report".

Any ideas?
Thank you!


This is the Zoom Method that creates the ChildWindow, as a parameter I send the DataContext of my rendered report.
   
     private void Zoom(object param)
        {
            ReportChildWindow reportChildWindow = new ReportChildWindow(this.ReportViewer.DataContext);
            reportChildWindow.Show();
        }

In the code behind of the ChildWindow I set the DataContext
        public ReportChildWindow(object dataContext)
        {
            this.DataContext = dataContext;

            InitializeComponent();
        }

Peter
Telerik team
 answered on 23 Sep 2010
9 answers
813 views
I've created a "Dynamic" Table at run time based on a DataTable populated via code.  The DataTable is binding to the Table in the report in the ItemDataBinding Sub.

Private Sub tblSolution1_ItemDataBinding(ByVal sender As Object, ByVal e As System.EventArgs) Handles tblSolution1.ItemDataBinding
        Try
            Dim ds As New DataSet
            Dim dc As DataColumn
            Dim newDT As New DataTable
            'Changes datatable layout
            newDT = RestructureDataTable(MyDatatable)
            ds.Tables.Add(newDT)
            Dim processingTable As Telerik.Reporting.Processing.Table = sender
 
            Dim textboxGroup As Telerik.Reporting.TextBox
            Dim textBoxTable As Telerik.Reporting.TextBox
            Dim I As Integer
            I = 0
 
            tblSolution1.ColumnGroups.Clear()
            tblSolution1.Body.Columns.Clear()
            tblSolution1.Body.Rows.Clear()
 
            Dim tableGroupColumn As Telerik.Reporting.TableGroup
            Dim tableGroupRow As Telerik.Reporting.TableGroup
 
            For Each dc In ds.Tables(0).Columns
                tableGroupColumn = New Telerik.Reporting.TableGroup
                tblSolution1.Body.Columns.Add(New Telerik.Reporting.TableBodyColumn(Unit.Inch(0.5)))
 
                textboxGroup = New Telerik.Reporting.TextBox
                textboxGroup.Value = dc.ColumnName.ToString
                textboxGroup.Size = New SizeU(Unit.Inch(1.2), Unit.Inch(0.3))
                tableGroupColumn.ReportItem = textboxGroup
                tblSolution1.ColumnGroups.Add(tableGroupColumn)
 
                textBoxTable = New Telerik.Reporting.TextBox
                textBoxTable.Value = "=Fields." + dc.ColumnName
                textBoxTable.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
                textBoxTable.Style.BorderWidth.Default = Unit.Pixel(1)
 
                tblSolution1.Body.SetCellContent(0, I, textBoxTable)
                I = I + 1
            Next
            tableGroupRow = New Telerik.Reporting.TableGroup
            tblSolution1.RowGroups.Add(tableGroupRow)
            tableGroupRow.Grouping.Add(New Telerik.Reporting.Data.Grouping)
            processingTable.DataSource = ds.Tables(0)
 
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub


I want to change the font and color of the text in the Table based on the value of the cell.  Such as if the value is less than 50 the text will be green above 50 text will be red. 

Please advise on how I might accomplish this?

Scott
Top achievements
Rank 2
 answered on 22 Sep 2010
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?