Questions on Reporting Forum

2 answers

210 views

I have a drop down parameter that list 2000+ items. Is there a way to limit this and function like your combobox. For example have the user type and auto find using a like statement that brings back the top 50 items.

thanks

General Discussions

answered on 24 Nov 2010

0 answers

92 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

69 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

69 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

210 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

100 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

183 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

217 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

482 views

[Solved] 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

244 views

[Solved] 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