Telerik Forums
Reporting Forum
13 answers
218 views
Hi

I'm new to Telerik.Reporting.
I installed the package and made a report with data from a db using DataSet, and DataSetTableAdapter.
Btw: Environment: Web-Application (Ajax enabled), Master- and Content-Pages.

The first calling of the page ended with an error: something is missing in web.config:

<

 

add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.xxx, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />

 


So I added this one line into the web.config (changed "Version" to: 3.0.9.430) and the report showed up. Even the passed parameter for the SQL-Query worked. (ContentPage: ReportViewer -> ReportLibrary: Report -> TableAdapter.fill(DataSetTable, ParameterValue)

Now the bad thing:
Just below the output of the correctly generated report (even the footer and the pagenumbers are displayed) appears always this error message:

Serverfehler in der Anwendung /.  
--------------------------------------------------------------------------------  
 
Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.   
Beschreibung: Unbehandelte Ausnahme beim Ausführen der aktuellen Webanforderung. Überprüfen Sie die Stapelüberwachung, um weitere Informationen über diesen Fehler anzuzeigen und festzustellen, wo der Fehler im Code verursacht wurde.   
 
Ausnahmedetails: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.  
 
Quellfehler:   
 
Beim Ausführen der aktuellen Webanforderung wurde einen unbehandelte Ausnahme generiert. Informationen über den Ursprung und die Position der Ausnahme können mit der Ausnahmestapelüberwachung angezeigt werden.    
 
Stapelüberwachung:   
 
[NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.]  
   ᜣ.ᜀ(HttpResponse A_0) +193  
   ᜣ.ᜂ(Object A_0, EventArgs A_1) +550  
   System.EventHandler.Invoke(Object sender, EventArgs e) +0  
   System.Web.HttpApplication.RaiseOnPreSendRequestHeaders() +8804047 
I don't have any code that's been executed after the display of the report. 

My guess is, something else is missing in the web.config file.
These are the entries in the web.config I found for "Reporting" (and the whole httpHandlers Section):

<?xml version="1.0"?>  
<configuration> 
    ...  
    <system.web> 
        ...  
        <compilation defaultLanguage="c#" debug="true">  
            <assemblies> 
                ...  
                <add assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Processing, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Interfaces, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.Reporting.HtmlEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>  
                <add assembly="Telerik.ReportViewer.Design, Version=3.0.9.430, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/></assemblies> 
                ...  
        </compilation> 
        ...  
        <httpHandlers> 
            <remove verb="*" path="*.asmx"/>  
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>  
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>  
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>  
            <add verb="*" path="Telerik.ReportViewer.axd" type = "Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" /> 
            <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4" verb="*" validate="false"/>  
            <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.RadUploadProgressHandler, Telerik.Web.UI"/>  
            <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false"/>  
        </httpHandlers> 
        ...  
    </system.web> 
    ...  
</configuration> 
 

Does anyone have a clue or a good guess?

TIA
Markus
Fridli Jacober
Top achievements
Rank 1
 answered on 27 Apr 2015
1 answer
79 views

I have a stored procedure that return a recordset of html rows, such as the following: 

row1: <tr class='cr38ReportHeader'><th>WBS</th>
row2: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
row3: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
row4: <th align='center' colspan='1'>ABC<br/>XYZ<br/>07/01/12 - 12/31/12<br/>183</th>
...etc

So each row in the recordset holds some HTML. I'm wonder what is the best was to present this in a Telerik report. 

I've currently tried to concatenate all rows into a string set the value of an htmltextbox to concatenated string. This did not work. 

Any ideas?

Thanks.

Stef
Telerik team
 answered on 27 Apr 2015
3 answers
172 views

I'm trying to create a delimited string of values from the values selected via report multi-select parameter. How can I conduct a user function on a multi-select parameter, like the following:

Telerik.Reporting.Processing.Report rpt = (Telerik.Reporting.Processing.Report)sender;
string ids = Join(",", rpt.Parameters["IDs"].Value)

This does not work in the ItemDataBinding event handler. 

Thanks.

Stef
Telerik team
 answered on 27 Apr 2015
3 answers
75 views
I create a main report, created four sub report in the main report statements. In 2015 Q1 version can work normally, but in the 2015 Q1 SP1 version, the four sub report run-time anomalies, four sub report no longer use since the data sources, using only the first child report data sources. Due to the rest of the three sub report data showed abnormal.
Stef
Telerik team
 answered on 27 Apr 2015
5 answers
276 views

1)Create a .trdx file that requires one or more parameters / report won't run without specifying a parameter

2) Load that trdx file into the CSharp.MvcDemo sample that ships with Telerik Reporting

 3) You get a clunky error message:

Error creating report instance (Report = XXX.trdx):
Missing or invalid parameter value. Please input valid data for all parameters

4) You input the report parameters

5) The user thinks the preview button will make the report refresh, but it does not.  You have to hit the circle refresh button on the upper left to actually get the report.

Item 5. This seems like there has to be something gone awry here.  The preview button does not seem to actually do anything.  The clunky error message in item 3 seems bizarre as well.  How do I change that to something more sane?

Seems like I have to be missing something.  Seems like a straight forward use case to have people input report parameters before running the report.  Can I get some feedback / help?

Stef
Telerik team
 answered on 27 Apr 2015
3 answers
418 views

I've tried everything I can come up with to do this simple task:

Basic line graph with one category and 2 line series.  One line shows a sales value and the other shows budgeted sales.  Budgeted sales goes to the end of the year and the sales line becomes 0 after the current date.  I've tried to use conditional formatting on the line series to hide the line on 0 values but it doesn't work. How do I make the line stop and hide the rest instead of showing a drop down to 0?

Thanks,

Chris.

 

 

Ivan Hristov
Telerik team
 answered on 27 Apr 2015
7 answers
167 views

I have followed the instructions on how to install Telerik Reports into Lightswitch.
http://blogs.telerik.com/blogs/posts/11-04-12/how-to-telerik-reporting-in-microsoft-lightswitch-beta-2.aspx
I am so frustrated I have been working at this in the evenings for two weeks and have not been able to get the darn thing to work.

I guess I do not understand how the magic works in getting the WCF service linked up to the Lightswitch application.
I have a LS app that I placed the WCF service project in. Is that all? Do I need to compile the WCF and install it somewhere?

I starts rendering the report then BOOM
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.RenderAndCacheEventArgs.get_RenderingResult()
   at Telerik.ReportViewer.Silverlight.ReportViewerModel.OnRenderAndCacheCompleted(Object sender, RenderAndCacheEventArgs e)

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

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

I have never worked with WCF and need a little hand holding to get this working.
Can someone from the community give me advice?
Thanks
Cliff

Cliff McManus
Top achievements
Rank 1
 answered on 26 Apr 2015
3 answers
171 views

Hey smart folks I need your help again.

I have a LightSwitch Application (in browser Silverlight app) that has a Telerik Silverlight report viewer implemented.

I also have a second solution that implements the Reports and WCF Service.  I have successfully deployed both the LightSwitch application and the WCF service to two separate websites on Azure.

The application works fine but when I attempt to display the reports in the report viewer I get the following error.

The error occurs after I have set all of the report parameters on the LightSwitch side in the report’s renderbegin event handler.

Exception message
System.ServiceModel.CommunicationException :

There was an error while trying to serialize parameter Telerik.ReportService:parameters.

The InnerException message was 'Type 'System.Int32[]' with data contract name
'ArrayOfint:http://schemas.microsoft.com/2003/10/Serialization/Arrays' is not expected.


Add any types not known statically to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding
them to the list of known types passed to DataContractSerializer.'.  Please see InnerException for more details.

   at System.ServiceModel.Channels.Remoting.RealProxy.Invoke(Object[] args)
   at proxy_3.BeginRenderAndCache(String , String , NameValueDictionary , NameValueDictionary , AsyncCallback , Object )
   at Telerik.Reporting.Service.SilverlightClient.ReportServiceClient.OnBeginRenderAndCache(Object[] invalues, AsyncCallback asyncCallback, Object state)
   at System.ServiceModel.ClientBase`1.InvokeAsync(BeginOperationDelegate beginOperationDelegate, Object[] inValues, EndOperationDelegate endOperationDelegate, SendOrPostCallback operationCompletedCallback, Object
userState)

 
The report needs the following parameters which are set in the LightSwitch application
     StudioId         Int32
     StudentIds     Int32[] //* Note this is an Int array*
     SortCriteria1  string
     SortCriteria2  string
     SortCriteria3  string
     DisplayName string

What is this telling me and what do I need to do to correct the problem.

Thanks again
Cliff
Code Follows

 The WCF service is basically an empty shell
IReportService like this
namespace WcfReportingService1
{
    [ServiceContract]
    public interface IReportService
    { 
    }
}

ReportService.svc like this
namespace WcfReportingService1
{
    public class ReportService :  IReportService
    { 
    }
}

WebConfig like this
<?xml version="1.0"?>
 
<configuration>
 
  <connectionStrings>
    <!--Connection String for Production - Azure-->
    <add name="Studio_Manager_ConnectionString"
        connectionString="Data Source=xxxxxxx.database.windows.net; Initial Catalog=xxxxxxxxxxx; User Id=xxxxxx;Password=xxxxxxxxx "
        providerName="System.Data.SqlClient" />
  </connectionStrings>
 
  <system.web>
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.5" />
    <customErrors mode="Off"/>
  </system.web>
 
  <system.serviceModel>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="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="ReportServiceBehavior">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="false" />
        </behavior>
      </serviceBehaviors>
      <endpointBehaviors>
        <behavior name="WebBehavior">
          <webHttp />
        </behavior>
      </endpointBehaviors>
    </behaviors>
  </system.serviceModel>
 
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>
 
</configuration>// Any help at all will be greatly appreciated.

// Any help at all will be greatly appreciated.

 

Cliff McManus
Top achievements
Rank 1
 answered on 26 Apr 2015
1 answer
330 views

Hi,

I am using Q2 2014 SP1 of Telerik Reporting.  I am creating the entire Graph object in code (and setting it's datasource), and adding a couple of series to it (a line and a bar).

I need to be able to change the color of the individual bars in the bar series.  I am graphing monthly measurements (metrics) where the Line Series is a "Planned" (like ar Budget) value and the Bar Series is the "Actual" value.  This Actual value will either be above or below the Planned value and if they have hit or exceeded their plan for we want to color the bar Green for that single data point.  If they've missed their plan, we want to color the bar Red.

This is very easy to do with your ASP.NET HTML Chart, but I don't see an example of how to do this with the reporting Graph.  For now, I'm creating my BarSeries as below.

    var actualColumnSeries1 = new Telerik.Reporting.BarSeries();
    actualColumnSeries1.CategoryGroup = productCategoryGroup;
    actualColumnSeries1.CoordinateSystem = cartesianCoordinateSystem1;
    actualColumnSeries1.LegendItem.Value = "Actual";
    actualColumnSeries1.SeriesGroup = orderDateGroup;
    actualColumnSeries1.Y = "=CDbl(IsNull(Fields.ActualValue, 0))";

 

But it seems what I really want to do, is to do it like I do it with the ASP.NET HTML Chart.  With the HTML Chart I:

 

   Dim actualColumnSeries As New ColumnSeries

   For Each bv As MyMetricValue in TheMetricValues

           Dim seriesItem As CategorySeriesItem

           seriesItem = New CategorySeriesItem(bv.ActualValueCalced)
           seriesItem.BackgroundColor = GetDrawingColorFromValueStatus(bv.ActualValueStatusFromDB, False)
           actualColumnSeries.SeriesItems.Add(seriesItem)
   Next

 

Is there a way to do this in the Reporting Graph?  If not, then I'm in a bad spot because I can't use the ASP.NET HTML Charts due to their poor performance in older browser when there are a lot of them on my page (15 or more, and yes I've followed your article regarding performance optimization for the HTMLChart).

Brent Hetland
Top achievements
Rank 1
 answered on 24 Apr 2015
1 answer
151 views

Hi ,

I am working on a POC using Telerik report designer. 

I want to generate a html5 or HTML5Interactive and open it in browser or inside an email body without using Telerik report viewer .

In the report I have a .png image as logo. But when i generated the report programmatically image will be converted to a .bmp and image in the html body is broken.

I can fix this by renaming the image in html by adding the extension to the image . How can i fix this issue directly using a configuration or something ?

Stef
Telerik team
 answered on 23 Apr 2015
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?