Telerik Forums
Reporting Forum
1 answer
119 views
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.


 
IvanDT
Telerik team
 answered on 06 Sep 2011
1 answer
207 views
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?


Peter
Telerik team
 answered on 06 Sep 2011
3 answers
477 views
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
Chavdar
Telerik team
 answered on 06 Sep 2011
5 answers
637 views
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?
Chavdar
Telerik team
 answered on 06 Sep 2011
5 answers
151 views
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">
 
<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;
            }
            }
        }
         
    }
}

Steele
Top achievements
Rank 1
 answered on 06 Sep 2011
1 answer
191 views
Is it possible to create a vertical line chart or even just rotate a standard chart 90 degrees as per the attached image?
IvanDT
Telerik team
 answered on 05 Sep 2011
1 answer
102 views
Why are the textboxes scrunched up when the HTML preview mode is shown?  How can I actually design my report and know exactly what it will look like when it displays?  My textboxes are perfectly formatted and aligned.  these textboxes do NOT contain data, they are simply act as labels, so it doesn't make sense to me why the HTMl preview mode makes the width smaller than design time??

Thanks.


Peter
Telerik team
 answered on 05 Sep 2011
3 answers
84 views
I have Telerik Reporting Q3 2010, I have VS 2008 and VS 2010 installed.  I'm developing a SL4 application in VS 2010 but I don't see any Telerik ReportViewer control or Telerik in the menu bar.  In VS 2008 I do see Telerik ReportViewer control and Telerik is in the Menu bar ... am I missing something?

My assumption is that Telerik Reporting works with SL4 applications also?

Any info is appreciated,

Thanks, Rob.
Peter
Telerik team
 answered on 05 Sep 2011
5 answers
205 views
HI,

I have this error trying to put a report in production, any idea? I'm using Telerik Reporting 5.0. I'm trying to show a picture, I don't know if my problem is related to configuration or the picture itself.
Thank you.
Hrisi
Telerik team
 answered on 05 Sep 2011
3 answers
1.3K+ views
Hi All,

how to auotmatically resize the column headers of the report table at runtime? And also each report should not extend to next page. Do we have something like creating a lock in sql server reporting for not letting the report move another page?

thanks in advance....
Peter
Telerik team
 answered on 05 Sep 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?