I need to create reports with 2 levels of details. For example:
(top level): Name, SSN, Address
(1st level down): Account type, Account number
(2nd level down): Deposit/Withdrawl amount, date, payee
Can the infragistics report tool perform this?
Can there be multiple parent/child/grandchild hierarchies in the same report?
---
Also, can the data-source for this report be a hierarchical (in this case, 1 parent level + child levels + grandchild levels) xml file? How is the reported to the structure of the xml file?
Thanks!
Can the Telerik Reporting create a report that will, per programming logic remove a "panel" of a report (with this "panel" containing information that is only displayed under certain circumstances): This "inclusion" or "removal" would be based on c# code that creates logic based on data from the datasource's data value(s)?
Maybe what I refer to as a "panel" is a "sub report"...you can tell me in your lingo...
For example, there might be one section of a report that displays if the person is over age 65. Otherwise, that section of the report is not displayed (and the vertical white space is closed to 0"--meaning there is no vertical white-space where this report information would have been displayed).
I tried adding a property called "Values" that exposed the object array and setting the expression to "=Values[2]" but that didn't help either. Got the error "Missing operator before [2] operand." Also tried "=Values.2" and that didn't help either ("Cannot interpret tocken '2' at position 7.").
Everything works find if I create explicit properties on the business object to expose the values in the array, but as I noted previously, this isn't a feasible solution. So is this simply not possible with Telerik Reporting, or am I missing a subtle syntactical requirement? Am I stuck having to take my existing list of business objects and convert them into a data table to use as the report's Data Source?
<
my:ReportViewer
Height
=
"285"
HorizontalAlignment
=
"Right"
Margin
=
"0,-5,102,0"
Name
=
"reportViewer1"
Report
=
"ReportLibrarydev.ReportLibrary,ReportLibrarydev"
ReportServiceUri
=
"http://myserver:1111/myapp/ReportService.svc"
VerticalAlignment
=
"Top"
Width
=
"480"
ZoomPercent
=
"50"
/>
<?
xml
version
=
"1.0"
encoding
=
"UTF-8"
?>
<
configuration
>
<
configSections
>
<
sectionGroup
name
=
"system.serviceModel"
>
<
section
name
=
"domainServices"
type
=
"System.ServiceModel.DomainServices.Hosting.DomainServicesSection, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
allowDefinition
=
"MachineToApplication"
requirePermission
=
"false"
/>
</
sectionGroup
>
</
configSections
>
<
connectionStrings
>
<
add
name
=
"ReportLibrarydev.Properties.Settings.Ecashcdb_devmotovate"
connectionString
=
"Data Source=oops;Initial Catalog=oops;Persist Security Info=True;User ID=oops;Password=oops"
providerName
=
"System.Data.SqlClient"
/>
<
add
name
=
"ReportLibrarydev.Properties.Settings.oops connectionString="
Data
Source
=
oops
;Initial
Catalog
=
oops
;Persist Security
Info
=
True
;User
ID
=
oops
;
Password
=
oops
"
providerName
=
"System.Data.SqlClient"
/>
<
add
name
=
"FilesDataBaseConnectionString"
connectionString
=
"Data Source=oops;Initial Catalog=oops;Persist Security Info=True;User ID=oops;Password=oops"
providerName
=
"System.Data.SqlClient"
/>
</
connectionStrings
>
<
system.web
>
<
httpRuntime
maxRequestLength
=
"2147483647"
executionTimeout
=
"2147483647"
/>
<
identity
impersonate
=
"true"
/>
<
httpModules
>
<
add
name
=
"DomainServiceModule"
type
=
"System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
/>
<
add
name
=
"DomainServiceModule"
type
=
"System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
/>
<
add
name
=
"Session"
type
=
"System.Web.SessionState.SessionStateModule"
/>
</
httpModules
>
<
compilation
targetFramework
=
"4.0"
/>
<
globalization
culture
=
"auto"
uiCulture
=
"auto"
/>
<!-- Enable session state for all the pages in the Web application. -->
<
pages
enableSessionState
=
"true"
enableViewState
=
"true"
enableViewStateMac
=
"true"
validateRequest
=
"false"
/>
</
system.web
>
<
system.serviceModel
>
<
bindings
>
<
basicHttpBinding
>
<
binding
name
=
"BasicHttpBinding_ILogger"
closeTimeout
=
"00:10:00"
openTimeout
=
"00:10:00"
receiveTimeout
=
"00:10:00"
sendTimeout
=
"00:10:00"
allowCookies
=
"false"
bypassProxyOnLocal
=
"false"
hostNameComparisonMode
=
"StrongWildcard"
maxBufferSize
=
"2147483647"
maxBufferPoolSize
=
"2147483647"
maxReceivedMessageSize
=
"2147483647"
messageEncoding
=
"Text"
textEncoding
=
"utf-8"
transferMode
=
"Buffered"
useDefaultWebProxy
=
"true"
>
<
readerQuotas
maxDepth
=
"2147483647"
maxStringContentLength
=
"2147483647"
maxArrayLength
=
"2147483647"
maxBytesPerRead
=
"2147483647"
maxNameTableCharCount
=
"2147483647"
/>
<
security
mode
=
"None"
>
<
transport
clientCredentialType
=
"None"
proxyCredentialType
=
"None"
realm
=
""
/>
<
message
clientCredentialType
=
"UserName"
algorithmSuite
=
"Default"
/>
</
security
>
</
binding
>
<
binding
name
=
"BasicHttpBinding_IBLLService"
closeTimeout
=
"00:10:00"
openTimeout
=
"00:10:00"
receiveTimeout
=
"00:10:00"
sendTimeout
=
"00:10:00"
allowCookies
=
"false"
bypassProxyOnLocal
=
"false"
hostNameComparisonMode
=
"StrongWildcard"
maxBufferSize
=
"2147483647"
maxBufferPoolSize
=
"2147483647"
maxReceivedMessageSize
=
"2147483647"
messageEncoding
=
"Text"
textEncoding
=
"utf-8"
transferMode
=
"Buffered"
useDefaultWebProxy
=
"true"
>
<
readerQuotas
maxDepth
=
"2147483647"
maxStringContentLength
=
"2147483647"
maxArrayLength
=
"2147483647"
maxBytesPerRead
=
"2147483647"
maxNameTableCharCount
=
"2147483647"
/>
<
security
mode
=
"None"
>
<
transport
clientCredentialType
=
"None"
proxyCredentialType
=
"None"
realm
=
""
/>
<
message
clientCredentialType
=
"UserName"
algorithmSuite
=
"Default"
/>
</
security
>
</
binding
>
</
basicHttpBinding
>
</
bindings
>
<
client
>
<
endpoint
address
=
"http://XXXXXXXXX/BusinessLayer/BLLService.svc"
binding
=
"basicHttpBinding"
bindingConfiguration
=
"BasicHttpBinding_IBLLService"
contract
=
"Business.IBLLService"
name
=
"BasicHttpBinding_IBLLService"
/>
<
endpoint
address
=
"http://XXXXXXXXX/Logger/Logger.svc"
binding
=
"basicHttpBinding"
bindingConfiguration
=
"BasicHttpBinding_ILogger"
contract
=
"Logger.ILogger"
name
=
"BasicHttpBinding_ILogger"
/>
</
client
>
<
services
>
<
service
name
=
"Telerik.Reporting.Service.ReportService"
behaviorConfiguration
=
"ReportServiceBehavior"
>
<
endpoint
address
=
""
binding
=
"basicHttpBinding"
contract
=
"Telerik.Reporting.Service.IReportService"
>
<
identity
>
<
dns
value
=
"localhost"
/>
</
identity
>
</
endpoint
>
<
endpoint
address
=
"resources"
binding
=
"webHttpBinding"
behaviorConfiguration
=
"WebBehavior"
contract
=
"Telerik.Reporting.Service.IResourceService"
/>
<
endpoint
address
=
"mex"
binding
=
"mexHttpBinding"
contract
=
"IMetadataExchange"
/>
</
service
>
</
services
>
<
behaviors
>
<
serviceBehaviors
>
<
behavior
name
=
""
>
<
serviceMetadata
httpGetEnabled
=
"true"
/>
<
serviceDebug
includeExceptionDetailInFaults
=
"true"
/>
</
behavior
>
<
behavior
name
=
"ReportServiceBehavior"
>
<
serviceMetadata
httpGetEnabled
=
"true"
/>
<
serviceDebug
includeExceptionDetailInFaults
=
"true"
/>
</
behavior
>
</
serviceBehaviors
>
<
endpointBehaviors
>
<
behavior
name
=
"WebBehavior"
>
<
webHttp
/>
</
behavior
>
</
endpointBehaviors
>
</
behaviors
>
<
serviceHostingEnvironment
aspNetCompatibilityEnabled
=
"true"
multipleSiteBindingsEnabled
=
"true"
/>
</
system.serviceModel
>
<
system.webServer
>
<
validation
validateIntegratedModeConfiguration
=
"false"
/>
<
directoryBrowse
enabled
=
"true"
/>
</
system.webServer
>
</
configuration
>