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.

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.

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?

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.

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

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.

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).

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 ?

Hi everyone, in my project I need to create a Graph with custom color for each series. I need to bind the series color to color codes stored in my database.

How can i do this ?

Best regards,

Julien