Questions on Reporting Forum

1 answer

110 views

I am using Visual Studio 2012 .
I created a business Object , created a Telerik Report and have it successfully connected to the business object data source.
The method that gets the data returns a DataTable . I have a column for event Id and another one for duration and If I use a table I am able to see 40 rows with their specific event Id and event duration.

NOW when I use the graph wizard, select the clustered column, select the data source, I put the eventId in Categories and Duration in Values. When I try to preview the report I obtain 40 different empty graphs. Why is that? What am I doing wrong?
I want the information of all the rows to be in ONE graph.

Any help is appreciated!
Thanks!

General Discussions

answered on 22 Jul 2013

1 answer

86 views

Problem with Printing a generated Document

Hey,

i´v a Little Problem with the Printing Function in the ReportViewer. I want to print an generated Document automaticly, but when i´m opening the Form, i can´t Print the Document, becouse it is not generatet in the Moment. The Generation takes about ca. 1 - 2 Seconds.

Now my Question. How can i check automaticly if the Generation of the Document is finish?

Thangs a lot.
Dee

General Discussions

answered on 22 Jul 2013

5 answers

487 views

Install .otf font

Hi

I have installed a new font in c:\windows\fonts Folder
I restarted the pc

I can use the new font in Windows Office Word.

But i can't see the new font in telerik reporting designer, why ?

Thanks for any anyswer.

General Discussions

answered on 22 Jul 2013

2 answers

464 views

Can I setup a checkbox for my boolean parameter?

Hello all,

by default, the boolean parameter shows a radio button.
Any chance I can setup a checkbox for my boolean parameter?

General Discussions

answered on 22 Jul 2013

2 answers

275 views

data is being duplicated - dynamic report

Hi Telerik,
I have an issue in regards to dynamic reports.
I am adding columns dynamically, but cell is being duplicated for all cells in content section, for each row.
This is my code:
private void table1_ItemDataBinding(object sender, EventArgs e)
        {

           // table is being populated from as WS

            processingTable.DataSource = table;

            //we do not clear the Rows collection, since we have a details row group and need to create columns only
            this.table1.ColumnGroups.Clear();
            this.table1.Body.Columns.Clear();
            this.table1.Body.Rows.Clear();
            int i = 0;
            this.table1.ColumnHeadersPrintOnEveryPage = true;

            // Properties are the object properties - they will represent the columns
            foreach (PropertyInfo property in properties)
            {
                Telerik.Reporting.HtmlTextBox textboxGroup = null;
                Telerik.Reporting.HtmlTextBox textBoxTable = null;

                Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();
                this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));

                textboxGroup = new Telerik.Reporting.HtmlTextBox();
                textboxGroup.Style.BorderColor.Default = Color.Black;
                textboxGroup.Style.BorderStyle.Default = BorderType.Solid;
                textboxGroup.Value = property.Name;
                textboxGroup.Size = new SizeU(Unit.Inch(1.1+i), Unit.Inch(0.3));
                tableGroupColumn.ReportItem = textboxGroup;


                textBoxTable = new Telerik.Reporting.HtmlTextBox();
                textBoxTable.Style.BorderColor.Default = Color.Black;
                textBoxTable.Style.BorderStyle.Default = BorderType.Solid;
                textBoxTable.Value = "=Fields." + property.Name;
                textBoxTable.Size = new SizeU(Unit.Inch(1.1), Unit.Inch(0.3));
                this.table1.Body.SetCellContent(0, i++, textBoxTable,1,1);
                this.table1.Items.AddRange(new ReportItemBase[] { textboxGroup, textBoxTable });

                this.table1.ColumnGroups.Add(tableGroupColumn);

            }

        }
I am attaching the screenshot for it. Basically all contain the same value for all columns, it´s taking the first value I set in
this.table1.Body.SetCellContent(0, i++, textBoxTable,1,1);
but all fields are different for each column.
I am attaching an image with some sample data for one row (fields.png).
Please help.

Thanks,

General Discussions

answered on 19 Jul 2013

1 answer

118 views

conversion to docx

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

86 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

360 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

180 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

407 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