Telerik Forums
Reporting Forum
0 answers
107 views
Folks,

I am programmatically binding my Sharepoint List data to the Telerik report.
I am using CAML Query to bind the List data by passing parameter values to the Report.
Please refer to my post here. This is how I am using CAML Query to bind the data programmatically to the report.
Everything works fine until I add a subreport to the Main Report.
Here is the scenario: I add a Subreport to the Detail area of the Report. I am using SubReport1.NeedDataSource to bind the data programmatically. So, I want to pass the same parameter values to the subreport that I have passed to the Main report.
For each parameter value passed to Main Report, its subsequent subreport should be populated with same ID.
Unfortunately, the same CAML doesn't hold good for subreport. when passed, It collects all results for all the parameter vallues and binds them as each subreport for subsequent Main Report.
Please help in this issue.

Thanks
smith spd
Top achievements
Rank 1
 asked on 29 Sep 2010
3 answers
101 views
Dear Sir,
i am using Reporting Q3 2009, my problem is when i place several textboxes inside a panel in the details section.

all of the textboxes are left docked and is styled to have left border of 1 pixel to show like a table.

when one of the textboxes contains multi line, the other textboxe do not grow making the lines not equal and causing a very bad image in the report. not all textboxes of the same heigh.

what should i do to make all textboxes continue to have the same height while docking then left don't ?

i am working on visual studio 2005 , 2008 on windows XP SP3

thank you
Timothy Kelley
Top achievements
Rank 1
 answered on 28 Sep 2010
1 answer
205 views
Reporting Q2 2010

I have a telerik report inside of the report viewer of a sliverlight page. The reports opens up correctly. However, when I click the print button on the Report Viewer Control the print dialog does not display. IE progress bar refreshes but that is the only indication that anything at all is happening. This does not happen when I run the site on my local server. It happens when I deploy it to my development server. I am guessing I need to deploy some dll(s) that I have not deployed yet. Where can I find a list of the dlls that need to be deployed? NOTE: I have already deployed the following: Telerik.Reporting.dll, Telerik.Reporting.Services.dll and Telerik.Reporting.XamlRendering.dll.

Thanks,

Billy Jacobs
Steve
Telerik team
 answered on 28 Sep 2010
1 answer
164 views
Hi,
is there any way  of changing the chart series for stacked bar chart? and this should happen with Telerik reporting chart not with rad chart .need your assistance regarding this.

Thanks in advance
Steve
Telerik team
 answered on 28 Sep 2010
2 answers
332 views
Does anyone know how to figure out why a report might not be loading in the designer?

I'm getting this generic error...

To prevent possible data loss before loading the designer, the following errors must be resolved:
1 Error
Why am I seeing this page?
Value cannot be null. Parameter name: instance
 
Instances of this error (1)
1.
at System.ComponentModel.TypeDescriptor.AddAttributes(Object instance, Attribute[] attributes)
at Microsoft.VisualStudio.Design.VSDesignSurface.CreateDesigner(IComponent component, Boolean rootDesigner)
at System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent component, String name, IContainer containerToAddTo)
at System.ComponentModel.Design.DesignerHost.PerformAdd(IComponent component, String name)
at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.CreateComponent(Type componentType, String name)
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, CodeTypeDeclaration declaration)
at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)
at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.DeferredLoadHandler.Microsoft.VisualStudio.TextManager.Interop.IVsTextBufferDataEvents.OnLoadCompleted(Int32 fReload)
 
Help with this error
 
Forum posts about this error
sitefinitysteve
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 28 Sep 2010
0 answers
158 views
Hello

For security reasons we want to authenticate our users on the WCF Telerik Reporting Service.
At first I thougt I can use the WCF-Configuration (web.config on server; IReportServiceClientFactory on client) to set
authentication settings e.g.:

web.config
<basicHttpBinding>
   <binding name="basicHttpBindingConfig1">
      <security mode="Transport">
         <transport clientCredentialType="Basic"></transport>
      </security>
</binding>
</basicHttpBinding>
"IReportServiceClientFactory"

public class CustomReportServiceClientFactory : IReportServiceClientFactory
    {
        public ReportServiceClient Create(Uri remoteAddress)
        {
            BasicHttpBinding basicHttpBinding = basicHttpBinding = new BasicHttpBinding(BasicHttpSecurityMode.Transport);
            ReportServiceClient client = new ReportServiceClient(basicHttpBinding, new EndpointAddress(remoteAddress));
            return client;
        }
    }

But I forgot the "webHttpBinding" form the ReportService ...
And I found no possibility to set the authentication settings for this on the client.

And because of the used WebHttpBinding are headers in the the SOAP header (with the configuration <message clientCredentialType="UserName"/> and a custom class UserNamePasswordValidator ClientCredential) not possible, or?

So I ask what are there for options for authentication?
Ideally I would like to add a header with a securty token (username + password) to all request to the server and validate it on server)

My development environment: Windows XP (SP3); VS2010; Silverlight 4.0; Reporting Q2 2010

Thank you
mlzoll
Top achievements
Rank 1
 asked on 28 Sep 2010
0 answers
93 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
144 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
190 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
514 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
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?