My report has as DataSource a stored procedure that needs some parameters in order to be executed.
The parameters should be applied by the user.

Both the disscussed parameters has store procedures as their datasource and are multiselectable.

The selected values of the first parameter should be combined to a string with ',' between the values,
That will be used as input to another sqlDataSource store procedure which is used in the DataSource
of a second report parameter.

I need to combine the values of the first parameter to 1 string, and to refresh the seconed datasource when the first was updated.

// First parameter: 

this.StorageSystemDataSource.ConnectionString = "...";  

this.StorageSystemDataSource.Name = "SystemDataSource";  

this.StorageSystemDataSource.SelectCommand = "dbo.GetSystemType";  

this.StorageSystemDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; 

    

// Second parameter: 

this.SystemNameDataSource.ConnectionString = "..."; 

this.SystemNameDataSource.Name = "SystemNameDataSource"; 

this.SystemNameDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { 

new Telerik.Reporting.SqlDataSourceParameter("@SystemTypes", System.Data.DbType.AnsiString, "=IIF(Parameters.SystemTypeParameter.Value(0) = -1, Nothing, Join(Parameters.SystemTypeParameter.Value, \",\"))")}); 

// is that the way to combine the values????

    

this.SystemNameDataSource.ProviderName = "System.Data.SqlClient"; 

this.SystemNameDataSource.SelectCommand = "dbo.GetSystemByTypes"; 

// I need to reactivate this stored procedure on each selection changes of the first parameter values.

this.SystemNameDataSource.SelectCommandType=Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;

I am currently exporting reports programmatically to pdf and recently have come up with a requirement where we need to export only a single or defined range of pages and not the entire report to the output pdf file. Is there anyway programmatically to only export 1 page or a range of pages ?

Hy, I'm making Payment slip report, I have MultiValue Parameter that starts from let's say A to C and every value have it's Id. Now I'm doing some MOD calculations with this Id's and it gives me different integer values based on selection, but the problem is when it come to C it uses it's value as final one and populates all data in the report with this value witch is no OK. I need to pass changing parameter based on Id and it's calculated value. Example: name A has Id 1 and has value 4, name B has Id 2 and value 2 etc. It should use parameter 4 for name A, Id 1, parameter 2 for name B, Id 2 and so on. Basically every name should have it's own unique calculated value on the report. Is this possible Thank you Aljosa

Hi,

Just wondering if distinct count function has been implemented?   I need a way to do a distinct count on a group level, is there any alternative I can try?

Thanks,

Scott

 

Hello Telerik Team,

I have a requirement to bind two data sources to a single report.I was trying some of your blogs to do that.

The method i used to display a subreport in a main report is as follows:

1>Created a report called "X" and put some fields in it and binded the datasource to that report and build it..its  working fine....As of now,I am not using any parameters.

2>I created another report called "Y" and from the tool box i dropped subreport item and
in the properties section I have selected the report source property as "x".

When i build the report "y" i get the error "Type name x-subreport does not exist in the type "Projectname"

I  tried using Need datasource event and it says the same error.dO i need to add anything to the project file.?

Please let me know.

Can you list the way step by step.
I am unable to achieve it.

Can you send me a sample to do that.

Thank you,
Smith

Hello Telerik community!
I just downloaded the trial version of the reporting software and I am evaluating the product to see how it fits our needs.

Here is the issue #1: we have a report in a spreadsheet format, and the columns that go to the report are code-controlled. Therefore it is not possible to use the visual report designer to fully design the report. Everything must be done by code.
There can be any number of columns, even say 40 columns, and they must fit the page width. The only possible way to do it is to programatically scale the report to fit the output page width (for example 10 inches). In other words, the report is code-created by adding the columns without knowing the total sum of the column widths, and then at the end the total output is scaled to the output page width to fit it in. This is what we do in the MFC version of our software using Ruguewave/Stingray grid. Stingray grid is supporting the scaling feature and it would be nice if Telerik did the same. Is it possible? If yes, is there documentation and code sample to help me do it?

Thank you in advance for your help,
Cezar Mart

Hi all gurus,
we're developing a SL4 app with reporting. In our developing environment reporting works smoothly. Now I'm trying to deploy to a test server and get an error ("No report" inside ReportViewer). Calling the service directly from the browser I get this error:
Type 'Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE', specified as Service attribute in the ServiceHost directive or specified in the system.serviceModel/serviceHostingEnvironment/serviceActivations configuration element was not found (message translated from italian).

The same app uses others WCF services, served smoothly.

I've double-checked that there are no older versions of Telerik. So I installed VS2010, RadControls and Reporting components (both trial, working well in my dev env), compiled and run, with same error. What else I can try?

Web.Config and TelerikService.svc enclosed. Thanks in advance.

====================================================================
TelerikService.svc:
-------------------------------------------------------------------------------------------------------------
<%@ServiceHost Service="Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" %>
==================================================================
Web.Config:
------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <sectionGroup name="system.serviceModel">
      <section name="domainServices" type="System.ServiceModel.DomainServices.Hosting.DomainServicesSection, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </sectionGroup>
  </configSections>
  <connectionStrings>
    <clear />
    <add name="UGo_DB" connectionString="data source=(local)\SQL_UGO;Integrated Security=SSPI;Initial Catalog=UGO_DB;" providerName="System.Data.SqlClient" />
    <add name="Progr_Entities" connectionString="metadata=res://*/Models.Progr.csdl|res://*/Models.Progr.ssdl|res://*/Models.Progr.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQL_UGO;Initial Catalog=UGO_DB;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
  <system.web>
    <httpModules>
      <add name="DomainServiceModule" type="System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    </httpModules>
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      </assemblies>
    </compilation>
    <roleManager enabled="true" />
    <authentication mode="Forms">
      <forms name=".UGO_Adv_ASPXAUTH" />
    </authentication>
    <profile>
      <properties>
        <add name="FriendlyName" />
      </properties>
    </profile>
  </system.web>
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <modules runAllManagedModulesForAllRequests="true">
      <add name="DomainServiceModule" preCondition="managedHandler" type="System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
    </modules>
  </system.webServer>
  <system.serviceModel>
    <domainServices>
      <endpoints>
        <add name="OData" type="System.ServiceModel.DomainServices.Hosting.ODataEndpointFactory, System.ServiceModel.DomainServices.Hosting.OData, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
      </endpoints>
    </domainServices>
    <behaviors>
      <serviceBehaviors>
        <behavior name="">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="false" />
        </behavior>
        <behavior name="ReportServiceBehavior">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="false" />
        </behavior>
      </serviceBehaviors>
      <endpointBehaviors>
        <behavior name="WebBehavior">
          <webHttp />
        </behavior>
      </endpointBehaviors>
    </behaviors>
    <bindings>
      <customBinding>
        <binding name="UGO_Adv.updProg.customBinding0">
          <binaryMessageEncoding />
          <httpTransport />
        </binding>
      </customBinding>
    </bindings>
    <services>
      <service name="UGO_Adv.updProg">
        <endpoint address="" binding="customBinding" bindingConfiguration="UGO_Adv.updProg.customBinding0" contract="UGO_Adv.updProg" />
        <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
      </service>
    <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>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />
  </system.serviceModel>
  <appSettings>
    <add key="microsoft.visualstudio.teamsystems.backupinfo" value="1;web.config.backup" />
  </appSettings>
</configuration>
=========================================================================

Hi folks - this is a repost of something I sent to Telerik support.  They responded with the standard RTFM response. Has anyone else seen this error?
-----------------------------------
I am working with a project and was using the trial version of reports. Everything was working fine. I upgraded to the purchased version, and I'm now getting the error below.

The steps I took to upgrade included:

Uninstalling trial version
Installing purchased version
Removed all old references from projects
Added new references and set copy local to true
Rebuild all

The project starts fine - and the viewer loads fine - but when I load a report, I get the following error (I actually get three of them - for different "renderers").  If I continue, the report works fine.  Any thoughts?

Error:
System.TypeLoadException crossed a native/managed boundary
  Message=Could not load type 'Telerik.Reporting.XamlRendering.SilverlightXamlRenderer' from assembly 'Telerik.Reporting, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'.
  Source=mscorlib
  TypeName=Telerik.Reporting.XamlRendering.SilverlightXamlRenderer
  StackTrace:
       at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
       at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
       at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
       at System.Type.GetType(String typeName, Boolean throwOnError)
       at Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName)
  InnerException:

Thanks.

Hi to everyone,

I'm receiving the following error while trying to preview a report (created with a previous version of Telerik Reporting) using the current version (Q3 2010): "Error: The Expression contains undefined function call LeafNumber()".
The report (created in VS2010) gets its data from a stored procedure: I used the profiler, and the SP on SQL Server 2008 R2 is correctly called from within the preview page, the data is returned correctly, but I always get this error.

Prior to upgrade there was no problem in displaying the report.

I tried to search in the forums "leafnumber" but I found no result.

Could you please help?
Thanks in advance. 

Hi,

I have a report where I have a header set on all the pages using property called 'Print on every page'. However I want to restrict the heading on a particulare page where I get my summary tables. To put it another way I want to avoid the page header if my Summary table starts on a new page. Please help

Thanks