Telerik Forums
Reporting Forum
3 answers
99 views

We are using the WPF Report Viewer with a REST reporting endpoint.  If you try to switch to/from Print Preview mode and the report happens to have expired, we get a message in the report viewer that says "A problem occurred while creating a report instance".  I would have expected to instead get a message saying something like "Report is unavailable or session has expired".  Our users are used to getting the 'session expired' message from our Silverlight app (using the SL Report Viewer) as that message shows up in various cases.

I know it is a minor, mostly cosmetic issue but having a report expire is not totally uncommon for us so we'd like the user experience to be as friendly as possible.

This may be related to a very similiar issue we ran into with the SL Report Viewer.  In the past, doing these same steps actually lead to a Null Reference Exception message being shown.  See: http://www.telerik.com/forums/null-reference-exception-when-switching-to-from-print-preview-when-a-report-has-expired

Katia
Telerik team
 answered on 16 May 2017
1 answer
246 views

Hi,

i have integrated the new angular ReportViewer component into my angular project. Every think works fine but i want to include the material style into my project without references the styles with the urls from the web like this

<link href="http://kendo.cdn.telerik.com/2016.3.914/styles/kendo.common.min.css" rel="stylesheet" />
<link href="http://kendo.cdn.telerik.com/2016.3.914/styles/kendo.material.min.css" rel="stylesheet" />

Currently, i have not installed the complete kendo ui package, just the package telerik-angular-report-viewer.

I have installed the npm package kendo-theme-default, but the theme does not format the viewer correctly and i want the material style instead of default.

Can i include the material style without installing the complete kendo package or have i another option to include the styles without referencing to a web url?

 

Stef
Telerik team
 answered on 15 May 2017
1 answer
194 views

Hello,

I have one series in column chart that is grouped by a certain field, so i get two columns per x-axis tick.

Now what i would like to do is to set the background of the second column to green if its column value is less than the value of the first colum. And to set the background to red if it is greater than the first column's value.

 

Is this possible in standalone designer?

 

See attached Image

 

Best regards

Benjamin

 

 

Stef
Telerik team
 answered on 15 May 2017
1 answer
554 views

Hi all, using UI for ASP.Net AJAX R2 2017 and Reporting R2 2017.

1) Refer to attached file Report_Upgrade_Error.png. while try to use Upgrade Wizard after opening VS.  

Only way to use Upgrade Wizard by opening the solution from Windows Explorer. Then I can use the wizard. This is the 1st time happened to me after using Telerik Products for many years.

2) After upgrading from Telerik.Reporting, Version=10.2.16.1025 to Telerik.Reporting, Version=11.1.17.503, none of my existing reports works. Refer to attached file Could_Not_Load-File_or_Assembly.jpg.  I searched for the keyword 10.2.16.1025  in my entire solution, no Text found. Below is also my web.config file.

This is some sort of urgent b/c I have 2 ASP.Net solutions that need to be deploy for end-users.

Thanks for any help

gc_0620

______________________________________________

 

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="Telerik.Reporting" type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=11.1.17.503, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere" />
  </configSections>
  <appSettings>
    '''
    ''' 
    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None" />
    <add key="Telerik.ScriptManager.TelerikCdn" value="Disabled" />
    <add key="Telerik.StyleSheetManager.TelerikCdn" value="Disabled" />
  </appSettings>
  <connectionStrings>
    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
    '''
    '''
  </connectionStrings>
  <!--
  For a description of web.config changes see http://go.microsoft.com/fwlink/?LinkId=235367.
  The following attributes can be set on the <httpRuntime> tag.
  <system.Web>
  <httpRuntime targetFramework="4.5.1" />
  </system.Web>
  -->
  <system.web>
    <trust level="Full" />
    <healthMonitoring enabled="false" />
    <compilation debug="true" targetFramework="4.5.1">
      <assemblies>
        <add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Speech, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
        <add assembly="System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
        <add assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91" />
        <add assembly="Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91" />
        <add assembly="Telerik.ReportViewer.WebForms, Version=11.1.17.503, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
        <add assembly="Telerik.Reporting, Version=11.1.17.503, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
      </assemblies>
      <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </buildProviders>
    </compilation>
    <authentication mode="Forms" />
    <authorization>
      <allow users="?" />
    </authorization>
    <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
    <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="UseDeviceProfile" timeout="45" />
    <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
    <membership>
      <providers>
        <clear />
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" />
      </providers>
    </membership>
    <profile>
      <providers>
        <clear />
        <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/" />
      </providers>
    </profile>
    <roleManager enabled="false">
      <providers>
        <clear />
        <add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/" />
        <add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
      </providers>
    </roleManager>
    <httpHandlers>
      <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="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
      <add type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=11.1.17.503, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" validate="true" />
    </httpHandlers>
    <pages controlRenderingCompatibilityVersion="4.0">
      <controls>
        <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI" />
      </controls>
    </pages>
    <httpModules />
    <customErrors defaultRedirect="SystemError.aspx" mode="RemoteOnly">
      <error statusCode="500" redirect="SystemError.aspx" />
    </customErrors>
    <httpRuntime targetFramework="4.5.1" />
  </system.web>
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
    <validation validateIntegratedModeConfiguration="false" />
    <handlers>
      <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="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode" />
      <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode" />
      <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode" />
      <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode" />
      <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode" />
      <add name="Telerik.ReportViewer.axd_*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=11.1.17.503, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" preCondition="integratedMode" />
    </handlers>
    <httpProtocol>
      <customHeaders>
        <clear />
        <add name="X-UA-Compatible" value="IE=edge" />
      </customHeaders>
    </httpProtocol>
  </system.webServer>
  <Telerik.Reporting>
    <Extensions>
      <Render>
        <Extension name="mhtml" visible="false" />
        <Extension name="xps" visible="false" />
        <Extension name="rtf" visible="false" />
      </Render>
    </Extensions>
  </Telerik.Reporting>
</configuration>

Stef
Telerik team
 answered on 15 May 2017
3 answers
271 views
I have Telerik Reporting internal build 6.0.12.504 but this also applies to the release build 6.0.12.215.  I have VS 2010 and .NET 4.0.

The report works fine at run-time but in the report designer when I click on the Preview tab I get the following error in red:

An error has occurred while processing Report 'Report1'.
An error has occurred while invoking data retrieval method. Try restarting Visual Studio.
---- Inner Exception -------
Exception has been thrown by the target of an invocation.
---- Inner Exception -------
No connection string by the name of 'MyContext' could be found in the application config file.

For my report I am using an ObjectDataSource that uses Entity Framework to retrieve data. In fact, I do have a connection string named 'MyContext' in the "app.config" file in my Reports project where the report designs, and report objects are. Am I seeing this error because Preview is not available when using an ObjectDataSource? 

A related question: is there a way to see the report data when in the report designer?
Stef
Telerik team
 answered on 15 May 2017
1 answer
79 views

Hello,

Please see the attached image for a mockup of the desired report in Excel.

What I would like to do is have invoice data set up in a grid, and the data is grouped by company sites (the grey headers that say "Acme Construction" etc are separating the invoice data for each company site.

The areas would be variable height (1 or 2 items per company site in come cases, 10-30 for others)

There are variable amounts of company site per report (each report would contain sites for only one company)

I am new to reporting in general, somewhat new to Telerik, but fluent in programming and C# in general.

How would I go about doing this?

Ps. I have read that when saving to PDF, having different headings on first page vs following pages is a bit problematic. Thoughts?
Katia
Telerik team
 answered on 15 May 2017
1 answer
109 views

I have a report that is fairly simple but for some clients, the report ends up being 60-70 pages.  Since all pages have to generate before the report will show any pages, this sometimes takes up to 2 minutes.  The clients are very unhappy about this.

Is there any setting that I can change to make the pages show quickly and the rest show as they are rendered?

Your help is appreciated.

Katia
Telerik team
 answered on 15 May 2017
1 answer
113 views

Hi, 

I am generating a table dynamically but after generate it to .DOCX file I notice that the table is split into several tables, depending on the length of the table and the size of the page.

¿There is any way to keep the table as just one table? ... although the table is not seen in its entirety?

Thanks

Francisco

Katia
Telerik team
 answered on 15 May 2017
4 answers
797 views

Hi!

In my solution all reports are created with the ReportDesigner and saved as external .trdx files. The files reside at runtime in a common server-directory available to all workplaces. The "path-to-reports" is in the app.config of the main exe and it is no problem to load these .trdx file with a generic method using the ReportXmlSerializer. But two problems occur:

First, the ReportViewer (WPF, version Q1/2015) tries to load all subreports from the \bin\Debug directory of the main exe file, not from the directory where the main report is in. There is no "SubReports" collection in the report itself, instead I have to recursively search all Items for an object of type SubReport and set the "path-to-reports" which is very annoying. Is there another solution?

Second, the above also applies to external Stylesheets which are located in a subdirectory of the reports directory.

Regards
Neils

Trent
Top achievements
Rank 1
 answered on 13 May 2017
1 answer
489 views

Hi!  We are trying to create a report which will let our application print data to an Avery 5066 sheet of labels.  What is the best way to do this?  Can we use the Label Report Wizard?

We've been so far unsuccessful using standard reports - the spacing doesn't line up from label to label.

Thank you,

- Aaron

Stef
Telerik team
 answered on 12 May 2017
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?