Questions on Reporting Forum

1 answer

429 views

Report Timeout

Reports version 5.1.11.713
I have a basic table layout report. If I run the SQL directly in SQL Server it takes 1 second to return 15,852 rows. If I attempt to run this via a report it times out. I have increased the timeout to 120 and it still times out. Why is this happening when the SQL itself only takes a second? I understand it will take some additional time to pull all that data back and construct objects in memory but it shouldn't take that long. I just downloaded a trial version of DataDynamics Reports and the same exact report with that engine loads all 378 pages in under 15 seconds.

General Discussions

answered on 07 Sep 2011

1 answer

47 views

Silverlight Backgroud

Is it possible to change the background of the silverlight viewer (space behind the report) to a different color?

General Discussions

answered on 07 Sep 2011

0 answers

146 views

Convert images/pdfs to report.

Hi guys,

I have a business request of being able to generate reports from images or pdfs and add watermarking or custom texts to the reports that will finally be printable/exportable in pdf on the web.

I was wondering if it's possible to do so and would like some input from the forums on whether the reporting tool is a good solution for such a request. ( This is because I would like to use of the wonderful reporting viewer control for preview/printing/exporting to pdf)

A typical scenario would have probably a list of image files or mutliple pdf files ( with many pages inside) where I would like to add to the report which would definitely have a header/footer custom text and needs to have a watermark imprint on the report itself. The size of the image is not fixed and will need to be resized to fill up 1 typical report page

If its possible to do so, can someone direct me with some form of pseudo code or code samples especially in the part where I iterate through the pages in the pdf to add to the report.

If its not possible to do so, can someone direct me to any good telerik control from the asp.net ajax suite that might be able to perform what I just listed above. - or any other 3rd party tool.

I have been using Telerik reporting for all our business requirements and would prefer to continue doing so and would like some help with how I can include all the pages in the pdfs or a List<image> into the report as well as defining the size of the image to fit nicely in a portrait A4 size when being printed.

Regards

Jonathan

General Discussions

asked on 07 Sep 2011

2 answers

247 views

System out of memory exception

Hello, I am using telerik reporting version q3 2010 with VS 2010, I am getting an out of memory error with Telerik report with 3000 records, The stored procedure from backend takes approximately 2-3 sec to retrieve the data. Please help. It says type initializer for system.web.UI.htmltextwriter threw an exception, I have one group and some calculated values at reporting footer. On detail section I have the data fields, no heavy calculation

I have about 17 reportparameters, and I get this error when trying to preview from the designer as well as from codebehind below. I f I limit the output records to 10 it renders perfectly, we were using crystal reports for the same report w/o any issues but decided to migrate to telerik reporting.

Please help.

Dim report1 As New ReportLibrary.test1

report1.ReportParameters("parameter1").Value = "NE"
.....................................
.........................................
report1.ReportParameters("parameter17").Value = "test2"

Me.ReportViewer1.Report = report1

General Discussions

answered on 06 Sep 2011

1 answer

79 views

Suppress Detail Record in Master-Detail Report

I created a Master-Detail report and I would like to suppress the printing of the detail header when there are no records for the master record. How can I do this?

Thanks.

General Discussions

answered on 06 Sep 2011

1 answer

94 views

Specify Filter for Report Using Code

I want to create a report that shows records for a particular time period. How can I specify the filter criteria using VB.Net code for a report if I want to show records that fall within the following date range: January 1, 2011 to June 30, 2011?

Thanks.

General Discussions

answered on 06 Sep 2011

1 answer

191 views

List data source parameter

It is userObjectDataSource (IList<User> GetUsers()) as report DataSource. Also it is a List in details report section and it is an ObjectDataSource (IList<string> GetPrivileges(int userId)) as DataSource for this List. How can I set UserId from userObjectDataSource as value for parameter of ObjectDataSource? I tried ObjectDataSource->Parameters->Value-><Expression>->Fields, but - No Data Source found. It should be one list of privileges for each user. Implementation through SubReport incorrect displayed after export in to PDF or TIFF. Can you help me?

General Discussions

answered on 06 Sep 2011

3 answers

422 views

Chart data labels and legend

I'm trying to create test report with chart and here what I have:

this.chart3.BitmapResolution = 96F;

this.chart3.ChartTitle.Appearance.Visible = false;

this.chart3.ChartTitle.Visible = false;

this.chart3.DataSource = this.sqlDataSource2;

this.chart3.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart3.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;

this.chart3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(7.800079345703125D, Telerik.Reporting.Drawing.UnitType.Inch));

this.chart3.Name = "chart3";

chartMargins5.Bottom = new Telerik.Reporting.Charting.Styles.Unit(1D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);

chartMargins5.Left = new Telerik.Reporting.Charting.Styles.Unit(1D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);

chartMargins5.Right = new Telerik.Reporting.Charting.Styles.Unit(24D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);

chartMargins5.Top = new Telerik.Reporting.Charting.Styles.Unit(1D, Telerik.Reporting.Charting.Styles.UnitType.Percentage);

this.chart3.PlotArea.Appearance.Dimensions.Margins = chartMargins5;

this.chart3.PlotArea.XAxis.MinValue = 1D;

chartSeries1.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;

chartSeries1.Appearance.ShowLabelConnectors = true;

chartSeries1.DataLabelsColumn = "Department";

chartSeries1.DataYColumn = "TotalJobs";

chartSeries1.Name = "Jobs";

chartSeries1.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;

this.chart3.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

chartSeries1});

this.chart3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.7999601364135742D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(2.8998820781707764D, Telerik.Reporting.Drawing.UnitType.Inch));

Result attached in TelerikReports-chart file.

My questions:
1) How I can fix data labels? Right now some of them overlay other. See "Human Resources" and "Healthcare" at the bottom of img.
2) I want to display numbers in data labels and text in legend. For example "Sales/Marketing" should be replaced to 60, but legend should be the same.

Thanks

General Discussions

answered on 06 Sep 2011

5 answers

570 views

MHTML export in e-mail body

I am exporting a report to MHTML in order to insert it in a email. Although the export is working, I could not find a way to include it in the email body using the MailMessage class of the framework . net. Could anyone help me in this issue?

General Discussions

answered on 06 Sep 2011

5 answers

105 views

Running report prevents callbacks

Hi All,
I am using telerik webform report viewer version 5.1.11.713 and the corresponding Reporting dll's.
I am having issues with enabling a user to close down a report and continue using the ajaxified web application.
I use the radwindow to load an aspx page that contains the web viewer. In the Page_Load event, I assign my report document to it.
Some reports may take a couple of minutes to run, and the user may close the radwindow in order to do another task. It would be expected that the user not receive the report.
The thing is, if the user clicks a button that uses a callback, that callback waits until the Report has completed.
This is unexpected.
Is this the intent of the Report mechanism? Elsewhere, if a callback is triggered while another callback is being processed, the new callback takes precedence.
Can you please advise as to what can be done to alleviate this issue?
Thanks,
Steele.

My ReportHolder page :

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportHolder.aspx.cs" Inherits="Audit.Audit_Reports.ReportHolder" %>

<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=5.1.11.713, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerikrv" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>Report Holder</title>

<style type="text/css">

html, body, form#form1, div#Content

{

margin: 0px;

padding: 0px;

height: 100%;

}

</style>

</head>

<body >

<form id="form1" runat="server">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"

UpdatePanelsRenderMode="Inline">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="ReportViewer1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="ReportViewer1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

</script>

</telerik:RadCodeBlock>

<telerik:RadSplitter

ID="RadSplitter1" runat="server" Height="100%" Width="100%">

<telerik:RadPane ID="RadPane1" Runat="server" Scrolling="None"

onclientresized="ResizeViewer">

<div id="Content">

<telerikrv:ReportViewer ID="ReportViewer1" runat="server" Height="100%"

Width="100%" ShowHistoryButtons="False" ShowParametersButton="False">

</telerikrv:ReportViewer>

</div>

</telerik:RadPane>

</telerik:RadSplitter>

</form>

</body>

</html>

And my code behind :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace Audit.Audit_Reports

{

public partial class ReportHolder : System.Web.UI.Page

{

private Telerik.Reporting.IReportDocument Get_Report(string RepName)

{

try

{

Type t = Type.GetType("Audit.Audit_Reports." + RepName);

Telerik.Reporting.IReportDocument ret = (Telerik.Reporting.IReportDocument)(Activator.CreateInstance(t));

foreach (string QRKey in Request.QueryString.Keys)

{

if (QRKey != "Report")

{

// Is a parameter to set

Telerik.Reporting.Report rep = (Telerik.Reporting.Report)ret;

if (rep.ReportParameters.Contains(QRKey))

{

rep.ReportParameters[QRKey].Value = Request.QueryString[QRKey];

}

return ret;

}

catch (Exception oE)

{

return null;

}

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Telerik.Reporting.IReportDocument rd = Get_Report(Request.QueryString["Report"]);

if (rd != null)

{

ReportViewer1.Report = rd;

this.Title = rd.DocumentName;

ReportViewer1.ShowParametersButton = true;

}

General Discussions

answered on 06 Sep 2011