Questions on Reporting Forum

1 answer

236 views

Master-detail report with subreport paging problem

Hello,

I have report for Delivery list printing. My master report has dataset with delivery list headers (one record per one delivery list) and then I have subreport for detail (product items, quantities and totals).

I need use subreport method, because there is many records in database and I need to select only rows for selected delivery lists. But there is problem, that if detail report is longer than paper format, then on first page is only header from master report and detail subreport begins on second page. I tried turn off keep together parameter for subreport and for master detail section. But nothing helped. Please help me with this problem.

General Discussions

answered on 13 Jul 2016

3 answers

419 views

html text box font issue

Hi, Team

usiing html text box, the code as below:

<TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Verdana" SIZE="10" COLOR="#000000" LETTERSPACING="0" KERNING="0">html testing</FONT></P></TEXTFORMAT>

then will display the large font. does not support the font size?

Regards

Kid

Report Designer (standalone)

answered on 13 Jul 2016

3 answers

180 views

Exporting reports

Is it possible to export a report to some format which can be handled by WPF RichTextBox?

Could you give me an example for exporting report in to HTML format ( what must the delgate function do?)

General Discussions

answered on 13 Jul 2016

1 answer

2.1K+ views

Format decimal Places based on variable

I have a text box on a report that I would like to be able to format to a specific number of decimal places based on a variable. Say if I pass a the value 3 it will be 3 decimal places or if I pass it a 5 it would be 5 decimals places. Is something like Format("{0:N?}" where the ? would be a variable, of is it only possible through a series if iif statements?

General Discussions

answered on 12 Jul 2016

1 answer

156 views

ObjectDataSource Is Not Recognizing Nest Complex Objects

I'm building an audit report using Telerik Reporting (version R2 2016 SP1). I'm using an ObjectDataSource object that accesses the app's business layer. I used the method call for the Data Member; but the Data Explorer doesn't recognize one of the complex object properties ("ChangeHistory") my coworker wrote.

What must I do to get the Telerik Designer in VS to fully recognize my business object?
Is there some limitation in Telerik's ability to reflect complex objects?
Does the object need to flatten?

System Info: Windows 7, .Net 4.5.1, Visual Studio 2013, Telerik Reporting (v R2 2016 SP1 using MVC implementation), MVC5

public class MfrClientInvoiceHeaderAuditHistoryDto

{

readonly string debitMemoNumber;

readonly int clientCorpHierarchyId;

readonly AuditDeaEntryDto remitDea;

readonly AuditDeaEntryDto returnDea;

readonly IEnumerable<AuditChangeRecordDto> changeRecords;

public MfrClientInvoiceHeaderAuditHistoryDto(string debitMemoNumber, int

clientCorpHierarchyId, AuditDeaEntryDto remitDto, AuditDeaEntryDto returnDto, IEnumerable<AuditChangeRecordDto> changeRecordDto)

{

this.debitMemoNumber = debitMemoNumber;

this.clientCorpHierarchyId = clientCorpHierarchyId;

this.remitDea = remitDto;

this.returnDea = returnDto;

this.changeRecords = changeRecordDto;

}

public string DebitMemoNumber { get { return debitMemoNumber; } }

public int ClientCorpHierarchyId { get { return clientCorpHierarchyId; } }

public AuditDeaEntryDto RemitDea { get { return remitDea; } }

public AuditDeaEntryDto ReturnDea { get { return returnDea; } }

public IEnumerable<AuditChangeRecordDto> ChangeHistory { get { return changeRecords; } }

public string ProgramName { get; set; }

}

General Discussions

answered on 12 Jul 2016

7 answers

1.3K+ views

[Solved] Web Api Caching and resolving issues

Hi

I have a Web Api project with Telerik reporting, and a client Angular site that hosts the reportviewer.

The report files are compiled into the dll, ie. are not trdx files

I have had the following issues.

The initial call works and the report is displayed. However, subsequent calls just redisplay the initial report. I have verified this by changing the report and recompiling, as well as making changes in the database, yet the report does not change.

My ReportsController is

protected override IReportResolver CreateReportResolver()

{

return new ReportTypeResolver();

}

protected override ICache CreateCache()

{

return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();

}

I tried to resolve this by overriding CreateStorage

protected override IStorage CreateStorage()

{

return new MsSqlServerStorage(@"Server=.\BF;database=Reporting;Integrated Security=true");

}

But when I do this I get a timeout exception when the report is being resolved

Error creating report instance (Report = NPS.Reports.Simple, NPS.Reports):
An error has occurred.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

I have the Fiddler trace as well as the SQL Server profiler trace, but cannot attach them so I have just attached screenshots.

The full exception is

stackTrace=   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Telerik.Reporting.Cache.MsSqlServerStorage.AcquireLock(String key)

at Telerik.Reporting.Services.Engine.KeyItemPersistableCollection`2.ResolveItem(K referredInstanceKey, Boolean& newItem)

at Telerik.Reporting.Services.Engine.ReportEngine.CreateReportInstance(String clientID, String report, Dictionary`2 parameterValues)

at Telerik.Reporting.Services.WebApi.ReportsControllerBase.CreateInstance(String clientID, ClientReportSource reportSource)

at lambda_method(Closure , Object , Object[] )

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)

at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)