Questions on Reporting Forum

0 answers

69 views

Pass full ReportBook to external page with ReportViewer control

Hi,

How can I pass a full ReportBook of reports to external page with ReportViewer control in it?

I've created my individual reports in code...

Dim reportBook As New Telerik.Reporting.ReportBook()
reportBook.Reports.Add(New TelerikWebReports.SubCon1Rep())
reportBook.Reports.Add(New TelerikWebReports.SubCon2Rep())
etc.

then I set

LaunchReportViewer = True

which fires off TelerikReportViewer.aspx in a colorbox
In the page_Load event I want to do something like...

ReportViewer1.Report = reportBook

do I need to pass this as a session object?

Thanks

General Discussions

asked on 24 Nov 2010

0 answers

59 views

consolidating sub-reports in detail section

I have several sub-reports within the detail section of my report. It currently returns each sub-report in order for each row in the report. I was hoping to consolidate the sub-reports rather than go through the entire detail for each row. Is this even possible? If so how do I go about it as I have already tired making separate detail sections for each sub-report and that didn't seem to work out.

Example:
   Current:
    Row1- subreport1
    Row1 - subreport2
    Row1-subreport3
    Row2- subreport1
    Row2 - subreport2
    Row2-subreport3
    Row3- subreport1
    Row3 - subreport2
    Row3-subreport3

Desired:
    Row1- subreport1
    Row2 - subreport1
    Row3-subreport1
    Row1- subreport2
    Row2 - subreport2
    Row3-subreport2
    Row1- subreport3
    Row2 - subreport3
    Row3-subreport3

General Discussions

asked on 24 Nov 2010

1 answer

45 views

Report Calls DataSource/Sprocs as many times as the # of graphs on it

Hello there,

I have 8 graphs in a telerik report and each of these graphs is assigned to the same datasource which calls a sproc. But we did a trace and looks like the report calls this same sproc as many time as the # of graphs on the report. So currently, I have 8 graphs that is assigned to the same datasource, the report calls this sproc/datasource 8 times (each for a graph).

So for each graph, I see the line this.chart1.DataSource = this.Graph (Graph is the name of the datasource), but of course the # changes from each graph from 1 to 8. How do fix this? How do we just call the sproc/datasource 1 time and then feed all the graphs from the data returned from this one call?

Thank you so much for your advice and your help!

-Bryan

General Discussions

answered on 24 Nov 2010

5 answers

187 views

SubReport cannot identify parameter

Hi
I am getting the following error when I produce a report which contains a sub report, and the sub report relies on filtering using a parameter: - The expression contains object 'parExpenseFormId' that is not defined in the current context. It doesnt seem to recognise that I have already added the parameter although I have.
This worked absolutely fine in an older version of Telerik Reporting but I have now had to upgrade to version 4.1.10.71 (Q2 2010) I am getting the error. I cannot use Q3 because it has another bug which prevents me from using it.
Can someone please help me - I am generating my SubReport in the following manner:

1. Main Report

SubReport

oSubRep = new SubReport();

Report oEntriesRep = ExpenseEntriesReportBuilder.GetReport(); // Create the sub report (see extract below)

oSubRep.Width =

new Unit(735, UnitType.Pixel);

oEntriesRep.DataSource = dsData.Tables[1];

oSubRep.ReportSource = oEntriesRep;

oSubRep.Parameters.Add(

"parExpenseFormId","Fields.[expense_form_id]");
oDetails.Items.Add(oSubRep); // Add the subreport to the details section of the report

2. This is how I generate the actual sub Report

ExpenseEntriesReportBuilder. GetReport()

{

Report oRep = new Report();

oRep.PageSettings = GetPageSettings();

oRep.Items.Add(GetHeaderSection());

oRep.Items.Add(GetDetailSection());

oRep.Items.Add(GetFooterSection());

oRep.Filters.Add(

new Filter("=Fields.[expense_form_id]", FilterOperator.Equal, "=Parameters.parExpenseFormId"));

return oRep;

}

Thanks in advance

General Discussions

answered on 24 Nov 2010

2 answers

75 views

Cropped line with CanGrow = true

I have a big text that flows through several pages. Most of the times, the last line in page X is repeated and horizontally cropped in the beginning of page X+1.

I'm using version v2.0.50727.

Thanks a lot!

General Discussions

answered on 23 Nov 2010

4 answers

156 views

Application is hanging

Hi all,
I am new to Telerik reporting, I started a new project and added a class library.
When I tried to add a new telerik report, the application is hanged/strucked and cannot do nothing. Just closing the visual studio.
I also installed new version of Telerik reporting, same thing continues..........

Suggest me a solution.

Thanks & Regards
Praveen kumar

General Discussions

answered on 23 Nov 2010

1 answer

183 views

Silverlight ReportViewer Dialog 'Preparing to Print' Dialog missing

I am using Telerik Reporting Q3 2010 with Silverlight ReportViewer on SL4.
The Report shows more than one page and displays ok so far.

But if i hit the print button, no print dialog comes up and the "Preparing to print" dialog does not show up.
If i display all of the report-pages by using the navigation-arrows and after this hitting the print button, the report dialog shows up.

In the end, the whole thing has to run under ria and https. but for the test, i just use some fake-data, that is generated in the report.
I also managed to create another solution with https calls and the same scenario. there it works, but i dont see the differences.

i ddi a printscreen of the included assemblys.
do i miss some references or initializations?

The Clientside-Call:

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

The Report:

namespace InoTrans.Web

{

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

using InoTrans.Web.Services;

using System.Collections.Generic;

/// <summary>

/// Summary description for Report1.

/// </summary>

public partial class Report1 : Telerik.Reporting.Report

{

public Report1()

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

List<EntLtd> list = new List<EntLtd>();

for (int i = 0; i < 100; i++)

{

EntLtd ent = new EntLtd();

ent.sLtdAdrOrt = "Testort";

list.Add(ent);

}

this.DataSource = list;

}

MacProgressBarStatic.CloseProgressBar(progress, AwoKonstanten.GuiDelay_long);

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

//rep.Report = "InoTrans.Web.Selbstdeklaration, InoTrans.Web";

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

//Angabe wo relativer pfad beginnen soll.

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

MacProgressBarStatic.CloseProgressBar(progress, AwoKonstanten.GuiDelay_long);

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

//rep.Report = "InoTrans.Web.Selbstdeklaration, InoTrans.Web";

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

//Angabe wo relativer pfad beginnen soll.

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

MacProgressBarStatic.CloseProgressBar(progress, AwoKonstanten.GuiDelay_long);

Telerik.ReportViewer.Silverlight.ReportViewer rep = new Telerik.ReportViewer.Silverlight.ReportViewer();

//rep.Report = "InoTrans.Web.Selbstdeklaration, InoTrans.Web";

rep.Report = "InoTrans.Web.Report1, InoTrans.Web";

//Angabe wo relativer pfad beginnen soll.

Uri uribase = Application.Current.Host.Source;

rep.ReportServiceUri = new Uri(uribase, "../Services/ReportService.svc");

(((App)Application.Current).RootPage as MainPage).frmContent.Content = rep;

The Value-Binding in InitializeComponent() looks like this:
this.textBox1.Value = "=Fields.sLtdAdrOrt";

ReportingService:
<%@ ServiceHost Service="Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=4.2.10.1110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" %>

and Webconfig:

<?xml version="1.0" encoding="utf-8"?>

<!--

Weitere Informationen zum Konfigurieren der ASP.NET-Anwendung finden Sie unter

"http://go.microsoft.com/fwlink/?LinkId=169433"

-->

<configuration>

<system.diagnostics>

<sources>

<source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing">

<listeners>

<add type="System.Diagnostics.DefaultTraceListener" name="Default">

<filter type="" />

</add>

<add name="ServiceModelMessageLoggingListener">

<filter type="" />

</add>

</listeners>

</source>

<source name="System.ServiceModel" switchValue="Warning, ActivityTracing"

propagateActivity="true">

<listeners>

<add type="System.Diagnostics.DefaultTraceListener" name="Default">

<filter type="" />

</add>

<add name="ServiceModelTraceListener">

<filter type="" />

</add>

</listeners>

</source>

</sources>

<sharedListeners>

<add initializeData="C:\DotNet\WebPfl-VS2010\InoTrans\InoTrans.Web\Web_messages.svclog"

type="System.Diagnostics.XmlWriterTraceListener, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

name="ServiceModelMessageLoggingListener" traceOutputOptions="Timestamp">

<filter type="" />

</add>

<add initializeData="C:\DotNet\WebPfl-VS2010\InoTrans\InoTrans.Web\Web_tracelog.svclog"

type="System.Diagnostics.XmlWriterTraceListener, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

name="ServiceModelTraceListener" traceOutputOptions="Timestamp">

<filter type="" />

</add>

</sharedListeners>

<trace autoflush="true" />

</system.diagnostics>

<system.webServer>

<modules runAllManagedModulesForAllRequests="true">

<add name="DomainServiceModule" preCondition="managedHandler" type=

"System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

/>

</modules>

<validation validateIntegratedModeConfiguration="false" />

</system.webServer>

<system.web>

<httpModules>

<add name="DomainServiceModule" type=

"System.ServiceModel.DomainServices.Hosting.DomainServiceHttpModule, System.ServiceModel.DomainServices.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

/>

</httpModules>

<compilation debug="true" targetFramework="4.0">

<assemblies>

<add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

</assemblies>

</compilation>

<authentication mode="Forms" >

<forms name=".InoTrans_ASPXAUTH" />

</authentication>

</system.web>

<connectionStrings>

<add name="WInoTransportEntities" connectionString="................" />

<add name="WInoTransportEntities1" connectionString="................" />

<add name="WInoTransportEntities2" connectionString="................" />

</connectionStrings>

<system.serviceModel>

<diagnostics wmiProviderEnabled="true" performanceCounters="ServiceOnly">

<messageLogging logMalformedMessages="true" logMessagesAtServiceLevel="false"

logMessagesAtTransportLevel="true" />

</diagnostics>

<serviceHostingEnvironment aspNetCompatibilityEnabled="true" />

<bindings>

<basicHttpBinding>

<binding name="BasicHttpBindingConfig" closeTimeout="01:00:00"

openTimeout="01:00:00" receiveTimeout="01:00:00" sendTimeout="01:00:00"

maxBufferSize="5000000" maxReceivedMessageSize="5000000">

<readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="5000000"

maxBytesPerRead="4096" maxNameTableCharCount="16384" />

<security mode="Transport" />

</binding>

</basicHttpBinding>

<webHttpBinding>

<binding name="WebHttpBindingConfig" closeTimeout="01:00:00"

openTimeout="01:00:00" receiveTimeout="01:00:00" sendTimeout="01:00:00"

maxBufferSize="5000000" maxReceivedMessageSize="5000000">

<readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="5000000"

maxBytesPerRead="4096" maxNameTableCharCount="16384" />

<security mode="Transport" />

</binding>

</webHttpBinding>

</bindings>

<services>

<service behaviorConfiguration="ReportServiceBehavior" name="Telerik.Reporting.Service.ReportService">

<endpoint address="" binding="basicHttpBinding" bindingConfiguration="BasicHttpBindingConfig"

contract="Telerik.Reporting.Service.IReportService" />

<endpoint address="resources" behaviorConfiguration="WebBehavior"

binding="webHttpBinding" bindingConfiguration="WebHttpBindingConfig"

contract="Telerik.Reporting.Service.IResourceService" />

<endpoint address="mex" binding="mexHttpsBinding" bindingConfiguration=""

contract="IMetadataExchange" />

<host>

<timeouts closeTimeout="01:00:00" openTimeout="01:00:00" />

</host>

</service>

</services>

<behaviors>

<serviceBehaviors>

<behavior name="ReportServiceBehavior">

<serviceMetadata httpGetEnabled="false" />

<serviceDebug includeExceptionDetailInFaults="false" />

</behavior>

</serviceBehaviors>

<endpointBehaviors>

<behavior name="WebBehavior">

<webHttp />

</behavior>

</endpointBehaviors>

</behaviors>

</system.serviceModel>

</configuration>

General Discussions

answered on 23 Nov 2010

9 answers

418 views

Dynamic Legends

Hello everyone,

Does anybody know if there is a way to change the legend dynamically for graphs that created mainly from Report Designer? I created graphs by using Telerik report designer but would like to be able to change the legends based on series that users select...

I know we can do if graphs are created programmatically, but I already used report designer to create these reports and this dynamic legend is the requirement... It would be a pain to go back and redo the whole thing...

Thanks for sharing!

General Discussions

answered on 23 Nov 2010

2 answers

208 views

Conditinally visible RowGroup in table

Hi

I'd like to have the visibility of one of the RowGroups in a table in my report be dependent on a parameter. How can this be achieved? There seems to be no way to hide/show a table's RowGroup based on some conditional formatting.

Thank you and best regards

Christian

General Discussions

answered on 23 Nov 2010

0 answers

147 views

Page, Report Header / Footer

Hi team,

I've confused on attributes KeepTogether, PrintOnFirstPage, PrintOnLastPage of Page, Report Header / Footer. Some of my configuration as attached files and telerik reporting did not work as my expected.
+ Page Header has yellow background and PrintOnFirstPage = True, PrintOnLastPage = True. Add textbox1 to page header and textbox's KeepTogether = True.
+ Report Header has pink background KeepTogether = True. Add textbox2 to report header and textbox's KeepTogether = True.

Expected Result:
1. Page Header has yellow background only appears on first and last pages. Textbox1 appears on every pages.
2. Report Header has pink background appear on every pages. Textbox2 should appear on every pages.
Actual Result:
1. Page Header has yellow background appears on every pages. Textbox1 should appear on every pages
2. Report Header has pink background appear only on first page. Textbox2 should appear on first page.

Could you please send me your explaination and solution to make telerik run follow my expected? Many thanks.

Best Regards,
Minh Tam.

General Discussions

asked on 23 Nov 2010