Telerik Forums
Reporting Forum
1 answer
159 views
Is it possible to have a Telerik Report connect to an IBM i Access for Windows ODBC data source?  Or is this not a compatible database type for Telerik?  If it is possible, does it require a certain version of Telerik Reporting?  I'm currently using Q3 2011.
Stef
Telerik team
 answered on 30 Sep 2013
2 answers
278 views
Hi,

I am getting the following errors while try to run report from silverlight report viewer.
Previously it was working with the licensed version 7.1.13.612 and currently I am using updated version 7.1.13.802
in Telerik.Reporting.dll, Telerik.Reporting.Service.dll, Telerik.ReportViewer.Silverlight.dll

Please help me to find out the solution of this bug for client release.

Error in silverlight report viewer :

Error: System.Reflection.TargetInvocationException : An exception occurred during the operation, making the result invalid.  Check InnerException for exception details.
   at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   at Telerik.Reporting.Service.SilverlightClient.ListRenderingExtensionsEventArgs.get_Extensions()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnListRenderingExtensionsCompleted(Object sender, ListRenderingExtensionsEventArgs e)

------------- InnerException: -------------

System.ServiceModel.CommunicationException : The remote server returned an error: NotFound.
   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_2.EndListRenderingExtensions(IAsyncResult )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnEndListRenderingExtensions(IAsyncResult result)
   at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)

------------- InnerException: -------------

System.Net.WebException : The remote server returned an error: NotFound.
   at System.Net.Browser.BrowserHttpWebRequest.InternalEndGetResponse(IAsyncResult asyncResult)
   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassa.<EndGetResponse>b__9(Object sendState)
   at System.Net.Browser.AsyncHelper.<>c__DisplayClass4.<BeginOnUI>b__0(Object sendState)

Error in Fiddler :

HTTP/1.1 404 Not Found
Content-Length: 1565
Content-Type: text/html; charset=UTF-8
Server: Microsoft-HTTPAPI/2.0
Date: Wed, 25 Sep 2013 16:16:04 GMT

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title>Service</title>
    <style>BODY { color: #000000; background-color: white; font-family: Verdana; margin-left: 0px; margin-top: 0px; } #content { margin-left: 30px; font-size: .70em; padding-bottom: 2em; } A:link { color: #336699; font-weight: bold; text-decoration: underline; } A:visited { color: #6699cc; font-weight: bold; text-decoration: underline; } A:active { color: #336699; font-weight: bold; text-decoration: underline; } .heading1 { background-color: #003366; border-bottom: #336699 6px solid; color: #ffffff; font-family: Tahoma; font-size: 26px; font-weight: normal;margin: 0em 0em 10px -20px; padding-bottom: 8px; padding-left: 30px;padding-top: 16px;} pre { font-size:small; background-color: #e5e5cc; padding: 5px; font-family: Courier New; margin-top: 0px; border: 1px #f0f0e0 solid; white-space: pre-wrap; white-space: -pre-wrap; word-wrap: break-word; } table { border-collapse: collapse; border-spacing: 0px; font-family: Verdana;} table th { border-right: 2px white solid; border-bottom: 2px white solid; font-weight: bold; background-color: #cecf9c;} table td { border-right: 2px white solid; border-bottom: 2px white solid; background-color: #e5e5cc;}</style>
  </head>
  <body>
    <div id="content">
      <p class="heading1">Service</p>
      <p>Endpoint not found.</p>
    </div>
  </body>
</html>

service tracelog error :

The incoming HTTP request's URI 'http://localhost:8080/' does not match any service operation.

app.config file :

<appSettings>
    <add key="DhaaniReportURL" value="http://localhost:8080/" />
    <add key="ClientSettingsProvider.ServiceUri" value="" />
    <add key="NetworkMachinesConnStr" value="uid=root;password=;host=.;database=NetworkMachines;protocol=pipe;pipename=mysql;pooling='True';Min Pool Size=10;Max Pool Size=500" />
  </appSettings>
  <system.serviceModel>
    <bindings>
      <basicHttpBinding>
        <binding name="BasicHttpsBindingConfig" maxReceivedMessageSize="2147483647" maxBufferSize="2147483647" receiveTimeout="00:30:00" sendTimeout="00:30:00">
          <readerQuotas maxArrayLength="2147483647" maxStringContentLength="2147483647" />
        </binding>
      </basicHttpBinding>
    </bindings>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
    <services>
      <service name="ReportingWCFWindowsService.ReportService" behaviorConfiguration="ReportServiceBehavior">
        <host>
          <baseAddresses>
            <add baseAddress="http://localhost:8080/" />
          </baseAddresses>
        </host>
        <endpoint address="ReportService" binding="basicHttpBinding" contract="Telerik.Reporting.Service.IReportService">
          <identity>
            <dns value="localhost" />
          </identity>
        </endpoint>
        <endpoint address="ReportService/resources" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="Telerik.Reporting.Service.IResourceService" />
        <endpoint address="" binding="webHttpBinding" behaviorConfiguration="WebBehavior" contract="ReportingWCFWindowsService.IClientAccessPolicy" />
        <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
      </service>
    </services>
    <behaviors>
      <serviceBehaviors>
        <behavior name="ReportServiceBehavior">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="false" />
        </behavior>
      </serviceBehaviors>
      <endpointBehaviors>
        <behavior name="WebBehavior">
          <webHttp />
        </behavior>
      </endpointBehaviors>
    </behaviors>
  </system.serviceModel>

Note :
When I run the service base address in browser it works fine. URL : http://localhost:8080/

ReportService.cs :

[ServiceContract]
    public interface IClientAccessPolicy
    {
        [OperationContract, WebGet(UriTemplate = "/ClientAccessPolicy.xml")]
        Stream GetPolicy();
    }

    [System.Runtime.Serialization.KnownType(typeof(object[]))]
    public class ReportService : ReportServiceBase, IClientAccessPolicy
    {
        static string sReportURL = ConfigurationSettings.AppSettings["DhaaniReportURL"].ToString();
        static readonly Uri baseUri = new Uri(sReportURL);

        protected override Uri BaseAddress
        {
            get { return baseUri; }
        }

        protected override string ApplicationPath
        {
            get
            {
                //return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\";
                //Make sure that the ApplicationPath property always returns a valid directory path that ends with a slash (/) or a backslash (\)

                return System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + "\\"; // for WinForms applications
                //return System.Web.HttpContext.Current.Request.PhysicalApplicationPath; // for ASP.NET applications
            }
        }

        public Stream GetPolicy()
        {
            var fs = new FileStream(Path.Combine(this.ApplicationPath, "clientaccesspolicy.xml"), FileMode.Open);
            var bytes = new byte[fs.Length];
            fs.Read(bytes, 0, bytes.Length);
            fs.Close();

            if (WebOperationContext.Current != null)
            {
                WebOperationContext.Current.OutgoingResponse.ContentType = "application/xml";
            }

            return new MemoryStream(bytes);
        }
    }

SummaryReport.cs :

public partial class SummaryReport : Report
    {
        public SummaryReport()
        {
            InitializeComponent();
        }

        public List<Machine> GetReportData(string pcs, DateTime startTime, DateTime endTime, double dHours, bool isCustom)
        {
            string sInstallationName = string.Empty;
            string sInstallationAddress = string.Empty;
            string sVersionInfo = string.Empty;

            InitConn();
            List<Machine> lstMachine = new List<Machine>();
            return lstMachine;
       }

Report.xaml.cs :

                repViewer = new ReportViewer();
                repViewer.RenderBegin += new RenderBeginEventHandler(repViewer_RenderBegin);
                repViewer.ReportServiceUri = new Uri(App.p_ReportEndPoint);
                repViewer.Report = "ReportingWCFWindowsService.SummaryReport, ReportingWCFWindowsService";

        void repViewer_RenderBegin(object sender, RenderBeginEventArgs args)
        {
            args.ParameterValues["pcs"] = machines.TrimEnd(',');
            args.ParameterValues["startTime"] = p_DTStart;
            args.ParameterValues["endTime"] = m_EndDateForResult;
            args.ParameterValues["dHours"] = m_Hours;
            args.ParameterValues["isCustom"] = isCustom;
            //progIndicator.Stop();
        }



Stef
Telerik team
 answered on 30 Sep 2013
3 answers
59 views
Hi,
We have a report with 40 number of columns. We want to show that report in a such way that, user will be able to do paging with columns also.What I mean is, we want to show only 10 number of columns on first page.And then when user will click on next columns, then it should show next 10 columns and so on.
So can you please let me know is it possible to implement such column paging functionality with Q3-2010 reporting controls.
Also while doing so can we also make available both paging for user i.e.Physical paging and logical paging(Column Paging).

Thanks,
Sachin.
Stef
Telerik team
 answered on 30 Sep 2013
2 answers
579 views
Hi All,

I am using Q3 2008 version of Telerik Reporting.
I have 1 report which contains a subreport in it.
Subrport is for each row (e.g. For each Date field in main report I am showing events for the dates in the subreport below that row).

I have aligned the report and subreport properly.
When I do export to excel a blank row gets created between tow main report records event regardless of whether there is data exists in subreport or not.

(If subreport has multiple rows for a record then there is no blank row between s8ubreport records but still it shows a blank row between tow main report records).

If I remove subreport from the main report and do export to excel then there is no blank row betwen two records.

Is this a correct scnerio that if there is any subreport then it takes a row for that subreport?
If not then can anyone please let me knowm what could be missing?

Best Regards,
Hrushikesh.
Dada
Top achievements
Rank 1
 answered on 30 Sep 2013
4 answers
152 views
Hi, I have an image with details listed below in a PictureBox which in report designer shows desired size 6cm / 4cm and when using webview it prints and pdfs ok at 6x4 but the html render in the browser shows at (I'm guessing) 700px / 470px (only shows a small portion of the image as its constrained within the picturebox size of 6x4)

I'm happy with the output to print and pdf but is there a way of scaling the image so it also looks in the html render?

I tried the sizing options by these didn't seem to make any difference, also tried reducing the image rez so it fitted it all outputs ok but the print and pdf quality suffered too much.

Image dimensions:
H-Res: 300
Phy-Dim: 700, 470
PixelFormat: Format24bppRgb
RawFormat: Png
V-Res: 300

cheers
Martin

Imran
Top achievements
Rank 1
 answered on 28 Sep 2013
4 answers
237 views
Hi,

I'm running the VS.Net 2010 and the Q3 2010 release of Telerik Reporting.  I'm not sure how I can get the Crosstab wizard to launch.  I see all the other Telerik Reporting controls in my Toolbox but not the Crosstab Wizard.  I've tried uninstalling and reinstalling the Telerik Reporting software and also looked for it in "Add Items" under the Telerik Reporting tab in my toolbox. Not sure what is going on.

Thanks

Eric
Sebastian
Top achievements
Rank 1
 answered on 27 Sep 2013
5 answers
320 views
Hi,

I am using Telerik Reporting Q2 2010 in silverlight 4 application. To show report, I am using Telerik reportviewer in xaml file.
My requirement is to update status in database if report is printed and its very crucial requirement.
I tried several ways and looked into Telerik help as well as googling but could not found any meaningful solution.
Please help me finding a solution or at least a workaround.

A quick help will be greatly appreciated.

-Jono
Stef
Telerik team
 answered on 27 Sep 2013
1 answer
152 views
Hi,
I'm aware that this product is in Beta, so I figured I'd point out a bug I found.  When attempting to apply parameters to my report, the javascript fails and I get the following response:

Uncaught TypeError: Object #<Object> has no method 'applyParameters' parametersArea.js:509
(anonymous function) parametersArea.js:509
b.event.dispatch jquery-1.9.1.min.js:3
v.handle

It happens in this block here:

var $previewButton =
            $("<button class='k-button trv-parameters-area-preview-button'></button>")
                .html("Preview")
                .appendTo($footer)
                .on("click", function () {
                    controller.applyParameters();
                    /*
                    if ($validator.validate()) {
                        controller.applyParameters();
                    }
                    else {
                        alert("Invalid parameter values!");
                    }
                    */
                });


Also, and this is a side note, when the page loads, the report is received through the api fine, but it does not actually load the report into the report viewer until I hit the refresh icon. Should I manually call for a refresh?  I noticed the sample code provided on the announcement blog post does not require a manual refresh and just properly loads the report on page load.

Thanks
Chavdar
Telerik team
 answered on 27 Sep 2013
1 answer
77 views
Hi

With our current product we use Crystal for reporting. Report designers create the Crystal rpt file, a stored procedure for the data, and some report meta information to go into our database (the name of the rpt file, name of report, the stored procedure to use, the parameters that can be passed).
We then have an ASP site which reads the database to get the meta information of all the reports that are available on it's database. The site allows the user to navigate through and run the report they want, specifying the parameters as per the meta information. The Crystal report viewer then renders the report.
The site can also save the users parameter input to be run as a scheduled report later (a windows service checks the db periodically and renders the report to pdf for email)
This means that the ASP site never changes, report writers just need to know crystal and sql, and new reports can be added on the fly.

So, we are now looking for a modern, non-crystal solution, for our new product. One proposal is ASP.MVC with Telerik Reporting. I've seen that there is a standalone designer which is good and there are self contained trdx files. But is there the ability to create and drop in new reports on the fly like we have with our current crystal solution - without any changes to the mvc compiled code?
And if so are there any documents/guides/examples on getting that going?

Many Thanks
Elian
Telerik team
 answered on 27 Sep 2013
1 answer
246 views
I have a report that links (drills down) to other reports.  It actually has links to 10 other reports. 

I see 2 options for this: Navigate to an Object Instance, and Navigate to a Type name.

Object Instance:  The problem I'm running into with this is it creates an instance of each of the 10 reports. Some of the reports have code in the constructor that calls a web service that may or may not be there at design time. This causes the designer to crash (even though the code is wrapped in  if (!this.DesignMode))  My other concern is performance/memory issues since it creates these 10 reports at run time, instead of on-demand. (when link is clicked)

Type Name:  This option works well for us, except for the fact that the type name includes the assembly version, which gets updated every build (so we would have to constantly update the links).  This would not be maintainable without a script that searches for version numbers and updates them before each build. (which I'd rather not develop and maintain)

Any solutions to my scenario?


Justin Lee
Top achievements
Rank 1
 answered on 27 Sep 2013
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?