Questions on Reporting Forum

1 answer

96 views

I do not have any page breaks on any of my sections or detail and it seems that when I convert to docx programmatically the docx has section breaks within it. Why is this happening and how can it be prevented. I have included the conversion code that I am using.

Telerik.Reporting.Processing.ReportProcessor TelContractrp = new Telerik.Reporting.Processing.ReportProcessor();

System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();

Telerik.Reporting.InstanceReportSource TelContractirs = new Telerik.Reporting.InstanceReportSource();

TelContractirs.ReportDocument = currRpt;

Telerik.Reporting.Processing.RenderingResult result = TelContractrp.RenderReport("DOCX", TelContractirs,deviceInfo);

string dContract = DateTime.Now.ToString().Replace("/", "");

dContract = dContract.Substring(0, 12);

dContract = dContract.Replace(":", "");

string fileName2 = result.DocumentName + "_" + dContract + "." + result.Extension;

string filePath2 = System.IO.Path.Combine(saveLocation, fileName2);

FileStream fs = new FileStream(filePath2, FileMode.Create);

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Close();

System.Diagnostics.Process p = new System.Diagnostics.Process();

p.StartInfo.UseShellExecute = true;

p.StartInfo.FileName = filePath2;

p.Start();

General Discussions

answered on 19 Jul 2013

1 answer

72 views

Get Report Parameter Value vom List

I have created a Telerik report with a Subreport and parameters, like How To: Create a Master Detail Report.

For the master report I use a Telerik.Reporting.List with a Datasoure and Reportsource parameter like this: new Parameter("TourID", "xxx")

My question is, How can I set the subreport Parameter like
new Parameter ( "TourID", "TourID FROM MasterreportList" )
.

thanks for the help.

General Discussions

answered on 19 Jul 2013

1 answer

325 views

Reporting export pdf & printing error in Window Azure

We are using the Telerik Reporting Q2 2013 to generate reports within our web application.

When i click on print button or export to pdf, the below issue occur:

Arithmetic operation resulted in an overflow.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.OverflowException: Arithmetic operation resulted in an overflow.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OverflowException: Arithmetic operation resulted in an overflow.] Telerik.Reporting.Pdf.Fonts.TrueType.FontReader.GetFontData(Font font, Boolean& isTTC) +223 Telerik.Reporting.Pdf.Fonts.TrueType.TrueTypeDescriptor..ctor(Font gdiFont) +312 Telerik.Reporting.Pdf.PdfFontTable.GetDescriptor(PdfFont font) +92 Telerik.Reporting.Pdf.PdfFontDictionary..ctor(PdfDocument document, PdfFont drawingFont) +109 Telerik.Reporting.Pdf.PdfFontType0Dictionary..ctor(PdfDocument document, PdfFont font) +21 Telerik.Reporting.Pdf.PdfFontTable.GetFont(PdfFont font) +89 Telerik.Reporting.Pdf.PdfPageDictionary.GetFontName(PdfFont font, PdfFontDictionary& fontDictionary) +66 Telerik.Reporting.Pdf.Rendering.PdfRendererGraphicsState.Update(PdfFont font, Brush brush, Int32 renderMode) +47 Telerik.Reporting.Pdf.Rendering.PdfRenderer.Update(PdfFont pdfFont, Brush brush, Int32 renderMode) +59 Telerik.Reporting.Pdf.Rendering.PdfRenderer.DrawString(String text, PdfFont font, Brush brush, RectangleF rect, Boolean rightToLeft) +52 Telerik.Reporting.ImageRendering.CanvasPdf.DrawString(String s, Font font, Brush brush, RectangleF rect, StringFormat format) +174 Telerik.Reporting.ImageRendering.DocumentBase.WriteTextChunk(String text, RectangleF bounds, RectangleF chunkBounds, RectangleF chunkBoundingRectangle, IFont font, Color foreground, Single angle, StringFormat format) +254 Telerik.Reporting.Writing.TextLineWriter.WriteContent(DocumentWriter writer, TextLine textLine, ElementPageInfo pageInfo) +342 Telerik.Reporting.Writing.ContentElementWriter`1.Write(T element, ElementPageInfo pageInfo, DocumentWriter writer) +100 Telerik.Reporting.Writing.ElementWriter`1.Telerik.Reporting.Writing.IElementWriter.StartWrite(LayoutElement element, ElementPageInfo pageInfo, DocumentWriter writer) +68 Telerik.Reporting.Writing.WriteStartOperationsDispatcher.Write(IElementWriter writer, LayoutElement element, ElementPageInfo pageInfo, DocumentWriter documentWriter) +19 Telerik.Reporting.Writing.WriteOperationsDispatcher.Visit(TextLine textLine) +46 Telerik.Reporting.Processing.TextLine.Accept(ProcessingElementVisitor visitor) +12 Telerik.Reporting.Processing.ProcessingElementVisitor.Visit(LayoutElement element) +20 Telerik.Reporting.Writing.DocumentWriter.Telerik.Reporting.BaseRendering.IWriter.WriteStartElement(LayoutElement element, ElementPageInfo pageInfo) +29 Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.StartElement(LayoutElement element, ElementPageInfo info) +14 Telerik.Reporting.Paging.PageStartElement.AddToPage(IPageHandler handler) +19 Telerik.Reporting.Paging.PageElementLayer.AddToPage(IPageHandler handler) +69 Telerik.Reporting.Paging.PageElementManager.AddToPage(IPageHandler handler) +34 Telerik.Reporting.Paging.PageCompositionBase.AddElementsToPage() +31 Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages() +38 Telerik.Reporting.Paging.PageCompositionBase.OutputPage() +551 Telerik.Reporting.Paging.PageCompositionBase.CreatePages() +727 Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report) +42 Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +311 Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +864 Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +49 Telerik.ReportViewer.WebForms.ReportExportOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext) +229 Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +206 Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager) +49 Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +182 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

Anyi help would be appreciated.

General Discussions

answered on 19 Jul 2013

1 answer

159 views

How to programatically get row from table

Hello

I have a number of rows in a group footer in a table which I need to show/hide based on the value of a textbox in the particular row. I understand that I need to change the height of the row but how can I identify the row of the textbox?

I would have thought textbox.parent would give me the cell of the textbox, and then cell.parent would give me the row and so on rather than textbox.parent giving me the report.

An excellent feature for the future would be the ability for the conditional formatting, when applied to an entire row, to hide that row rather than leave the white space.

Thanks

Cheryl

General Discussions

answered on 19 Jul 2013

2 answers

364 views

Get day of date

Hi!!
In the reportHeader how can i get day of a datefield. For example, today is 16/07/2013 and i want to return only 16 ?
Can somebody help me??

Thanks!!!!

General Discussions

answered on 19 Jul 2013

1 answer

213 views

Dynamic Report Book

I feel like this is my last hope, here is the scenario:

We are using telerik ORM for data access, and a Silverlight report viewer.

I need the ability to print multiple records based on a string filter, and also need to reset page and numbering. Each report contains a sub report that may or may not run on to multiple pages. So each record can be a different length 1 of 3, 2 of 3, 3 of 3, 1 of 1, 1 of 2, 2 of 2.. etc. From what I have gathered, that functionality is only available through a Report Book. However, I also read that the report book cannot be created dynamically based on the aforementioned filter.

Is there a better way to go about this?

General Discussions

answered on 18 Jul 2013

10 answers

529 views

Error creating Telerik.ReportViewer in the visual designer of Visual Studio

We have a report that needs to be modified. It was developed by a person who is no longer with the company.
When we bring up the page with the report on it we get the following error in the visual designer in Visual Studio:

Error Creating Control - ReportViewer1Failed to create designer 'Telerik.ReportViewer.WebForms.ReportViewer,
Telerik.ReportViewer.WebForms, Version=4.1.10.714, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'

This is the definition in the .ASCX file:

<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ctrlBuyerInvoice.ascx.vb" Inherits="ctrlBuyerInvoice" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<%@ Register assembly="Telerik.ReportViewer.WebForms" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

<telerik:ReportViewer ID="ReportViewer1" runat="server" Height="600px" Skin="Default" Width="775px"></telerik:ReportViewer>

What do we need to install to be able to edit this report?

Thanks

General Discussions

answered on 18 Jul 2013

1 answer

81 views

Repeated Row In Preview / Empty in Execution

Hello there,

I have a report with one table a an object data source.
The object source is simple consuming an OData service (something like select ALL from List).
During Preview mode I can see the same item returned by the OData service twice and during execution the table is empty.
The OData Service is workig fine because is tested with LinqPad, plus I can see the same data twice during preview mode, so is nothing to do with the OData service.
The service returns two items in total.

The code to load and execute the report is simple:
var uriReportSource = new Telerik.Reporting.UriReportSource ();
uriReportSource.Uri = "Reports/" + "deleteME.trdx";
reportViewer1.ReportSource = uriReportSource;
reportViewer1.DataBind();

Thanks,

Report Designer (standalone)

answered on 18 Jul 2013

1 answer

285 views

I have a problem to count Rows

Hello guys,

Im using Telerik_Reporting_Q2_2013 - and i have a problem to count the rows.
http://s7.directupload.net/images/130715/qbesd3up.png

At the top you can see how it is right now, at the bottom how i wish it to be.
=RunningValue("table1",CountDistinct(Fields.StartDate)) - seems to count wrong.

http://s1.directupload.net/images/130715/qw6y826q.png

Please help me :)

Best regards,

General Discussions

answered on 18 Jul 2013

11 answers

793 views

Errors after upgrading to Q1 2013

I have just upgraded to Q1 2013 of Reporting and I have lots of errors in the .Designer.cs files such as:

formattingRule1.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {new Telerik.Reporting.Data.Filter("RowNumber()%2", Telerik.Reporting.Data.FilterOperator.Equal, "=1")});

The best overloaded method match for 'Telerik.Reporting.FilterCollection.AddRange (System.Collections.Generic.IEnumerable<Telerik.Reporting.Filter>)' has some invalid arguments
-------
Argument 1: cannot convert from 'Filter[]' to 'System.Collections.Generic.IEnumerable<Telerik.Reporting.Filter>'
-------
The type or namespace name 'Filter' does not exist in the namespace 'Telerik.Reporting.Data' (are you missing an assembly reference?)

Am I missing a dll reference?

Dan

General Discussions

answered on 17 Jul 2013