Telerik Forums
Reporting Forum
2 answers
153 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
736 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
695 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
346 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
246 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
202 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
1 answer
130 views

Hi, 

I want to bind a textbox in a report with a specific value of a specific row from object context.

Thanks,

Stef
Telerik team
 answered on 03 Nov 2016
1 answer
162 views

Hello,

I use Telerik MVC. Sample Report viewer, created with Visual Studio 'Teleik MVC Report Viewer' works fine. I use .trdp file from disk.  But it works only in IISExpress, with UTL like http://localhost:51330/. When I tried do same in VD, it shows Viewer controls, renders process of reportting, shows 8 pages completed (correct), but does not show report's content. And viewer controls looks incomplete. I think, the problem is in relative paths.I have changed all path to absolute, but it does not help

   <script src="@Url.Content("http://localhost/MY_VD/ReportViewer/js/kendo.subset.2015.3.930.min.js")"></script>

...
<script src="@Url.Content("http://localhost/MY_VD/ReportViewer/js/telerikReportViewer-10.2.16.914.min.js")"></script>

.

@(Html.TelerikReporting().ReportViewer()
        // Each report viewer must have an id - it will be used by the initialization script
        // to find the element and initialize the report viewer.
        .Id("reportViewer1")
        // The URL of the service which will serve reports.
        // The URL corresponds to the name of the controller class (ReportsController).
        // For more information on how to configure the service please check http://www.telerik.com/help/reporting/telerik-reporting-rest-conception.html.
        .ServiceUrl(Url.Content("http://localhost/MY_VD/api/reports"))
        // The URL for the report viewer template. The template can be edited -
        // new functionalities can be added and unneeded ones can be removed.
        // For more information please check http://www.telerik.com/help/reporting/html5-report-viewer-templates.html.
        // .TemplateUrl(Url.Content("/ReportViewer/templates/telerikReportViewerTemplate-10.2.16.914.html"))
        // Strongly typed ReportSource - TypeReportSource or UriReportSource.
        .ReportSource(new UriReportSource() { Uri = "myreport.trdp" })
        // Specifies whether the viewer is in interactive or print preview mode.
        // PrintPreview - Displays the paginated report as if it is printed on paper. Interactivity is not enabled.
        // Interactive - Displays the report in its original width and height with no paging. Additionally interactivity is enabled.
        .ViewMode(ViewMode.Interactive)
        // Sets the scale mode of the viewer.
        // Three modes exist currently:
        // FitPage - The whole report will fit on the page (will zoom in or out), regardless of its width and height.
        // FitPageWidth - The report will be zoomed in or out so that the width of the screen and the width of the report match.
        // Specific - Uses the scale to zoom in and out the report.
        .ScaleMode(ScaleMode.Specific)
        // Zoom in and out the report using the scale
        // 1.0 is equal to 100%, i.e. the original size of the report
        .Scale(1.0)
        // Sets whether the viewer’s client session to be persisted between the page’s refreshes(ex. postback).
        // The session is stored in the browser’s sessionStorage and is available for the duration of the page session.
        .PersistSession(false)
        // Sets the print mode of the viewer.
        .PrintMode(PrintMode.AutoSelect)
        .TemplateUrl("http://localhost/MY_VD/ReportViewer/templates/telerikReportViewerTemplate.html")
)


Stef
Telerik team
 answered on 03 Nov 2016
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?