Questions on Reporting Forum

1 answer

634 views

Hello,

currently evaluating Telerik Reports. I try to use Telerik Reports hosted by the Telerik Reporting REST Services in an existing Web API project bound to the HTML5 viewer.

It works basically, but in my ObjectDataSource that is bound to the report I have to load data async from an existing backend service. The method gets triggered but the result is never awaited. All I get is the following error:

An error has occurred while processing TextBox 'textBox1': The expression contains object 'Start' that is not defined in the current context.

How do I load data asynchronous to bind them to the report? Possible at all?

General Discussions

answered on 17 Apr 2014

1 answer

254 views

Text not showing in PDF preview

I recently disabled PDF font embedding on the reports i generate. Since then, i've had reports from a couple clients that the text doesn't show up in PDFs when viewed with Chrome or IE's native PDF viewers. I've tried Times New Roman, Arial and Georgia, but none of them work for the client. Has anyone run into this before?

Here's what i added to my web.config:

<Telerik.Reporting>
<Extensions>
<Render>
<Extension name="PDF">
<Parameters>
<Parameter name="FontEmbedding" value="None"/>
<Parameter name="DpiX" value="600"/>
<Parameter name="DpiY" value="600"/>
</Parameters>
</Extension>
</Render>
</Extensions>
</Telerik.Reporting>

General Discussions

answered on 16 Apr 2014

5 answers

396 views

Pass parameters from custom UI to reports

Hello,
I started off with the ReportCatalog used in the CSharp.ReportExamples.VS2010 solution from which reports hosted in an asp.net class library are loaded. I went ahead and created a custom parameter UI above my Silverlight reportviewer, but i cannot seem to get the target report (using the Navigate to Report action) to receive the passed parameters from the custom ui. I can navigate to the reports but only the default parameter values set for the reports are used. I have tried using the RenderBegin method but it seems the passed parameters are being ignored. I have read a number of blogs on this, but somehow, things are not working.

How can I wire up the parameters from my Silverlight application to the reports?

Below are snippets of my code:

<my1:ReportViewer Name="rptViewer"

…..

Report="XXX.ReportsLibrary.ReportCatalog, XXX.ReportsLibrary, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"

ReportServiceUri="../Services/ReportService.svc" RenderBegin="rptViewer_RenderBegin"

Loaded="rptViewer_Loaded" />

In the code behind of the page hosting the reportviewer, I have:

void rptViewer_RenderBegin(object sender, RenderBeginEventArgs args)

{

args.ParameterValues.Clear();

args.ParameterValues["dateStart"] = rdpStart.SelectedDate;

args.ParameterValues["dateEnd"] = rdpEnd.SelectedDate;

((ReportViewerModel)(rptViewer.DataContext)).ApplyReportParametersCommand.Execute(null);

}

One thing I noticed is that the sender is ALWAYS the ReportCatalog. I was expecting that after navigating to ReportX the Sender would be ReportX. So is it that I am trying to apply parameters to the wrong report?

Please help!!!

My last option would be to abandon the idea of custom parameters UI.

Thanks

General Discussions

answered on 16 Apr 2014

6 answers

355 views

Passing Parameters

I am working on an ASPX page where the user enters some information. When the user click the save button I want to save the entered data then call Telerik’s report passing to it the record_id of the new saved data. I cannot find any information on how to pass parameter to a report. Could someone help me on this issue?

Thanks

Maher

General Discussions

answered on 16 Apr 2014

5 answers

143 views

Problem integrating Telerik reporting with Openaccess

We're trying to create a new report inside an ASP.NET page using OpenAccess as a datasource and, althought the page works without problems, when we click on 'Preview' tab on Visual Studio, it alwways throws the next exception.

Telerik reporting Ver: 2013 Q1 (Trial)
OpenAccess Ver: 2013 Q1
Database: SQL Compact Edition 4

An error has occurred while processing Report 'InfFactura': An error occurred while invoking data retrieval method. Try restarting Visual Studio. ------------- InnerException ------------- Se produjo una excepción en el destino de la invocación. ------------- InnerException ------------- The metadata for field '_clientefacturas' of class 'Facturacion.BdFacturacion.Cliente' cannot be initialized: Field '_cliente' of class 'Facturacion.BdFacturacion.Clientefactura' is not a reference, collection or array; was used to define field '_clientefacturas' of class 'Facturacion.BdFacturacion.Cliente'. --> Bemasoft/namespace[Facturacion.BdFacturacion]/class[Cliente]/field[_clientefacturas]/collection/inverse="_cliente" ------------- InnerException ------------- Field '_cliente' of class 'Facturacion.BdFacturacion.Clientefactura' is not a reference, collection or array; was used to define field '_clientefacturas' of class 'Facturacion.BdFacturacion.Cliente'. --> Bemasoft/namespace[Facturacion.BdFacturacion]/class[Cliente]/field[_clientefacturas]/collection/inverse="_cliente"

Any idea?

General Discussions

answered on 16 Apr 2014

1 answer

137 views

Crosstab Issue

Dear Concerned,
I'm using a Crosstab inside my report. The crosstab works great when there is samll number of columns (specially < 12)
My Column Group is only one DB field which represents a date field. The report has 2 parameters DateFrom and DateTo to specify the period of the report.
If I choos a period more than 12 months, the problem shows. A complete render issue with the columns are mixed and the report title will be hidden by many many columns and also the viewer will hang and the Export option will hang and if you tried to click on the export option a complete disaster happens when the whole solution stops working!!!!!
I attached 2 screenshots one for the report with less column numbers and one if 12 months are selected

General Discussions

answered on 16 Apr 2014

1 answer

81 views

Telerik.Reporting.Processing.ExtensionInfo is missing

Team,

Previously we are using Q3 2011 SP1 Telerik.Reporting.dll(of versions 5.3.12.119) and now we are planning to upgrade it to latest version i.e. Q1 2014 libraries as part of that we downloaded a trial version and started testing. After replacing the latest dll's, I am not finding the below class:

"Telerik.Reporting.Processing.ExtensionInfo"

Please let us know whether it is completely removed or it is moved to a different namespace with different namespace? If so what is the work around for this?

Note: As of now ExtensionInfo class is getting a namespace in "Telerik.Reporting.Services.Engine" which has different properties what we are using in the above class.

regards,
sharan

General Discussions

answered on 16 Apr 2014

1 answer

119 views

Bind report souce at client side

Hi,

We are using ASP.NET and report viewer in our application, is it possible to bind the report source from client script, we will have a web method which returns the report source as an xml with the parameter values. On the client side we need to bind the report source to the report viewer.

Regards,
Majid

General Discussions

answered on 16 Apr 2014

1 answer

124 views

Issues with ReportBook

Hi there -

I am thoroughly frustrated with the reporting tool. I have been working on a voucher statement project for some time and experiencing that the reporting tools do not simple things you would think it would do. I have made design changes to reports to work around printing issues, however I find myself having other issues. Therefore, I am currently experiencing several issues and I will try to explain them as best I can.

To describe what the project entails, this is a simple reporting solution for printing credit vouchers.
I get a list of payment numbers to read and process a statement page, and credit voucher for each payment.

I am using a report book to add the reports as they are processed, so I can print them as a whole.
The sequencing of the entire report book should be as follows:

1 - Header Report (Displays general text)

2 - Credit Voucher Statement (A list of details that make up the voucher)
3 - Actual Credit Voucher (Single Page coupon)

NOTE: If there are multiple payment numbers, I print reports 2 and 3 in a loop, adding them to the report book as they are processed.

4 - Summary report (Shows all the credit vouchers that were printed and other summary information)

The reports print on a duplex printer, although I try to modify that setting depending on which report is printing.
Each report should start on a fresh sheet of paper (Which it does not currently do well.)

In the code (below), I loop through the payment numbers and pass the correct parameters to the reports.
However, when adding reports 2 and 3 to the report book, the first payment number gets repeated for the total number of payments listed.
When the summary report is printed, it too only prints the summary for the first record.

Even when I view the data and parameters being passed to the report, they are all correct.
I'm at my wits end with this project / product and looking for solutions immediately. There are other issues I have with the product that may come up through this dialog that may need to be worked out.

Below is the code that generates the reports and report book. Please help provide me a solution to printing these reports.

Regards,
Bob

' Generate the reports

Me.Cursor = Cursors.WaitCursor

' Initialize print settings

Dim printerSettings As New System.Drawing.Printing.PrinterSettings

Dim printerController As New System.Drawing.Printing.StandardPrintController

Dim reportSource As New InstanceReportSource

Dim reportProcessor As New ReportProcessor

reportProcessor.PrintController = printerController

' Create the report book to add reports

Dim reportBook As New ReportBook

reportBook.DocumentName = "Credit Vouchers"

' Print the report header

printerSettings.Duplex = Printing.Duplex.Simplex

Dim rptHeader As New CreditVoucherReportLibrary.ReportTitle

reportBook.Reports.Add(rptHeader)

Dim c As Integer = 0

Dim firstCV As String = ""

Dim lastCV As String = ""

Dim cn As New SqlConnection(My.Settings.OMSConnectionString)

Using cn

cn.Open()

' Get the list of voucher numbers to print

Dim cmd As SqlCommand = New SqlCommand("Accounts_Payable.get_Credit_Vouchers_Lot_list", cn)

cmd.CommandType = CommandType.StoredProcedure

IIf(CreditVoucherTextBox.Text = "", Nothing, CreditVoucherTextBox.Text)

cmd.Parameters.AddWithValue("@Year", YearComboBox.SelectedItem)

cmd.Parameters.AddWithValue("@Month", PeriodComboBox.SelectedItem)

cmd.Parameters.AddWithValue("@Payment_Number_Code", IIf(CreditVoucherTextBox.Text = "", Nothing, CreditVoucherTextBox.Text))

Try

Dim r As SqlDataReader = cmd.ExecuteReader

If r.HasRows Then

While r.Read

Dim rptVoucherStatement As New CreditVoucherReportLibrary.CV_Statement

Dim rptVoucher As New CreditVoucherReportLibrary.CreditVoucher

' Print Credit Voucher Statement

rptVoucherStatement.ReportParameters("YearPeriod").Value = YearComboBox.SelectedItem

rptVoucherStatement.ReportParameters("MonthPeriod").Value = PeriodComboBox.SelectedItem

rptVoucherStatement.ReportParameters("PaymentNumber").Value = Trim(r(0))

printerSettings.Duplex = Printing.Duplex.Horizontal

' Add the voucher statement to the report book

Try

reportBook.Reports.Add(rptVoucherStatement)

Catch ex As Exception

End Try

' Print Credit Voucher

c += 1

rptVoucher.ReportParameters("YearPeriod").Value = YearComboBox.SelectedItem

rptVoucher.ReportParameters("MonthPeriod").Value = PeriodComboBox.SelectedItem

rptVoucher.ReportParameters("PaymentNumber").Value = Trim(r(0))

rptVoucher.ReportParameters("LastUpdatedBy").Value = "System"

rptVoucher.ReportParameters("IsReprint").Value = False

If c = 1 Then

firstCV = Trim(r(0))

Else

lastCV = Trim(r(0))

End If

printerSettings.Duplex = Printing.Duplex.Simplex

' Add the voucher to the report book

Try

reportBook.Reports.Add(rptVoucher)

Catch ex As Exception

End Try

End While

End If

Catch ex As Exception

End Try

End Using

' Print the summary page

Dim rptSummary As New CreditVoucherReportLibrary.CV_Summary_Report

Try

Dim range As String = ""

If c = 1 Then

range = firstCV

Else

range = firstCV & " - " & lastCV

End If

rptSummary.ReportParameters("YearPeriod").Value = YearComboBox.SelectedItem

rptSummary.ReportParameters("MonthPeriod").Value = PeriodComboBox.SelectedItem

rptSummary.ReportParameters("PaymentNumber").Value = IIf(CreditVoucherTextBox.Text = "", Nothing, CreditVoucherTextBox.Text)

rptSummary.ReportParameters("RangeOfVouchers").Value = range

rptSummary.ReportParameters("NumberOfVouchers").Value = c

printerSettings.Duplex = Printing.Duplex.Horizontal

' Add the summary to the report book

reportBook.Reports.Add(rptSummary)

Catch ex As Exception

End Try

' Print the report book

If PrintPreviewCheckBox.Checked Then

Dim dlg As New CreditVoucherPrintPreviewForm

dlg.reportBook = reportBook

dlg.ShowDialog()

Else

reportSource.ReportDocument = reportBook

reportProcessor.PrintReport(reportSource, printerSettings)

End If

General Discussions

answered on 16 Apr 2014

6 answers

266 views

Pie chart not displaying some times in ReportViewer

Hi

We are SilverLight ReportViewer and displaying pie charts in the reports. The pie chart is not being displayed sometimes when seen in the reportviewer but when saved to pdf we are able to see all the pie charts in the reports. Please find the attached screenshots for furthur reference and let us know if anything has to be done from our end.

And the behaviour is inconsistent in reportviewer, so its not reproducible always.

Thanks in advance
Ravindra

General Discussions

answered on 16 Apr 2014