Questions on Reporting Forum

2 answers

450 views

Hello!

I have a report that I need to bind a dataset to. I have created a new dataset in Visual Studio 2012 and added my table adapter to the dataset. I go into my report and add a new data source. I select "Object Data Source" and I see my table adapter in the list. I select it and click next where I am prompted to choose a data member. These options are displayed:

InvoiceDetailsForPrintingGetTableAdapter
Fill(InvoiceDetailsForPrintingGetDataTable)
GetDate():InvoiceDetailsForPrintingGetDataTable
ToString()
ClearBeforeFill
Container
Site

No matter what I choose, when I finish the configuration and go into the data source it throws an error.

Telerik.Reporting.Processing.Data.ObjectDataSourceException: Member GetData() on type InvoiceDetailsForPrintingGetTableAdapter not found.
at Telerik.Reporting.Processing.Data.MemberMatch.ThrowMemberNotFound(Type type, String name, ObjectDataSourceParameterCollection parameters)
at Telerik.Reporting.Processing.Data.MemberMatch.FindMemberMatch(Type type, String name, ObjectDataSourceParameterCollection parameters, Type& returnType)
at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveReturnObjectFromType(Type type, String dataMember, ObjectDataSourceParameterCollection parameters, Object& result)
at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.TryResolveAsMethodInvocation(Object dataSource, String dataMember, ObjectDataSourceParameterCollection parameters, Object& instance)
at Telerik.Reporting.Processing.Data.ObjectDataSourceInstanceResolver.ResolveDataSource(Object dataSource, String dataMember, Boolean evaluateParametersValues)
at Telerik.Reporting.Processing.Data.ObjectDataSourcePropertiesResolver.ResolveDataSourceProperties(ISimpleDataProvider provider, Object dataSource, String dataMember, IEnumerable`1 parameters)
at Telerik.Reporting.Processing.Data.ObjectDataProviderBase`1.ResolveDataSourceProperties()
at Telerik.Reporting.Processing.Data.ObjectSchemaAdapter.<GetFields>d__1.MoveNext()
at Telerik.Reporting.Processing.Data.SimpleSchemaAdapter.AddDataMeasures(SimpleDataModel model)
at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.GetSchemaCore()
at Telerik.Reporting.Processing.Data.DataProvider`1.Telerik.Reporting.Processing.Data.IDataProvider.GetSchema()
at Telerik.Reporting.Data.Design.DataSourceDesignerBase.Telerik.Reporting.Design.Interfaces.IDataSchemaProvider.GetSchema()
at Telerik.Reporting.Data.Design.DataSourceService.GetSchemaFromContext(Object context)
at Telerik.Reporting.Data.Design.DataSourceService.Telerik.Reporting.Design.Interfaces.IDataSourceService.GetCurrentDataItemSchema()
at Telerik.Reporting.Design.DataExplorerControl.<>c__DisplayClass2.<RefreshDataSource>b__0()

But there is a GetData on my data set - I verified it by going into the data set designer and it says "GetData(@cutOff, @invoiceId)" under the GetTableAdapter. I need to be able to see the fields in the dataset in the report designer so that I can use them in the report. Any help would be appreciated!

Thanks!

General Discussions

answered on 15 Jul 2016

2 answers

111 views

Exporting web page to PDF

Hello Everyone,

We want to export any web page into a PDF. We referred to the following blog.
http://www.telerik.com/blogs/using-an-external-library-for-the-export-to-pdf-functionality-in-telerik-s-asp.net-editor
Mentioned solution works but doesn't do the complete job. It has 2 issues.
1. It doesn't export images and
2. It doesn't retain the layout of the web page.

Can Telerik support team help us to provide a complete solution for this?

There are other 3rd party components which we have already tried and they do this conversion well,
but we want to know if this can be achieved using Telerik component and how.

Appreciate your help in this.

General Discussions

answered on 14 Jul 2016

1 answer

284 views

showing group aggregates only

hello, i am frequently wondering what is the best practice to list group aggregates only.

1. grouping and aggregating in report, hiding the empty details section

2. grouping and aggregating in data source with LINQ and just list them in the report

a current practical example is listing the count of employees per department, floor and building.

whatever solution i use, next time i have the same problem, i think the would be better...

General Discussions

answered on 14 Jul 2016

3 answers

138 views

Show slider in telerik report

hi telerik team,

I have to present slider values in telerik report.

Is there any way for me to show slider in report

Thanks,

Premraj S.

Report Designer (standalone)

answered on 14 Jul 2016

1 answer

216 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

389 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

146 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.0K+ 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

137 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.2K+ views

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)