Telerik Forums
Reporting Forum
1 answer
192 views
Hi There,

As per title: I have created a Gantt using the new "Graph"  (image attached) and need some way of indicating the current date, either using a vertical line or a coloured area. Is this possible with graph?

Thanks
Si.
Ivan Hristov
Telerik team
 answered on 04 Dec 2013
1 answer
119 views
My report returns 1106 records in 00:00:00.01 of a second. This is the constant. I'm using C# and the MVC HTML5 viewer as such

@{
    var typeReportSource = new TypeReportSource() { TypeName = Model.ReportQualifiedAssemblyDetail };
 
    foreach (var parameter in Model.ReportData.Parameters)
    {
        typeReportSource.Parameters.Add(new Parameter(parameter.Name, parameter.Value));
    }
             
    @(Html.TelerikReporting().ReportViewer()
        .Id("ReportViewer")
        .ServiceUrl("/api/reporting/")
        .TemplateUrl("/ReportViewer/templates/CustomReportViewerTemplate.html")
        .ReportSource(typeReportSource)
        .ViewMode(ViewModes.PRINT_PREVIEW)
        .ScaleMode(ScaleModes.FIT_PAGE_WIDTH))
}

If I have no groups the report renders in 1.5 seconds with the following debug outputs (whatever they mean) 

*** ReportProcessor.ProcessReport STARTED ***

*** ProcessReport #0 STARTED ***
*** Report Processing STARTED ***
*** Report Processing DONE in 00:00:00.3665425 ***
*** ProcessReport #0 DONE in 00:00:00.3777970 ***

*** ReportProcessor.ProcessReport DONE in 00:00:00.3996569 ***
*** Get HTML5 Rendering Extension STARTED ***
*** Get HTML5 Rendering Extension DONE in 00:00:00.3654471 ***
*** RenderReport #0 STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report DONE in 00:00:00.3463936 ***
*** Measure Report DONE in 00:00:00.3492620 ***
*** Measure Report DONE in 00:00:00.3523046 ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report DONE in 00:00:00.0082247 ***
*** Arrange Report DONE in 00:00:00.0107413 ***
*** Arrange Report DONE in 00:00:00.0128169 ***

*** RenderReport #0 DONE in 00:00:01.5407080 ***

But, are we're talking a Kim Kardashian sized but here, if I put the three required groups on the report the report now takes 19 seconds before I even see the first page and it generates 12511 events in the debug window, so many in fact that I've included a paste bin URL for you

http://pastebin.com/rBv10mJw

The groups are headers only, i.e. hidden footers, they have a single text box on them and the group expression is a simple =Fields.WhatEverGroupFieldIsRequired

Also I've noticed that with or without groups my constructor is hit 3 times before it fetches data??

Can someone explain just what is happening and why it should take so long? Please, this is an urgent matter (I know I'm only on a trial license but please take pity on me I'm quite happy to sacrifice a goat or give over my first born if that will help??)

Mark
Stef
Telerik team
 answered on 03 Dec 2013
2 answers
306 views
I need to have some drill-down reports in my web site and i got to know about the telerik report limitations regarding that matter recently
before finding that i tried to work around it using active regions but was stone walled after some tries
I have attached a sample demo code of my failed test with this and I would like to hear from any one who have successfully achieved the task. If anyone get any ideas of a work around after reading this post please be kind enough to share it with everyone
Thank you

        private void chart1_NeedDataSource(object sender, System.EventArgs e) 
        {             
            string connectionString = "Data Source=sab-srv-mds001; Database=datahub1; User ID=sa;Password=abc@123"
            string command = "select RangeMax from AmountRange"
            SqlDataAdapter adapter = new SqlDataAdapter(command, connectionString); 
            DataSet dataSet = new DataSet(); 
            adapter.Fill(dataSet); 
            ArrayList itemSet = new ArrayList(); 
            foreach (DataRow row in dataSet.Tables[0].Rows) 
                itemSet.Add(row[0]); 
            ChartSeries series01 = new ChartSeries("series 01", ChartSeriesType.Bar); 
            ChartSeries series02 = new ChartSeries("series 02", ChartSeriesType.Bubble); 
            int j = 0; 
            ArrayList indexSet=new ArrayList(); 
            while (j < dataSet.Tables[0].Rows.Count) 
            { 
                if (itemSet[j] != System.DBNull.Value) 
                { 
                    series01.AddItem(Convert.ToDouble(itemSet[j])); 
                    series02.AddItem((Convert.ToDouble(itemSet[j]))+5); 
                    indexSet.Add(j); 
 
                    //series01.Items[series01.Items.Count - 1].ActiveRegion.Tooltip = "series 01" + (Convert.ToDouble(itemSet[j])).ToString(); 
                    //series02.Items[series02.Items.Count - 1].ActiveRegion.Tooltip = "series 02" + (Convert.ToDouble(itemSet[j])).ToString(); 
                    //series01.Items[series01.Items.Count - 1].ActiveRegion.Tooltip = "onclick=\"alert(test01);\""; 
                    //series02.Items[series02.Items.Count - 1].ActiveRegion.Tooltip = "onclick=\"alert(test02);\""; 
 
                } 
                j++; 
            } 
            this.chart1.Series.Add(series01); 
            this.chart1.Series.Add(series02); 
            this.chart1.Series[0].Items[(int)indexSet[0]].ActiveRegion.Url = @"C:\Demo Projects\Reports\ExportDemo\Default2.aspx"
            this.chart1.Series[0].Items[(int)indexSet[0]].ActiveRegion.Tooltip = "tooltip01"
            this.chart1.Series[0].Items[(int)indexSet[0]].ActiveRegion.Attributes = @"onmouseoveralert('popup01')"
            this.chart1.Series[0].Items[(int)indexSet[1]].ActiveRegion.Url = @"C:\Demo Projects\Reports\ExportDemo\Default.aspx"
            this.chart1.Series[0].Items[(int)indexSet[1]].ActiveRegion.Tooltip = "tooltip02"
            this.chart1.Series[0].Items[(int)indexSet[1]].ActiveRegion.Attributes = @"onmouseoveralert('popup02')";             
        } 

Stef
Telerik team
 answered on 03 Dec 2013
3 answers
657 views
Hello,

I just updated a project to the new Q2 2013 release including the report viewer for ASP.NET. When I click the print button in Firefox (version 22), it starts a download of the PDF instead of displaying the print dialogue (no matter whether acrobat plugin or firefox PDF viewer is configured). In IE and Chrome everything works as expected. I have the same behavior when using the online demos of Telerik.

Is direct printing in Firefox not supported anymore?
Peter
Telerik team
 answered on 03 Dec 2013
1 answer
67 views
Good day all,
Please am using 2013 Q3 reporting to design a terminal report for students and i am facing a very big challenge and wish some one can help me.
I have being able to design the the terminal report which has parameters of ClassNo, AcademicYear, and Term.
But what i wanna do is that i have a sub report that calculates the totalscores for each students in all Subjects and rank them for the particular class.
The problem here is that when i bring the subreport into the terminal report am not able to view only the rank for the particular student but instead all the ranks of the student appear.
How can i pass a parameter to view only the rank of a particular student using the StudID.
Any idea as to how to solve it or a better way of designing terminal reports would be much appreciated please.....................
IvanY
Telerik team
 answered on 29 Nov 2013
5 answers
339 views
Hi Guys

can we use javascript in NavigateToUrlAction  like(Window.Open)?
 or any format to open a new window?


Senthil.
Peter
Telerik team
 answered on 29 Nov 2013
4 answers
848 views
Is there a builtin function of any type in the crosstabs to generate % instead of count or sum? (val / grandtotal or rowcount)?  ie =(Fields.myColumn/rowcount)

I want my report to look like this
        txt3      txt4     txt5
txt1   3%    10%    35%         6,256
txt2   10%   15%    27%         8,456
       2,123  5,999  6,590     14,712


What is the best way to handle this?
Alberto
Top achievements
Rank 1
 answered on 28 Nov 2013
2 answers
126 views
As a relatively new user to Reporting, I am finally getting the reports to do almost everything I have set out to do... with one exception. I am placing a picture box control on the report header; setting the value to a jpg in a folder; and the report renders correctly.

However, when I change the jpg and then run the application, it still renders the original jpg even though it no longer exists. I am assuming that the jpg has become a resource within the program?? I need a report that will allow the user to supply a new image (with the same name) and have that new image become the source for the picture box on the header.

How do I set the binding at runtime for this property so it will render the current image?

Thank you in advance.
Lou
Top achievements
Rank 1
 answered on 28 Nov 2013
1 answer
93 views
I have a TypeReportSource setup which works perfectly, but the parameters added to the report source don't appear in the instantiated report class, i.e. I add 10 here from the model but when I look for them in the NeedDataSource event, the collection is empty.

Newtonsoft is installed from nuget and not in the GAC.

@{
    var typeReportSource = new TypeReportSource() { TypeName = Model.ReportQualifiedAssemblyDetail };
 
    foreach (var parameter in Model.ReportData.Parameters)
    {
        typeReportSource.Parameters.Add(parameter.Name, parameter.Value);
    }
             
    @(Html.TelerikReporting().ReportViewer()
        .Id("ReportViewer")
        .ServiceUrl("/api/reporting/")
        .TemplateUrl("/ReportViewer/templates/CustomReportViewerTemplate.html")
        .ReportSource(typeReportSource)
        .ViewMode(ViewModes.PRINT_PREVIEW)
        .ScaleMode(ScaleModes.FIT_PAGE_WIDTH))
}

Is there something I need to do to get the parameters to appear in the report class, as parameters are rendered useless if I can't actually use them.

Mark
Mark
Top achievements
Rank 1
 answered on 27 Nov 2013
2 answers
151 views
I'm on windows 8.1
IE version 11.0.96600.16438
The report works, I can print it fine, but there is no height to the report, so I can't see it in IE.
 Chrome is fine.  

Very basic setup:
<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

        <telerik:ReportViewer ShowZoomSelect="True"   
            ZoomMode="PageWidth" Width="1000px" Height="500" ID="ReportViewer1" runat="server">
        </telerik:ReportViewer>
    </div>
    </form>
</body>
</html>
IvanY
Telerik team
 answered on 27 Nov 2013
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?