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
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.
<?
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
>
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
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.
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.
Hi,
I want to bind a textbox in a report with a specific value of a specific row from object context.
Thanks,
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")
)