Telerik Forums
Reporting Forum
3 answers
196 views
I have a simple chart with a line and a bar series. X-axis on the chart represents number of days - Depending on user selection the days can vary from 20 days to 90 days. As soon as number of days starts growing, for instance more than 25 days, the label starts crowding and overlapping each-other. My x-axis is a category axis. How can i adjust increments on x-axis so that it automatically sets certain interval on x-axis to avoid overlapping. Please have a look at attached chart for better explanation of the problem. 
Katia
Telerik team
 answered on 17 May 2017
2 answers
58 views

After installing Glimpse one of our reports using a stored procedure stopped working. I know this is a known issue http://www.telerik.com/forums/telerik-reporting-and-glimpse-bug.

Is there any solution on this?

David
Top achievements
Rank 1
 answered on 17 May 2017
0 answers
125 views

Iam getting values like below

 

Cloumn1             Column2                 Column3

1/1/2000             Disturbing peace      1399

1/1/2000             Disturbing peace      1399

1/1/2000             Assault                      5434

1/1/2000             Assault                      5434

 

But i should get like:

Cloumn1             Column2                 Column3
1/1/2000             Disturbing peace      1399
1/1/2000             Assault                      5434

Dilshad
Top achievements
Rank 1
 asked on 16 May 2017
3 answers
106 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
262 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
212 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
589 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
288 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
84 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
120 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
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?