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
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.