Telerik Forums
Reporting Forum
3 answers
78 views
i have 2 panel , when one of them is invisible the space of the panel appear and not remove , i need to remove the space of invisible panel 
Stef
Telerik team
 answered on 10 Nov 2016
1 answer
181 views

Hi All

 

I am looking for a way of creating a report that looks like the multimonth view on the calendar control for winforms, where i can highlight certain days if they meet criteria.

The report is showing the whole year like a multimonth view and for a specific employee, with specific dates having a different background color if the employee had a sick day off or some other type of non productive day.

It is for a customer of mine so they can see if there is a pattern to employees taking sick days off (eg mostly Fridays).

 

Cheers

 

 

Ade

Katia
Telerik team
 answered on 10 Nov 2016
2 answers
150 views
Hello.  It's possible to use reporting under asp.net core, MVC 6 and EF Core?
Louis
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 09 Nov 2016
1 answer
713 views

Hi,

Having example data described in parent_child_01.png (attached to this thread). I'd like to display this data ina parent/child way. Check parent_child_02.png, there are a subset of fields from the example data grouped on fields ProjektNr and Aktivitet. When clicking the + sign I'd like to expand the rest of the data belonging to current ProjektNr and Aktivitet like in parent_child_03.png.

How do I accomplish this. Been tryin around without success. Should I use a table, a crosstab, subreports??

Best regards,

Thomas

Stef
Telerik team
 answered on 09 Nov 2016
1 answer
683 views

Hi, 

I have a table like this 

name             category     quantity

apple                 fruit            3

banana              fruit            4 

broccoli         vegetable       2

oats               cereals          40 

chicken            meat            9

spinaches     vegetable       9 

I want to have a total based on category, like this:

fruit              7

vegetables   11

cereals         40

meats            9

 

Now I'm doing it with IIF, but I have dozens of categories.

 

 

 

Katia
Telerik team
 answered on 08 Nov 2016
1 answer
1.4K+ views
I have developed a web forms web application on .net framework 4.0 that uses forms authentication and I am using telerik's UI for ASP.NET AJAX Q1 2016 controls and telerik reporting R3 2016. The application has been deployed to a server using IIS 7. One page of the application only contains a telerik's html 5 report viewer to generate and view telerik reports. Everything in the application works fine, however when the session times out on the page where I have telerik's report viewer and I click on the preview button on the report, the area of the report shows me the loginurl to log back in. When I try to login using the correct username and password I get an HTTP 404. This page is trying to redirect me to the wrong url: /PowerManager/Login.aspx. This url does not exist the correct loginurl should be /PowerManager/Login/Login.aspx. 
This is only happening on this specific page. If the sessions times out in any other page, the page is redirected to the correct loginurl defined on the web.config.

This web application is the only application deployed on IIS. So I know there is no other cookie with the same name,same path,or identical key as mentioned as some of the causes of this issue per this https://support.microsoft.com/en-us/kb/313116

I have tried also http://www.codeproject.com/Articles/292149/The-resource-cannot-be-found-Account-Login and several other suggestions but none have worked for me.

Please any help would be appreciated I've been trying to fix this for days and nothing seems to fix it. Attached is a picture of when the session times out on the page with the report viewer and I press the preview button on the report paramters area.

Here is my web.config file:
        
<?xml version="1.0" encoding="utf-8"?>
    <configuration>
    <appSettings>
    <add key="Telerik.Skin" value="Metro" />
    <add key="enableSimpleMembership" value="false" />
    <add key="autoFormsAuthentication" value="false" />
    <add key="PreserveLoginUrl" value="true" />
    </appSettings>
    <system.web>
    <!-- 100 MB -->
    <httpRuntime maxRequestLength="102400" />
    <trace enabled="false" mostRecent="true" requestLimit="100" pageOutput="true" localOnly="false" />
    <!-- Authentication Settings -->
    <authentication mode="Forms">
    <forms defaultUrl="~/Default.aspx" loginUrl="~/Login/Login.aspx" name="PowerManagerAuthCookie" path="/" protection="All" timeout="1" enableCrossAppRedirects="false" cookieless="UseCookies" slidingExpiration="true" />
     
    </authentication>
    <!--Deny all users unless authenticated -->
    <authorization>
    <deny users="?" />
    </authorization>
    <compilation targetFramework="4.0">
    <assemblies>
    <add assembly="Telerik.ReportViewer.Html5.WebForms, Version=10.2.16.1025, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
    <add assembly="Telerik.Reporting, Version=10.2.16.1025, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
    <add assembly="Telerik.ReportViewer.WebForms, Version=10.2.16.1025, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" />
    <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
    </assemblies>
    </compilation>
    <pages>
    <controls>
    <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI" />
    </controls>
    </pages>
    <httpHandlers>
    <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 verb="*" path="Telerik.ReportViewer.axd" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=10.2.16.1025, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" validate="false" />
    <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />
    </httpHandlers>
    <membership defaultProvider="DefaultMembershipProvider">
    <providers>
    <clear />
    <add name="DefaultMembershipProvider" applicationName="/PowerManager" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </providers>
    </membership>
    <roleManager enabled="true" defaultProvider="DefaultRoleProvider">
    <providers>
    <clear />
    <add name="DefaultRoleProvider" applicationName="/PowerManager" connectionStringName="LocalSqlServer" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </providers>
    </roleManager>
    <profile enabled="true" defaultProvider="DefaultProfileProvider">
    <providers>
    <clear />
    <add name="DefaultProfileProvider" applicationName="/PowerManager" connectionStringName="LocalSqlServer" type="System.Web.Providers.DefaultProfileProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </providers>
    </profile>
    <!--
                If you are deploying to a cloud environment that has multiple web server instances,
                you should change session state mode from "InProc" to "Custom". In addition,
                change the connection string named "DefaultConnection" to connect to an instance
                of SQL Server (including SQL Azure and SQL  Compact) instead of to SQL Server Express.
          -->
    <sessionState mode="InProc" customProvider="DefaultSessionProvider">
    <providers>
    <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </providers>
    </sessionState>
    </system.web>
    <system.webServer>
    <!-- 15 MB -->
    <security>
    <requestFiltering>
    <requestLimits maxAllowedContentLength="104857600" />
    </requestFiltering>
    </security>
    <validation validateIntegratedModeConfiguration="false" />
    <modules runAllManagedModulesForAllRequests="true" runManagedModulesForWebDavRequests="true" />
    <handlers accessPolicy="Read, Script">
    <remove name="ChartImage_axd" />
    <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode" />
    <remove name="Telerik_Web_UI_SpellCheckHandler_axd" />
    <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode" />
    <remove name="Telerik_Web_UI_DialogHandler_aspx" />
    <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode" />
    <remove name="Telerik_RadUploadProgressHandler_ashx" />
    <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode" />
    <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" />
    <remove name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" />
    <remove name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" />
    <remove name="ExtensionlessUrlHandler-Integrated-4.0" />
    <add name="ExtensionlessUrlHandler-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" />
    <add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" />
    <add name="ExtensionlessUrlHandler-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE,PATCH,OPTIONS" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" />
    <remove name="Telerik.ReportViewer.axd_*" />
    <add name="Telerik.ReportViewer.axd_*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=10.2.16.1025, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" path="Telerik.ReportViewer.axd" verb="*" preCondition="integratedMode" />
     
    </handlers>
    <directoryBrowse enabled="false" />
     
    </system.webServer>
    <location path="Administrator.aspx">
    <system.web>
    <authorization>
    <allow roles="Admin" />
    <deny users="*" />
    </authorization>
    </system.web>
    </location>
    <location path="Messages.aspx">
    <system.web>
    <authorization>
    <allow roles="Admin" />
    <deny users="*" />
    </authorization>
    </system.web>
    </location>
    <location path="Settings.aspx">
    <system.web>
    <authorization>
    <allow roles="Admin" />
    <deny users="*" />
    </authorization>
    </system.web>
    </location>
    <location path="Telerik.ReportViewer.axd"
        <system.web>
          <authorization>
            <allow users="*" /> 
          </authorization>
        </system.web>
      </location>
      <location path="Telerik.Web.UI.WebResource.axd">
        <system.web>
          <authorization>
            <allow users="*" />
          </authorization>
        </system.web>
      </location
    <connectionStrings>
    <clear />
    <add name="LocalSqlServer" connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=Database;User ID=User;Password=123456" providerName="System.Data.SqlClient" />
    <add name="DBConnectionString" connectionString="Data Source=(local)\SQLEXPRESS" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
    <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
    <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />
    </dependentAssembly>   
    </assemblyBinding
    </runtime>
    </configuration>
Katia
Telerik team
 answered on 08 Nov 2016
5 answers
331 views

Hi,

I'm working with the Standalone Report Designer.  I have a bar chart (column variation), and I am aiming to have more interactivity with it.  I am looking to be able to:

(1) Click on the individual bars in the graph to generate another graph based off of which bar was selected.  For example, if I click on the bar corresponding to the state NY, then another graph would generate below the clickable graph with its origin state parameter being NY.

(2) Hover over a bar to display additional information (such as the numerical value of the bar or the name of the item the selected bar is referring to).

Are either or both of these options feasible?  If not, are there any workarounds or ideas to achieve similar functionality?

Thanks,

Joey

Stef
Telerik team
 answered on 07 Nov 2016
6 answers
241 views

I'm using Visual Studio 2015, Telerik Reporting 10.2.16.1025 and Visual Studio Online (hosted Team Foundation).

I've got a report project built and it works and runs just fine. If I publish it manually it works just fine.

The problem comes in when I try to set it up for the continuous integration so I don't have to push it to our QA server a bunch of times during the day. VSO just doesn't want to make use of the Report viewer dlls no matter what I try. I've got copy local set. I've even added them to the solution and checked them into source control (team foundation source control). Nothing works.

The only thing that did work was setting up a private NuGet server and making use of the Nuget package provided by Telerik. 

BUT

When I do that,we can no longer make use of the designer in visual studio.According to the forums, we can only use the GAC version of the dlls if we want to use the designer.

Is there some trick to be able to swap out the GAC dlls with a hosted set or a set that's checked in? Again, this is a hosted TFS so I have no ability to install them on the server.

Stef
Telerik team
 answered on 04 Nov 2016
7 answers
1.2K+ views

Im using Visual Studio telerik report designer.
Im trying to display a one page report with the following query result:

ReportName  Office   ReportInstruction  ContactName ContactPhone  Relevant Info
Report01       Ontario   Print It Out                Tom            123456789      ABC

Report01       Ontario   Print It Out                Tom            123456789      DEF

Report01       Ontario   Print It Out                May            987654321      ABC

Report01       Ontario   Print It Out                May            987654321      DEF


Report layout:
Header
ReportName: Report01
Office: Ontario
Contact Information:
Tom: 123456789
May: 987654321
Relevant Info
ABC
DEF

The way Im doing it now is:

I put [=Fields.ReportName] and [=Fields.Office] in ReportHeaderSection (So these only show up once)
Then I put Contact Information in GroupHeaderSection (group by ContactName)
Then I tried to put Relevant Info. In footerSection (Group By Relevent Info)

The report comes out in many pages and lots of space in between.

Stef
Telerik team
 answered on 03 Nov 2016
1 answer
198 views
i add the controls dynamically in telerik report but it not work . It not displaying pls provide the code and steps for add controls dynamically 
Stef
Telerik team
 answered on 03 Nov 2016
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?