Telerik Forums
Reporting Forum
10 answers
403 views
Hi,

I'm in trouble with the ReportViewer under Silverlight. Under development machine everything works fine but when deploy the project to production server (IIS7) silverlight report viewer doesn't display the report but shows a Async_ExceptionOccurred exception.
I've read all the other threads about this problems and I've checked that:

As referenced by server project following assemblies are present under the bin directory:
Telerik.Reporting.dll (also installed in GAC as a try) - 5.0.11.316
Telerik.Reporting.Service.dll (also installed in GAC as a try) - 5.0.11.316
Telerik.Reporting.XamlRendering.dll (also installed in GAC as a try) - 5.0.11.316

Of course SL project references:
Telerik.ReportViewer.Silverlight - 5.0.11.316

First I have tried without luck with the multisite bindings enabled (.NET 4 feature) as it works perfectly with the dev environment:
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
then I've tried to explicetely define telerik services and bindings (as stated in documentation):

 

  <system.serviceModel>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
    <services>
      <service
              name="Telerik.Reporting.Service.ReportService"
              behaviorConfiguration="ReportServiceBehavior">
        <endpoint
               address=""
               binding="basicHttpBinding"
               contract="Telerik.Reporting.Service.IReportService">
          <identity>
            <dns value="localhost" />
          </identity>
        </endpoint>
        <endpoint
                address="resources"
                binding="webHttpBinding"
                behaviorConfiguration="WebBehavior"
                contract="Telerik.Reporting.Service.IResourceService"/>
        <endpoint
                address="mex"
                binding="mexHttpBinding"
                contract="IMetadataExchange" />
      </service>
    </services>
    <behaviors>
      <serviceBehaviors>
        <behavior name="">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="true" />
        </behavior>
        <behavior name="ReportServiceBehavior">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="false" />
        </behavior>
      </serviceBehaviors>
      <endpointBehaviors>
        <behavior name="WebBehavior">
          <webHttp />
        </behavior>
      </endpointBehaviors>
    </behaviors>
  </system.serviceModel>
Unfortunately none of the above solution worked in my case.
Report works fine in my dev environment, is developed in SL4, under VS 2010.
The event viewer of the server doesn't report any error.
Looking at the WCF tracing (using tracing viewer) I see that telerik service is correctly open and the closed.
Also navigating to the service uri ("...\ReportService.sc") it correctly shows the service signatures.

I've create a great telerik report, my clients are ansious to see the final effect :)

Do you have any ideas on what could be wrong?

Adolfo Marinucci



Stef
Telerik team
 answered on 09 Aug 2013
1 answer
206 views
I'm using telerik reports with stored procedures and after upgrading to Q2 2012 I receive errors in the report viewer when trying to preview reports using sp's. I also have quite a few reports using dataset which runs fine still.

I use string as input parameter type and convert to uniqueidentifier inside the sp using the CAST function. This worked like a charm in my previous install (Q2 2008), but trying to run the same reports now gives the following error: 
 
An error has occured while processing Report 'some_report_name':
Conversion failed when converting from a character string to uniqueidentifier

When debugging the sp and copying the same value as I use as default value in the report parameter dialog into the input parameter value field, the sp runs fine. So it looks to me like the value of this param gets invalidated somehow between the report viewer initiation and the execution of the sp.  Any ideas ?

TIB
Tor Ivar
Top achievements
Rank 1
 answered on 09 Aug 2013
5 answers
291 views
my png image is stored on a Uri object and it has the following format
"pack://application:,,,/AppName.Modules.App.Shared;component/Images/AppName_logo.png"

how do I put this image into the .value property of a PictureBox element in my report.

regars.
Wadigzon
Top achievements
Rank 1
 answered on 08 Aug 2013
3 answers
813 views
I have a report and i need to insert a page break based upon a group. I already know that i can insert page break after any report section. But i need to break page in the detail section. I have a scenario something like that:
There are some summary rows (Based on a customer). After the summary rows, I want to show the details against that customer. This goes on for multiple customers. I need to break page after one customer's data ends. Now, i need to know that is there a way to insert page breaks within a section (Not after a section, i know it is possible).

I know this is not possible, but is this functionality added in the latest version (2013 Q1)...?
Stef
Telerik team
 answered on 08 Aug 2013
1 answer
42 views
Hi all,
Please can anybody help me out that how this report should be implemented. i'm totally getting freaking out... and the deadline is closed ahead..

kind regards
Squall
Top achievements
Rank 1
 answered on 07 Aug 2013
1 answer
106 views
Hi,
we are developing a custom report designer for end users. The designer works against the CLR API while reports are persisted as serialized trdx.

To provide our designer with additional information, we decided to extend some of the classes. While this works just fine in some cases, it breaks the serialization in others.

Working example:
public class ExtendedColumn : TableBodyColumn
{
  public string Name { get; set; }
}


Broken example:
public class ExtendedTable : Table
{
  public int HeaderHeight { get; set; }
}

While the additional property is in fact being serialized, some parts of the base class are not. In this case the table's xml node '<Corner />' remains empty and the table body's node '<Cells/>' is missing.

Is there another way to achieve the desired behavior?

Kind regards
Sebastian
Elian
Telerik team
 answered on 07 Aug 2013
7 answers
305 views
well the code below works fine on development machine but when moving it to the web i get the error in the graphic.

Here is the code:
private void crosstab1_NeedDataSource(object sender, EventArgs e)
{
  using (EntitiesModel dbContext = new EntitiesModel())
  {
    int dealid = Global.GetInt32(this.ReportParameters["dealID"].Value.ToString());
    int version = Global.GetInt32(this.ReportParameters["version"].Value.ToString());
    bool amended = Global.GetBool(this.ReportParameters["amended"].Value.ToString());
    bool postContract = Global.GetBool(this.ReportParameters["postContract"].Value.ToString());
    bool staging = Global.GetBool(this.ReportParameters["staging"].Value.ToString());
    bool commOption = Global.GetBool(this.ReportParameters["commOption"].Value.ToString());
 
    IEnumerable<rsDealsDealerOpt> d = dbContext.GetDealsDealerOptions(dealid, version, postContract, staging, amended, commOption);
 
    crosstab1.DataSource = d;
  }
Any thoughts on what is going on?

Thanks,
Richard

richard
Top achievements
Rank 1
 answered on 06 Aug 2013
2 answers
69 views
Hello.

Using version 6.2.12.1017 with Silverlight. 
I have a cross tab report with NeedDataSource event loading report data. The report has toggle visibility actions to collapse/expand cross tab row/column groups. On my dev box everything works as expected.

Once deployed to QA environment, toggle actions result in empty report, not blank but like if no data.

After some research I found that on my dev box NeedDataSource is fired only once, toggle actions don't fire it. I guess in this case data is taken from cache. But in QA I see NeedDataSource is fired for every toggle click. In addition to in, despite of multiple event firing, report items binding doesn't work, that's why report is empty.

Could someone point me to some solution for this. I checked configuration, files, everything is the same with my dev box. Now have no idea what can cause such misbehavior.

Thanks in advance.



Dmitry
Top achievements
Rank 1
 answered on 06 Aug 2013
1 answer
391 views
There is documentation on how to program a Graph (http://www.telerik.com/help/reporting/graphhowtocreateprogrammaticallygraph.html), but I can't find any to programmatically create a Telerik Report.- How do you do this?

I have tried this, but am not sure if I am on the right track?
Following the Graph's tutorial, what Telerik.Reporting.Report() properties must I set, other than 'Name'?


    public partial class Report1 : Telerik.Reporting.Report
    {
        public Report1()
        {
            //InitializeComponent();  //Not used, as not using Designer...right??
 
            //Set up the datasource:
            Telerik.Reporting.SqlDataSource sqlDataSource = new Telerik.Reporting.SqlDataSource();
            sqlDataSource.ProviderName = "System.Data.SqlClient";
            sqlDataSource.ConnectionString = "Data Source=...";
            sqlDataSource.SelectCommand = "SELECT...";
 
            //Instantiate report:
            var report = new Telerik.Reporting.Report();
            report.Name = "theReport"; //What other properties must I set??
             
            //Set the data item's DataSource property to the SQL datasource:
            report.DataSource = sqlDataSource;
 
            //Some parameters:
            sqlDataSource.Parameters.Add("@Fields.Name", System.Data.DbType.String, "Blade");
 
            //Export to PDF:
            exportToPDF(report);
             
           }
}
Squall
Top achievements
Rank 1
 answered on 06 Aug 2013
2 answers
882 views
I'm working on a report where I am grouping items together in Panels so that I can correctly dock elements to achieve the right layout.  I have the individual items set to CanShrink = true and CanGrow = true, however the Panels seem to remain the same size.

Is there a way to autosize Panels to their contents?
Daniel Mettler
Top achievements
Rank 2
Iron
 answered on 06 Aug 2013
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?