Questions on Reporting Forum

1 answer

117 views

Connecting to an indexer on an Object Data Source

I'm in the process of evaluating the Telerik reporting tool and am hitting a bit of a wall with something that I thought woudl be reasonably easy. We currently use a generic class that holds an object array containing the data that is to be presented in a grid in the UI. We then use an indexer on the class to access the appropriate value by positional index. Since our end users have extensive flexibility in which columns can be included in their grids/reports and in what order, this is the simplest way for us to have a bindable object that does not have explicit property names.

We'd like to reuse this same object for a report, but I cannot for the life of me figure out how to set up an expression for a group/field that can access the indexer on the underlying business object. If I use the normal c# indexer notation of, for example, "=[2]" then I get the error "The expression contains object '2' that is not defined in the current context."

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?

General Discussions

answered on 05 Jul 2011

1 answer

855 views

Cross Tab REPORT

Hi,

I'm looking at your demos... the Product Sales Per Period... and wanting to create something similar.

See attached.

Can the report sample that I've attached (layout only) be done?

Is there any sample code you could provide to create something similar.

Thanks
Mike

General Discussions

answered on 05 Jul 2011

2 answers

110 views

report parameter label localization

hello and thanks in advice

is there any way to localize the label associated to a report parameter?
i'm using version Q1 2011 5.0.11.510

fabio

General Discussions

answered on 05 Jul 2011

1 answer

99 views

Report does not Show

Good Day All

i have always had a report that is working. i might have play with it around a bit. i can access the url

http://myserver:1111/myapp/ReportService.svc

and it working, but my report viewer is showing me a white line not a report.

I have attached the screenshot and the xaml looks like this

<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" />

thanks

General Discussions

answered on 05 Jul 2011

3 answers

181 views

The Reporting Problem hit me again

Good Day Guys

Months ago i posted this thread

http://www.telerik.com/community/forums/reporting/telerik-reporting/silverlight-report-dont-show-a-basic-barcode-report.aspx

and the problem was that my barcode does not show. I hosted my application in IIS Service(Not my machine) and i get the Following Error,

The type 'Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=5.0.11.316, Culture=neutral, PublicKeyToken=a9d7983dfcc261be', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found.

if you look at the thread i created you will notice that i am familiar with the Endpoint article.

<?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" />

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

Thanks

General Discussions

answered on 05 Jul 2011

3 answers

1.3K+ views

Line break issue in multi line text boxes

Hello,

I have a multiline text box that I am filling with data from my SQL Server. The contents of this field contain paragraphs of text with line breaks. When I preview the report or run the project and view in the "Report Viewer" the line breaks are not shown. If I look at the HtmlPreview I do see the line breaks as expected. If I display the contents of the text box to the debugger using System.Diagnostics.Debug.Print I can see the linebreaks fine in the output window. If I export the report to PDF, I also see the line breaks.

So it seems that the data is good but I have problems when viewing the the report viewer or preview mode. Any suggestions on what may be going on here?

Thanks,

Chris

General Discussions

answered on 05 Jul 2011

2 answers

150 views

large text bug.

Hi I have a quite simple report with 3 panels each panel has two textboxes: a title texbox with a static small text and a data bound text box that will receive a relatively large text at runtime: almost half a page of text.
Each panel is configured with KeepTogether so that the title is kept on the same page as the text.
All the three panels are in the detail section. they are packed vertically and take almost all the report width.
the report is bound to a list with just one object. So I only have a report with one detail section containing three block of texts.

When rendering in Silverlight viewer, the text overlaps.
When rendering in the pdf the text is truncated.
In both rendering, the computed size of the textbox does not seem enough to hold all the text.

Do you have any documentation, samples with large text? what the rendering engine is supposed to do.
Is there any flag to tell the rendering engine to allow breaking a textbox in the middle instead of having a large blanc space on the previous page?

Any help is welcomed.
Thank you.

General Discussions

answered on 04 Jul 2011

1 answer

639 views

An exception occurred during the operation, making the result invalid. Check InnerException for exception

The type 'Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=5.0.11.316, Culture=neutral, PublicKeyToken=a9d7983dfcc261be', provided as the Service attribute value in the ServiceHost directive, or provided in the configuration element system.serviceModel/serviceHostingEnvironment/serviceActivations could not be found.

Any Idea about this error http://localhost:62719/ReportService.svc
My Web.Config details:

<system.serviceModel>

<serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" />

<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="ReportServiceBehavior">

<serviceMetadata httpGetEnabled="true" />

<serviceDebug includeExceptionDetailInFaults="False" />

</behavior>

<behavior name="">

<serviceMetadata httpGetEnabled="true" />

<serviceDebug includeExceptionDetailInFaults="False" />

</behavior>

</serviceBehaviors>

<endpointBehaviors>

<behavior name="WebBehavior">

<webHttp />

</behavior>

</endpointBehaviors>

</behaviors>

</system.serviceModel>

Looking forward for help!

Thanks,
Ed

General Discussions

answered on 04 Jul 2011

1 answer

133 views

Split a large bar chart into multiple charts

Hello,

I am trying to split a large bar chart into multple bar charts. Here is the scenario:

I have a result set that returns 150 records (for example).
I want to display this data on a bar chart but it is too much for one chart, so I only want to show 15 items per bar chart.
Each page will only display one bar chart.
So, what I would like the result to be is a 10 page report, each page being a bar chart that shows 15 items.

Is this possible to do with just the designer or do I need to write some code? Either way I need to do it could you give me some suggestions on how to get started?

Thanks,

Brian

General Discussions

answered on 04 Jul 2011

3 answers

274 views

Telerik Reporting Chart click event in-code.

Hi,

im starting to use Telerik Reporting Chart, but i cannot find the onclick event on any of chart items. In documentation of Ajax Chart i've found: "Use the RadChart OnClick event to handle server postbacks caused by clicking on areas of the chart.". I would like to get any click event made on different chart bars to redirect to a page with details info and everything has to be done in-code.

Below you see my test code for chart configuration:

Report report = new Report();

DetailSection detail = new DetailSection();

Telerik.Reporting.Chart progchart = new Telerik.Reporting.Chart();

progchart.BitmapResolution = 96F;

progchart.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

progchart.Location =
new Telerik.Reporting.Drawing.PointU
(new Telerik.Reporting.Drawing.Unit(0.3, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))),
new Telerik.Reporting.Drawing.Unit(1.8, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));

progchart.Name = "progchart1";

progchart.PlotArea.EmptySeriesMessage.Appearance.Visible = true;

progchart.PlotArea.EmptySeriesMessage.Visible = true;

progchart.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(9.6, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))), new Telerik.Reporting.Drawing.Unit(6.1, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Cm))));