Telerik Forums
Reporting Forum
1 answer
273 views
Hi
I have saved latitude and longitudes in my database. I want to show location name from google maps api. API use javascript where we pass latitude and longitudes and it gives us address. Now how can i use it in telerik reports to show location
I have previously done it in crystal but how can i do it in telerik
Is there any way to do it?
Peter
Telerik team
 answered on 01 Feb 2011
1 answer
54 views
I have created a report by using the WCF service as per the vedio http://tv.telerik.com/watch/reporting/video/telerik-reporting-getting-started-with-silverlight-report-viewer

My WCF Service requires an arugument to be passed to get the result..
______________________________________________________________________________________________
For example
  Dim m_nPatientId As Integer = 109
 'For Patient History
    Public Function GetPatientDetials() As List(Of DAOfficeReports.EMRRepotsServiceReference.PatientL)
        Dim objPatientDtl As New List(Of EMRRepotsServiceReference.PatientL)
        objPatientDtl = objEmrService.GetPatientDetials(m_nPatientId)  *Here i should pass patient id from Silverlight)
        Return objPatientDtl 'For Patient History 
    End Function
_____________________________________________________________________________________________________
Iam able to pass a static argument but could'nt pass it from silverlight application dynamically to Report class library..

Pls help me...


Reena

Peter
Telerik team
 answered on 01 Feb 2011
7 answers
135 views
Hello,
currently I'm displaying reports using an ASP.NET viewer inside an aspx page,and everything works fine, I just want to move to the SL reportviewer in order to show direcly inside SL... how do I pass the parameters at the button's click?
I've seen this post where on the render begin it passes the parameters.... how do I do this on btnLoad click?
Thanks

Paolo
Peter
Telerik team
 answered on 01 Feb 2011
3 answers
87 views
Hi
 I am using (Silverlight Bussiness application) telerik reportviewer control in xaml file and i have added  telerik report file in serverside application with cubedatasource[mdx query], please let me know how to map the telerik report file to reportviewer control which is in client side(xaml file).


Thnks in Advance
Massimiliano Bassili
Top achievements
Rank 1
 answered on 01 Feb 2011
0 answers
82 views
Hi All,

Our company has recently taken over a C# project that uses Telerik Reporting as the previous developer is retiring. However, we are having a couple of problems and as we are not experienced Telerik users we dont really know how to solve them, so im hoping that someone in the community might be able to help!

Our first problem is that one of our reports has simply broken and no longer works. When trying to view the report "invoice", either through visual studio preview, or in development build, or in actual installed product, we simply get the message "An error has occurred while processing Report 'Invoice': Method ctor() not found.

So, I went into the invoice.cs file and checked out the constructor code:

namespace TInvoice {
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;
    using System.Collections.Generic;
 
    /// <summary>
    /// Summary description for Invoice.
    /// </summary>
    internal partial class Invoice : Telerik.Reporting.Report {
 
        const int LINES_PER_PAGE = 17;
 
        public Invoice( ) {
 
            /// <summary>
            /// Required for telerik Reporting designer support
            /// </summary>
            InitializeComponent( );
 
            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }
 
        internal Invoice( BL_TInvoice bl ) {
            //int inooflines;
 
            InitializeComponent( );
            //_bl = bl;
            //_ilrep = new InvoiceLine( _bl );
            //subReport1.ReportSource = _ilrep;
            //inooflines = _ilrep._bl.listinvlines.Count;
            //inoofpages = inooflines / LINES_PER_PAGE;
            //if ( inooflines != inoofpages * LINES_PER_PAGE )
            //    inoofpages++;
            //double fnet = 0;
            //for ( int i = 0; i < inoofpages; i++ ) {
            //    int startindex = i * LINES_PER_PAGE;
            //    int endindex = startindex + 16;
            //    for ( int i1 = startindex; i1 <= endindex; i1++ ) {
            //        if ( i1 < _ilrep._bl.listinvlines.Count )
            //            fnet += _ilrep._bl.listinvlines[ i1 ].amount;
            //    }
            //    listcf.Add( fnet );
            //}
        }

As part of my attempt to track down the problem, I commented out everything that was none essential, including all code within each method bound to an item on the report. However, this did not fix the problem. Only when I commented out the "InitialiseComponent" methods did I stop getting the error and was just left with a blank page. This leads me to believe that the problem must lie in the difference between version 3 (which previous developer was using) and version 4 (Q3 2010) which we have recently purchased. The reason I believe this is all the code within the "InitialiseComponent" function is auto-generated.

I have run the upgrade wizard within Visual Studio but that didnt fix the problem. Any help would be appreciated.


The second problem we are having is with a quoting report. The report displays perfectly, everything in the correct place and with all lines of the quote exactly as we'd expect. It simply reads lines from our database and then displays them. However, when we click "print", the printout is incorrect. The printout actually doubles every line of our report. For example, we have one line of the report which says "Sales Labour: 1 fitter x 12 hours £100". The next line is "Supervisor: 1x supervisor x 5 hours £70" and then at the bottom of the report we have totals etc. However, on the printout we get "Sales Labour: 1 fitter x 12 hours £100" printed out twice, replacing the supervisor line, but then the totals at the bottom counts the fitter line twice plus the supervisor line twice, despite the supervisor line not displaying. We havent fully investigated this problem yet but I was wondering if this was a more general issue with an easy solution before I have to delve into it.

Many thanks!
Steven
Top achievements
Rank 1
 asked on 01 Feb 2011
1 answer
347 views
Hi,

We are running into these errors when generating a report from HTML stored in sql server. If we use HttpUtility.HtmlEncode, that makes the error go away but then the report displays HTML such as paragraph tags, or broken a href links, left and right brackets becomd &lt; etc.

Some of the records in the report have html which contains tables - we would like that to display as a table in the report. Any ideas on how to make that work? Thanks on both issues!
Steve
Telerik team
 answered on 01 Feb 2011
0 answers
78 views
I have couple of reports in one class library.  Now I want to create a report which is almost similar to one of them in the class library.  When I copy the report class file (.cs, designer, resx), it does not open up correctly in the new class library.  It throws errors for the embedded images and other resources (screenshot attached).  How do I handle this?

(I use Q3 2010; VS 2010)
japss
Top achievements
Rank 1
 asked on 01 Feb 2011
5 answers
164 views
I need a way to display my report directly in the web browser, ie without the Telerik frame, so that users can use the browser's Print function to print the entire page across multiple physical (paper) pages.

Currently, the only (inadequate) option we have, is to use the default Telerik report frame - the one with the 'Export' and 'Print' icons - which displays a scrollable viewport of the entire report, but only prints the visible portion.

How do I take the report out of the frame and display it directly in the browser window?

Cheers,
Tim
Massimiliano Bassili
Top achievements
Rank 1
 answered on 31 Jan 2011
7 answers
120 views
Hi
I upgraded my reports to new version Q3 2010 and after upgrading my reports return error "Some internel error occur" 
Problem occur when i add group field in report. I did grouping on Fields.ReceivedDate
My query is
string strQuery = @"Select TS.*, Convert(varchar(10), DATEADD(hh,4, TS.ReceivedTime), 101) as ReceivedDate, 
                  DATEADD(hh,4, TS.ReceivedTime) as ReceivedTime 
                  From TrackStatus TS  
                 ORDER BY TS.ReceivedTime ";

i have defined this query in Need_DataSource event

In Q1 2010 version my report was running well but after upgrading it returns error when we preview report
However if i create database function for above query and use function then reports work well
Please help me what is wrong

Massimiliano Bassili
Top achievements
Rank 1
 answered on 31 Jan 2011
6 answers
77 views
Hi,

I would like to create a report from a Telerik.Reporting.ObjectDataSource.
I need to generate a report from the top to the bottom and not from left to right which seems to be the default behavior.

I didn't find a simple way to do it.

Is it possible to do it simply ?
if yes, how can I do it ?

Thanks for your answer.

Regards.

Fred
Cantenot Frederic
Top achievements
Rank 1
 answered on 31 Jan 2011
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?