Telerik Forums
Reporting Forum
2 answers
372 views
Hello.  I'm using the Q2 2012 version of Telerik Reports and a, generating a report that will display details of transactions on insurance policies grouped by coverage codes.

Ideally, I'd like to use a single report, avoiding a subreport.

Would my version of Telerik reporting allow me to use a dataset with the proper Dataset.Relations added in my BL and put the transactions in the detail section, and their Coverage code one level up in the Group header, I'm thinking something similar to the way RadGrid can generate nested grids with relationships between the MasterTable and DetailTable?

If so, could you point me towards some code samples showing how to set the ObjectDataSource.DataSource = myDataset or what to do in the NeedDataSource events to wire this up correctly?

I expect I can do this with the Table object, but frankly, I've been stymied by how to use that one.

Thanks.



Will
Top achievements
Rank 1
 answered on 04 Dec 2013
1 answer
145 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
105 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
277 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
600 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
54 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
313 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
785 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
110 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
83 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
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?