Telerik Forums
Reporting Forum
1 answer
110 views
Hello, we have reports defined in our primary web site project, in the web.config for that project are connection strings are specified in a seperate file using the configSource attribute, for example:

<connectionStrings configSource="Config\connectionStrings.local.config" />

This works fine at runtime, the report displays the correct data, however at design time the data explorer and preview return an error that indicate it can not find the connection string.  It is the standard "Unable to establish a connection to the database."

If the web.config is changed to include the connection string directly in the same file then the preview and data explorer work correctly.  
Is there some way to get the reporting designer capabilities to work with connection strings specified with a configSource?

I should mention that we are using the name of the connection string on the data source.

Thanks
Joe


Peter
Telerik team
 answered on 22 Feb 2011
1 answer
102 views
Hi there,

Can Telerik reporting convert tool convert from Crystal Report 8 .rpt files to SQL reporting .rdl files.

Cheers,
Dalbir Singh,
IGT Systems 
Steve
Telerik team
 answered on 22 Feb 2011
6 answers
273 views
I have many reports built in a prior version of Telerik Reporting, and have since upgraded to Q2 2010.  In trying to build a new report I am having a problem with specifying the DataSource for the chart as well as the chart's report parameters.

I have several existing DataSources defined in the project, but in my new report when I click on the pulldown button for DataSource, none of these existing DataSources are available for selecting.  The Current Data Sources and Project Data Sources lists are empty.

Not sure what I might be doing wrong.
Dan
Dan
Top achievements
Rank 2
 answered on 21 Feb 2011
1 answer
149 views
Hi, I need make report for job sheduler. I made crosstab with rows - users and columns - days/daypart(am, pm). in each cell i need subreport for show list of activities.
If i make this report without split by daypart (rows - users and columns - days) then all worked correctly. subreport executed for each days, but if i add daypart as second group of crosstab then subreport executed only two times (am, pm) only for first day and in all cells for each date shown first date data .

I trying use List instead Subreport... dont worked too.
How i can fix this?

I use latest version of reporting (4.2.11.204)
Peter
Telerik team
 answered on 21 Feb 2011
1 answer
701 views
Dear support team,

i start using for the first time Telerik Report. When i make my first publish in the server (IIS 7.5) i get the following error:
"Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified."

Can you please help me because i cannot access my page from the server. From my dev pc, is working fine.

Bellow you will find error page and my web config file.

! ASAP Please because is very urgent.

Thank you in advance for your time.

Best regards,
George.
Navarino Technology Department.



Server Error in '/' Application.
--------------------------------------------------------------------------------
 
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
 
Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.
 
Source Error:
 
 
Line 81:                <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
Line 82:                <add assembly="System.Speech, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
Line 83:                <add assembly="Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
Line 84:                <add assembly="Telerik.Reporting, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/></assemblies>
Line 85:        </compilation>
  
 
Source File: C:\inetpub\NavarinoWebPortal\web.config    Line: 83
 
Assembly Load Trace: The following information can be helpful to determine why the assembly 'Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' could not be loaded.
 
 
=== Pre-bind state information ===
LOG: User = PANDORA\PortalUser
LOG: DisplayName = Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be
 (Fully-specified)
LOG: Appbase = file:///C:/inetpub/NavarinoWebPortal/
LOG: Initial PrivatePath = C:\inetpub\NavarinoWebPortal\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\inetpub\NavarinoWebPortal\web.config
LOG: Using host configuration file: C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Aspnet.config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\config\machine.config.
LOG: Post-policy reference: Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/Temporary ASP.NET Files/root/21b16e61/2f5cf764/Telerik.ReportViewer.WebForms.DLL.
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/Temporary ASP.NET Files/root/21b16e61/2f5cf764/Telerik.ReportViewer.WebForms/Telerik.ReportViewer.WebForms.DLL.
LOG: Attempting download of new URL file:///C:/inetpub/NavarinoWebPortal/bin/Telerik.ReportViewer.WebForms.DLL.
LOG: Attempting download of new URL file:///C:/inetpub/NavarinoWebPortal/bin/Telerik.ReportViewer.WebForms/Telerik.ReportViewer.WebForms.DLL.
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/Temporary ASP.NET Files/root/21b16e61/2f5cf764/Telerik.ReportViewer.WebForms.EXE.
LOG: Attempting download of new URL file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/Temporary ASP.NET Files/root/21b16e61/2f5cf764/Telerik.ReportViewer.WebForms/Telerik.ReportViewer.WebForms.EXE.
LOG: Attempting download of new URL file:///C:/inetpub/NavarinoWebPortal/bin/Telerik.ReportViewer.WebForms.EXE.
LOG: Attempting download of new URL file:///C:/inetpub/NavarinoWebPortal/bin/Telerik.ReportViewer.WebForms/Telerik.ReportViewer.WebForms.EXE.
 
  
 
 
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955




<?xml version="1.0"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
    <configSections>
        <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
            <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
                <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
                    <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
                    <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
                    <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
                    <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
                </sectionGroup>
            </sectionGroup>
        </sectionGroup>
    </configSections>
    <appSettings/>
    <system.web>
        <sessionState mode="InProc"></sessionState>
        <roleManager defaultProvider="CustomProvider">
            <providers>
                <add connectionStringName="ConnectionString" name="CustomProvider" type="System.Web.Security.SqlRoleProvider"/>
            </providers>
        </roleManager>
        <membership defaultProvider="CustomMembershipProvider">
            <providers>
                <add name="CustomMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ConnectionString" applicationName="NavarinoPortalTestApp"/>
            </providers>
        </membership>
        <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
 
            Visual Basic options:
            Set strict="true" to disallow all data type conversions
            where data loss can occur.
            Set explicit="true" to force declaration of all variables.
        -->
        <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
        <compilation debug="true" strict="false" explicit="true">
            <assemblies>
                <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
                <add assembly="System.Speech, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add assembly="Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/>
                <add assembly="Telerik.Reporting, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE"/></assemblies>
        </compilation>
        <pages>
            <namespaces>
                <clear/>
                <add namespace="System"/>
                <add namespace="System.Collections"/>
                <add namespace="System.Collections.Generic"/>
                <add namespace="System.Collections.Specialized"/>
                <add namespace="System.Configuration"/>
                <add namespace="System.Text"/>
                <add namespace="System.Text.RegularExpressions"/>
                <add namespace="System.Linq"/>
                <add namespace="System.Xml.Linq"/>
                <add namespace="System.Web"/>
                <add namespace="System.Web.Caching"/>
                <add namespace="System.Web.SessionState"/>
                <add namespace="System.Web.Security"/>
                <add namespace="System.Web.Profile"/>
                <add namespace="System.Web.UI"/>
                <add namespace="System.Web.UI.WebControls"/>
                <add namespace="System.Web.UI.WebControls.WebParts"/>
                <add namespace="System.Web.UI.HtmlControls"/>
            </namespaces>
            <controls>
                <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
                <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/>
            </controls>
        </pages>
        <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
        <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
        <authentication mode="Forms">
            <forms name="NavCook" cookieless="UseCookies" loginUrl="Default.aspx" protection="All" path="/" timeout="30" slidingExpiration="true"/>
        </authentication>
        <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.
 
        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
        <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.
 
        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
        <httpHandlers>
            <remove path="*.asmx" verb="*"/>
            <add path="*.asmx" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
            <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false"/>
            <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false"/>
            <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false"/>
            <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false"/>
            <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false"/>
            <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="true"/>
        </httpHandlers>
        <httpModules>
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule"/>
        </httpModules>
        <identity impersonate="true"/>
        <machineKey decryptionKey="6E747FE5AA9B909F389651607A0FFF5FCB970C297C3281BF,IsolateApps" validationKey="EB5910C4FBCDB0BB976E840F6FF9CFB57BC5736E83E426649B0F635851FC3E0AFBB05E67EC2751B8069B9553FF634DBF9C523E6283EB4C91567404EDA01D49E9,IsolateApps"/>
        <!-- Edo tou akyrono to Anonymous authentication -->
        <authorization>
            <!-- Akyrono tous anonymous users -->
            <deny users="?"/>
            <!-- Epitrepo olous tous users -->
            <!--<allow users="*" />-->
        </authorization>
    </system.web>
    <system.codedom>
        <compilers>
            <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
                <providerOption name="CompilerVersion" value="v3.5"/>
                <providerOption name="WarnAsError" value="false"/>
            </compiler>
            <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
                <providerOption name="CompilerVersion" value="v3.5"/>
                <providerOption name="OptionInfer" value="true"/>
                <providerOption name="WarnAsError" value="false"/>
            </compiler>
        </compilers>
    </system.codedom>
    <!--
        The system.webServer section is required for running ASP.NET AJAX under Internet
        Information Services 7.0.  It is not necessary for previous version of IIS.
    -->
    <system.webServer>
        <validation validateIntegratedModeConfiguration="false"/>
        <modules>
            <remove name="ScriptModule"/>
            <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        </modules>
        <handlers>
            <remove name="WebServiceHandlerFactory-Integrated"/>
            <remove name="ScriptHandlerFactory"/>
            <remove name="ScriptHandlerFactoryAppServices"/>
            <remove name="ScriptResource"/>
            <remove name="ChartImage_axd"/>
            <remove name="Telerik_Web_UI_SpellCheckHandler_axd"/>
            <remove name="Telerik_Web_UI_DialogHandler_aspx"/>
            <remove name="Telerik_RadUploadProgressHandler_ashx"/>
            <remove name="Telerik_Web_UI_WebResource_axd"/>
            <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
            <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
            <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=4.2.10.1221, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"/>
        </handlers>
        <defaultDocument>
            <files>
                <clear/>
                <add value="default.aspx"/>
            </files>
        </defaultDocument>
    </system.webServer>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
            </dependentAssembly>
            <dependentAssembly>
                <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
                <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
</configuration>
Steve
Telerik team
 answered on 21 Feb 2011
1 answer
296 views
Dear Support Team,

when i type a specific text, into a text box (about 8 lines), i get the below error.
Can you please help me because i must have the specific text in my Invoice report. It contains the Billing account details.

I use VS.2008 ASP, VB.
Telerik Reporting: v.4.2.10.1221

Thank you in advance for your time.

Best Regards,
George
Navarino Technology Department

Server Error in '/NavarinoWebPortal' Application.
Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "repNewOrdersConf.resources" was correctly embedded or linked into assembly "App_Code.bconli2t" at compile time, or that all the satellite assemblies required are loadable and fully signed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
 
Exception Details: System.Resources.MissingManifestResourceException: Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "repNewOrdersConf.resources" was correctly embedded or linked into assembly "App_Code.bconli2t" at compile time, or that all the satellite assemblies required are loadable and fully signed.
 
Source Error:
 
Line 507:        Me.textBox39.Name = "textBox39"
Line 508:        Me.textBox39.Size = New Telerik.Reporting.Drawing.SizeU(New Telerik.Reporting.Drawing.Unit(14.5, Telerik.Reporting.Drawing.UnitType.Cm), New Telerik.Reporting.Drawing.Unit(3.5000009536743164, Telerik.Reporting.Drawing.UnitType.Cm))
Line 509:        Me.textBox39.Value = resources.GetString("textBox39.Value")
Line 510:        '
Line 511:        'repNewOrdersConf
 
 
Source File: C:\DEV\WebSites\NavarinoWebPortal\App_Code\repNewOrdersConf.vb    Line: 509
 
Stack Trace:
 
[MissingManifestResourceException: Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "repNewOrdersConf.resources" was correctly embedded or linked into assembly "App_Code.bconli2t" at compile time, or that all the satellite assemblies required are loadable and fully signed.]
   System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +7680430
   System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583
   System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583
   System.Resources.ResourceManager.GetString(String name, CultureInfo culture) +74
   System.Resources.ResourceManager.GetString(String name) +9
   repNewOrdersConf.InitializeComponent() in C:\DEV\WebSites\NavarinoWebPortal\App_Code\repNewOrdersConf.vb:509
   repNewOrdersConf..ctor() in C:\DEV\WebSites\NavarinoWebPortal\App_Code\repNewOrdersConf.vb:55
   cInsertNewOrderDone.Page_Load(Object sender, EventArgs e) in C:\DEV\WebSites\NavarinoWebPortal\cInsertNewOrderDone.aspx.vb:24
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
 
 
Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955
Steve
Telerik team
 answered on 21 Feb 2011
3 answers
251 views
Hi,

 
  While searching through forums, i got to know that  it  does not support 3D chart types and
 For real 3D charts we can use  RadChart for Silverlight.

i created charts like bar, pie  by using telerik reporting tool.
but i need to create one  3D chart for my project.

How can we embed the 3D chart in Telerik reporting tool as like other charts.

Thanks for any ideas/suggestions

please send me any link/ information ragarding this as soon as possible.This is one of the requirement for my client.





Massimiliano Bassili
Top achievements
Rank 1
 answered on 21 Feb 2011
4 answers
267 views
I'm building an executive summary report that uses a single group. I only need a summary, so the Details section is hidden, and I only populate the group header and footer with aggregate data (see the reportdesigner.png attachment).  I have brute-forced a solution by manually computing my summary values, the first page of the resulting report is in the reportcapture.png attachment.

The problem is that I will be doing a similar report that is organized the same way, but given it will be generating charts from the details rather than just computing summary information, my current code-behind brute-force solution likely won't work as well.  And I'm thinking that I shouldn't have had to brute-force it in the first place.

The background is that I have a set of Entity-Data Framework objects projected from a simple SQL database.  The two tables in question are a table of Circuits (mapped to Circuit objects in C#), and a master table of logged voltage/power entries.  Each power entry was measured by a meter (and has a relation to yet another table of Meters) and was of course measured from a specific Circuit

EDF has projected an ObjectSet of Circuits, which is my DataSource for the report.  Within each Circuit object, EDF made me a Navigation Property called LoggedACMeterDatas.  I group the report based on the Circuit.id (the table key).  So each group header has as its "focus" a specific Circuit.  Hence the "Fields.Name" and "Fields.Circuit.Location.Name" resolve to the correct thing on a single Circuit object.

The problem is now I want to access the LoggedACMeterDatas (an EntityCollection that is projected from a Foreign-Key Relation), in order to fill in some summary information in the report.  For example, the "Period Start" and "Period End" are the earliest and latest timestamp in the LoggedACMeterDatas .  The power summary fields are each an average of a specific field across all the LoggedACMeterDatas for the current Circuit in the grouping.

I would have liked to build an Expression along the lines of Min(Fields.LoggedACMeterDatas.Timestamp) for the Period Start.  After all, specifying Fields.Name in the group header (which in the context of the entire report is a collection, but in the context of the group is a scalar) seems to do the right thing.  But I could find no way to do that with field that is an EntityCollection.  Similarly, for the power summaries, something like Avg(Fields.LoggedACMeterDatas.VoltagePhase1) to get an average of all the VoltagePhase1 members of the sub-collection.  In short, I can specify Fields.LoggedACMeterDatas in an Expression, but there seems to be precious little I can do with it.

So my brute-force was to add the following properties to the Circuit class, essentially doing the above in code-behind, where I can do something useful with the LoggedACMeterDatas member:
public Double AverageVoltagePhase1
{
get { return (from entry in LoggedACMeterDatas select entry.VoltagePhase1).Average(); } }
public Double AverageVoltagePhase2
{
get { return (from entry in LoggedACMeterDatas where entry.VoltagePhase2.HasValue select entry.VoltagePhase2.Value).Average(); } }
public Double AverageVoltagePhase3
{
get { return (from entry in LoggedACMeterDatas where entry.VoltagePhase3.HasValue select entry.VoltagePhase3.Value).Average(); } }
public Double AverageCurrentPhase1
{
get { return (from entry in LoggedACMeterDatas select entry.CurrentPhase1).Average(); } }
public Double AverageCurrentPhase2
{
get { return (from entry in LoggedACMeterDatas where entry.CurrentPhase2.HasValue select entry.CurrentPhase2.Value).Average(); } }
public Double AverageCurrentPhase3
{
get { return (from entry in LoggedACMeterDatas where entry.CurrentPhase3.HasValue select entry.CurrentPhase3.Value).Average(); } }
public Double AverageWattsPhase1
{
get { return (from entry in LoggedACMeterDatas select entry.WattsPhase1).Average(); } }
public Double AverageWattsPhase2
{
get { return (from entry in LoggedACMeterDatas select entry.WattsPhase2).Average(); } }
public Double AverageWattsPhase3
{
get { return (from entry in LoggedACMeterDatas select entry.WattsPhase3).Average(); } }
public Double AveragePowerFactor
{
get { return (from entry in LoggedACMeterDatas select entry.AvgPowerFactorAllPhases).Average(); } }
public DateTime StartPeriod
{
get { return (from entry in LoggedACMeterDatas orderby entry.Timestamp select entry.Timestamp).First(); } }
public DateTime EndPeriod
{
get { return (from entry in LoggedACMeterDatas orderby entry.Timestamp select entry.Timestamp).Last(); } }

So as I said above, the brute-force workaround is ok in this case, but it seems like I should have been able to do all this in the realm of the report.  Secondly, I don't see how I'm going to be able to build a Chart instead of a table of scalar averages---I'm going to need some mechanism by which I can hand off the EntityCollection to the Chart.  But I don't see how I can do that.

Any help appreciated...
Ivan
Telerik team
 answered on 21 Feb 2011
5 answers
351 views
Hi,

Is there a way to pass parameters from the SIlverlight Report Viewer (or in fact any way from a silverlight app) to the reportservice to be passed into the Report to be run?
I have looked in the documentation and forums but all the examples I can find refer to ASPX or winforms scenarios.

This is an urgent issue for me so if anyone can help it would be much appreciated.

(for clarity, I am trying to pass an 'out of band' type of parameter, not one the user selects. Essentially I need to pass the users id to the report from the client application in order to retrieve appropriate data)

Thanks

Andrew
Steve
Telerik team
 answered on 18 Feb 2011
1 answer
83 views
How can I use UDFs in subreport?  The same function works great in main report, however, it throws error when I use it in subreport.

An error has occurred while processing TextBox 'textBox8':The expression contains undefined function call FormatNos().

In main report, I just use FormatNos(...).  For subreport, the same function is called like <classname>.FormatNos() - I did select them from expression edition by expanding "User functions" - so no typo here.

Would I need to duplicate the functions in all subreport classes?
Peter
Telerik team
 answered on 18 Feb 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?