Telerik Forums
Reporting Forum
4 answers
160 views
anyone know the settings to create a candlestick chart?  i have a datatable with the appropriate values and i need to bind them to the chart through code.

ChartSeries s = new ChartSeries();
            s.Type = ChartSeriesType.CandleStick;
            s.DataLabelsColumn = "Open";
            //s.DataXColumn = "Date";
            s.DataYColumn = "Open";
            //s.DataYColumn2 = "High";
            //s.DataYColumn3 = "Low";
            //s.DataYColumn4 = "Close";
            //s.DataXColumn = "Date";
            //s.DataXColumn2 = "Date";
            this.chart1.Series.Add(s);
IvanY
Telerik team
 answered on 04 Jun 2013
1 answer
107 views
I am using ASP.NET MVC 4 (C#) to create a Telerik Reporting Report (v. 7.0.13.426).

I have the report created and everything works wonderfully except for one thing. You see, there is an option to select all orders from a certain date range. I have a From and a To Calendar Picker.  I also have a checkbox for all dates. In my report, I have a textbox for the date ranges with the following code:

    {Parameters.rpDateFr.Value.ToString("MM/dd/yyyy")} - {Parameters.rpDateTo.Value.ToString("MM/dd/yyyy")}

This works great!  I have created a jQuery function for this checkbox that sets all dates to minDate (2012, 1, 1) and maxDate (currentDate).

  Here's the code that is used to push the dates into Telerik Reporting for the to and from dates, but it comes back "Object Reference not set to an instance of an object") for the checkbox. I understand why that is because it is saying if the box is not checked, these are the Parameters. How do I set dates for Telerik Reporting this this checkbox is checked?

    if (!$("#SearchAllDates").is(":checked")) {
    qs.push("@(AdminCompanyInvoiceParameters.DateFr)=" + encodeURI($('#SearchDateFr').val()));
    qs.push("@(AdminCompanyInvoiceParameters.DateTo)=" + encodeURI($('#SearchDateTo').val()));
    }

Any suggestions??
IvanY
Telerik team
 answered on 04 Jun 2013
3 answers
690 views
Dear Telerik

I am trying to create a frame around my report, e.g. around my header, detailsection and footer.
The problem is the frame leaves a space between the bottom detail section and the footer section when a page break happens.
Please see attached screenshot, the blue box shows the missing frame.
The frame is generated using left,right border on detail section. and border on 3 sides on header and footer.
I have tried setting border on the report but this dosnt have any effect.


Bonus question: Whats the bestway to get round coners on a full report frame/border like this?

Thanks in advance
Johannes
Stef
Telerik team
 answered on 04 Jun 2013
5 answers
140 views
Hello,

I am trying to run vertical page borders along the report vertical edges. I can't seem to find a way to make a border appear between the detail footer (actually a group footer) and the pagefooter. There is always a gap.

Any suggestions?

Thanks,
John
Stef
Telerik team
 answered on 04 Jun 2013
6 answers
582 views
Hello everyone,

Has anyone found a reliable method to add a visual identifier such as 'Continued' to a report that is more than one page because of a long sub-report?

For example, a report that contains Machine info. The report has a sub-report that contains Parts information as line items.  The main report information is in Group and the sub-report is located in the Details Section.

Is it possible to have some kind of identifier on the report that would appear when the sub-report has forced the main report into a second, third or so on pages. Maybe a 'Continued' could appear next to the Customer Name field in the main report Group or change a color of something (anything). 

The main point would be to offer some assistance for the person reviewing the reports. If the report contains 200 machines and each has a unknown number of sub pages all placed in a binder it starts to get confusing. 

Open to any suggestions.

Thanks.
KS
Top achievements
Rank 1
 answered on 03 Jun 2013
6 answers
593 views
Looking for a way to do the following:

1 report parameter, DepartmentID we will call it.

I want a filter that says:

If RequestedDepartment = DepartmentID OR
AssignedDepartment = DepartmentID

I found an example in the forums where one of your techs said you could do:

=a = 10 Or b = 10    =true

but I tried apply that to my situation but it didn't work.  Maybe I mistyped something, but surely you guys have the 'OR' option in your filtering ... right?
Stef
Telerik team
 answered on 03 Jun 2013
1 answer
351 views
I'm trying to construct a grouped crosstab with static rows and some dynamic columns.  I tried just building static rows of a crosstab inside the group header section, but it just summed up ALL of the data for each group (not just data for that group).  Like this

Group 1
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 500000 500000 500000 1500000
Stat 2 50 50 50 150

Group 2
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 500000 500000 500000 1500000
Stat 2 50 50 50 150

The second attempt I added a row group to the crosstab, but then I only get the first group header and then the static rows repeated for each group.  Like this

Group 1
Dynamic 1 Dynamic 2 Dynamic n Total
Stat 1 200000 200000 200000 600000
Stat 2 20 20 20 60
Stat 1 300000 300000 300000 900000
Stat 2 30 30 30 90

What am I missing that I would need to get the Group 2 header in the 2nd sample?
Elian
Telerik team
 answered on 03 Jun 2013
1 answer
108 views
Hi,
I am using Telerik.Reporting.dll for ASP. Runtime version v2.0.50727, version 7.0.13.426.
Localhost works but Azure deployment has the issue.

Request Method:GET
Status Code:500 Internal Server Error


Web.config

 <httpHandlers>
      <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
        validate="true" />
 </httpHandlers>

 <handlers>
      <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.0.13.220, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode" />
 </handlers>

Can you help. Thanks.
IvanY
Telerik team
 answered on 03 Jun 2013
1 answer
237 views
I have made a telerik report for Windows Application. The report is a sales Invoice. I have set reportkind of report to "A4". It has one pageheadersection, groupheadersecion,detail section and pagefootersection. The problem is that when i print this report on DotMatrix Printer, if the report has data on half page the Printer doesnot break the printing on report end, it print the half page blank. The printer is using page roll that's y half page blank is wasted. Please give me solution of this.
IvanY
Telerik team
 answered on 03 Jun 2013
1 answer
200 views
Hi Friends,

I have created a Telerik Report using ( Q1 2013 - 7.0.13.426 ) in Visual Studio 2012 with MVC4 Application using .NET 4.5 Framework.

The Report Viewer loads it self, but it didn't render the report, and when ever I click on any button within Report viewer it popup the Alert box, with that command name. But it is not displaying any thing in report.

here is the html mark-up code for Report viewer

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<dynamic>" %>
<%@ Import Namespace="PaceSoftware.Models" %>
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html>
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    { }
     protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
        Telerik.Reporting.Report rpt = new PaceSoftware.Reports.CustomerReport();
        rptCustomerReport.ReportSource = rpt;
    }
</script>
 
<html>
<head id="Head1" runat="server">
    <title>Balance Report</title>
</head>
<body>
    <form id="form1" method="post" runat="server">
        <div align="center" style="height: 1400px">
            <table class="NoBorderTables" style="width: 100%">
                <tr>
                    <td>
 
<telerik:ReportViewer ID="rptCustomerReport" runat="server" Width="100%" Height="1300px"
   ViewMode="PrintPreview"  Report="PaceSoftware.Reports.CustomerReport, PaceSoftware">
</telerik:ReportViewer>
 
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>


I have also tried to use the following Code, But no LUCK :-(

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<dynamic>" %>
 
 
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html>
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
 
    protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
 
         
    }
     
</script>
 
<html>
<head id="Head1" runat="server">
    <title>Balance Report</title>
</head>
<body>
    <form id="form1" runat="server">
        <div align="center" style="height: 1400px">
            <table class="NoBorderTables" style="width: 100%">
                <tr>
                    <td>
 
                        <telerik:ReportViewer ID="rptCustomerReport" runat="server" Width="100%" Height="1300px" ViewMode="PrintPreview">
<typereportsource typename="PaceSoftware.Reports.CustomerReport, PaceSoftware, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
                        </telerik:ReportViewer>
 
 
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>

both the above codes didn't throw any error, that's why it becomes very difficult to know either what is happening....!!!

It just display the white sheet of report nothing in it, and when ever I click on any button of the report it display the alert box, with the command name in it... 

I have also attached the screen shot.

Please help me to solve this issue...

Many Thanks.
USMAN
Top achievements
Rank 1
 answered on 31 May 2013
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?