Telerik Forums
Reporting Forum
0 answers
94 views

hi...

i've two crystal reports one is in D: drive name employee.rpt with 5 textobject

and another report is in E: drive name employee.rpt with 15 textobject...

now i want to write a program to overwrite the D drives report with E drives reports

i.e i want to replace the 5 textobject with 15 textobject..

overwriting the reports while it is executing .. 

is there any code for it please help me..

its urgent..

vinayak.v
Top achievements
Rank 1
 asked on 28 Sep 2010
1 answer
147 views
I have a small list style report that for one filter happens to be the exact size of 1 page for the main details.  The summary in the group footer then gets printed on the 2nd page.  This is not a big deal, but the header is printed on the 2nd page, and since there are no details the footer band is being printed on top of the header. 

This is not a major issue but, for this one filter, it makes the report less useful since the people that are looking at typically only care about the summary at the bottom.

I don't want to change margins because that will just mess with the other filters.  Is there something i can do in the code to push that band down just a little bit if ends up on the 2nd page with no details?

see attached image.

Steve
Telerik team
 answered on 28 Sep 2010
3 answers
192 views
I have successfully made the report as a classlibrary in the website structure.  Now I am trying to get the viewer to display it in an aspx page.  I have add the classlibrary in the references, and was able to set the reportviewer properties to point to the report in the class.  However when I execute the asp page I am getting an error.

"An error has occurred while processing Report": Unable to connect to database. Please verify that your connection string is valid; in case you use a connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application."

I can open the Report in the classlibrary and preview the data so I know the connection is good.  Do I have to declare the connection in the Web.Config file?  Currently I set the SQLconnection1 for the report.

Thanks
Steve
Telerik team
 answered on 28 Sep 2010
1 answer
522 views
Dim section As Processing.DetailSection = DirectCast(sender, Processing.DetailSection)
        Dim dobj As Processing.IDataObject = DirectCast(section.DataObject, Processing.IDataObject)
        Dim txtbxComment = DirectCast(section.ChildElements.Find("txtComment", True)(0), Processing.TextBox)
        Dim txtbxOTRelief = DirectCast(section.ChildElements.Find("txtOTRelief", True)(0), Processing.TextBox)
        Dim txtbxOTTrain = DirectCast(section.ChildElements.Find("txtOTTrain", True)(0), Processing.TextBox)
        Dim txtbxOTSched = DirectCast(section.ChildElements.Find("txtOTSched", True)(0), Processing.TextBox)
        Dim txtbxOTOther = DirectCast(section.ChildElements.Find("txtOTOther", True)(0), Processing.TextBox)
        Dim txtbxVacAvail = DirectCast(section.ChildElements.Find("txtVacAvail", True)(0), Processing.TextBox)
        Dim txtbxVacUsed = DirectCast(section.ChildElements.Find("txtVacUsed", True)(0), Processing.TextBox)
        Dim txtbxVacRemain = DirectCast(section.ChildElements.Find("txtVacRemain", True)(0), Processing.TextBox)
        Dim txtbxPCHAvail = DirectCast(section.ChildElements.Find("txtPCHAvail", True)(0), Processing.TextBox)
        Dim txtbxPCHUsed = DirectCast(section.ChildElements.Find("txtPCHUsed", True)(0), Processing.TextBox)
        Dim txtbxPCHRemain = DirectCast(section.ChildElements.Find("txtPCHRemain", True)(0), Processing.TextBox)
        Dim txtbxPPNbr = DirectCast(section.ChildElements.Find("txtPPNbr", True)(0), Processing.TextBox)
        Dim txtbxOT = DirectCast(section.ChildElements.Find("txtOT", True)(0), Processing.TextBox)
        Dim txtbxWorkDate = DirectCast(section.ChildElements.Find("txtWorkDate", True)(0), Processing.TextBox)
 
        txtbxPPNbr.Value = Get_PayPeriod(dobj("TTD_WORK_DATE"))
 
        If txtbxOT.Value > 0 Then
            If InStr(1, txtbxComment.Value, "Relief") > 0 Then
                txtbxOTRelief.Value = txtbxOT.Value
                sglOTRelief += txtbxOT.Value
            ElseIf InStr(1, txtbxComment.Value, "Train") > 0 Then
                txtbxOTTrain.Value = txtbxOT.Value
                sglOTTrain += txtbxOT.Value
            ElseIf InStr(1, txtbxComment.Value, "Sched") > 0 Then
                txtbxOTSched.Value = txtbxOT.Value
                sglOTSched += txtbxOT.Value
            Else
                txtOTOther.Value = txtbxOT.Value
                sglOTOther = txtbxOT.Value
            End If
        End If
 
Public Shared Function Get_PayPeriod(ByVal dtWorkDate As Date) As Integer
        Dim intX As Integer = 0
        Dim avarPayPeriods() As TCCPayPeriods = aPayPeriods
 
        For intX = 0 To UBound(avarPayPeriods)
            If dtWorkDate >= avarPayPeriods(intX).dtPayPeriod And intX = 23 Then
                Return avarPayPeriods(intX).bytPayPeriodNbr
                Exit For
            ElseIf dtWorkDate >= avarPayPeriods(intX).dtPayPeriod And dtWorkDate < avarPayPeriods(intX + 1).dtPayPeriod Then
                Return avarPayPeriods(intX).bytPayPeriodNbr
                Exit For
            End If
        Next intX
    End Function
Hello,
I received this error when trying to process a detail section of a report.  I am referencing the fields as follows:


Assume TCCPayPeriods structure defined correctly.  Any ideas what I am doing wrong.  Thanks in advance.
Chuck Harrington
Top achievements
Rank 1
 answered on 27 Sep 2010
7 answers
188 views
Good afternoon,
I hope you can help me (should be easy really). I have built a spline chart which is bound to an ever changing datasource.
What I need to do is remove the Series items label values, because they are obstructing the chart itself.
I have this code:

But for some reason the labels stay, which is really annoying. Could someone tell me what I am doing wrong?

 
Private Sub Chart1_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Chart1.NeedDataSource
        Dim myImpersonate As New AliasAccount("administrator", "", "")
        myImpersonate.BeginImpersonation()

        DirectCast(sender, Telerik.Reporting.Processing.Chart).DataSource = myDataSource
        ClearLabels()

        myImpersonate.EndImpersonation()
    End Sub

    Private Sub ClearLabels()
        For Each c As ChartSeries In Chart1.Series
            For Each item As ChartSeriesItem In c.Items
                item.Label.TextBlock.Text = ""
            Next
        Next
    End Sub
End Class
Peter
Telerik team
 answered on 27 Sep 2010
3 answers
97 views
http://www.telerik.com/help/reporting/silverlight-report-viewer.html

Specifically: "The corresponding RadControls for Silverlight version , available at the time of the Telerik Reporting  release to use the Telerik Reporting Silverlight Report Viewer. "

Is this really true? This would make the Reporting solution highly uncompetitive (price-wise).

Chris
Steve
Telerik team
 answered on 27 Sep 2010
1 answer
222 views
Hello people.

I have a view (screenshot attached) that represents the items bought in a given period by different departments within the organization.
The departments (DeptName) and items (ItemRef) can therefore have repetitions.

What i would like to achieve is a crosstab (i think that's where i need to  go) where:
-I have one item per line
-A department "group" with a quantity (Qty) and unit price (Valor Unitario)  columns, with a total of [Valor Unitário]*[qty] by department,
like the screenshot "report". I am having problems creating this report because when i hit the crosstab wizard, i end up with a report like the "report_preview" image. I dont want to aggregate the [Qty] and [Valor Unitario] but i have to or the report wont build.

What am trying to achieve is similar to the demo "Product Sales per Period" , is there any step by step other than the video, which i cannot watch or download because flv's are blocked here?
Massimiliano Bassili
Top achievements
Rank 1
 answered on 27 Sep 2010
5 answers
150 views
Hello

I tried the Silverlight Reporting Viewer online Demos.

Unfortunately the Report goes to an pdf file called "export" and not directly to the printer.
Is it possible to get the "Printer Dialog"?

 I don't like to install on all clients a pdf Viewer to print a report!!

Thanks,
Manuel
Christoph
Top achievements
Rank 1
 answered on 27 Sep 2010
1 answer
166 views
Hello,

I have a report with multiple datasources in which I'm trying to get certain values from each datasource and display/run calculations on in the footer of the report.  I'm using the ItemDataBound event of different textboxes to calculate totals and assign them to a variable in the codebehind.  The problem is I don't understand the firing order of the different ItemDataBound events.  If I have two tables and 5 textboxes in the report footer section....which textbox's ItemDataBound is fired first?  Is there a way to control the order?

Thanks!!!
Steve
Telerik team
 answered on 27 Sep 2010
1 answer
98 views
Hi, I have checkboxes on some invoices on a radgrid. User can select a few invoices and when they clicked a button, the selected invoices will be printed. Can anyone share a good way to do this? I have created the report class already but looking for ideas to get this done. will appreciate any attached sample. Thanks in advance.

Regards
CWK
Steve
Telerik team
 answered on 27 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?