Questions on Reporting Forum

2 answers

321 views

A work around for drill-down report charts

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')";             
        
                    }

General Discussions

answered on 03 Dec 2013

3 answers

674 views

Print button in Firefox starts PDF download

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?

General Discussions

answered on 03 Dec 2013

1 answer

69 views

Subreports

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.....................

General Discussions

answered on 29 Nov 2013

5 answers

360 views

Is it possible to use Javascript?

Hi Guys

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

Senthil.

General Discussions

answered on 29 Nov 2013

4 answers

879 views

Percentage of GrandTotal in Crosstab

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?

General Discussions

answered on 28 Nov 2013

2 answers

134 views

[Solved] Report Header Binding at Run time

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.

General Discussions

answered on 28 Nov 2013

1 answer

114 views

Parameters not getting sent from mvc -> report instance

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

General Discussions

answered on 27 Nov 2013

2 answers

167 views

[Solved] Report not show on IE 11 (0 height) while it's fine on Chrome

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>

General Discussions

answered on 27 Nov 2013

8 answers

576 views

Graphs Tutorial

Hello,

Can someone please help me out with displaying a series of graphs on a webpage? Essentially, what I want to do is have a webpage that clients can log into to view visual statistics of a web survey. But I can't find any information about how to do this using reporting -specifically, how to get the graphs working in a web page. Is there any tutorials on this?

Tris

General Discussions

answered on 27 Nov 2013

7 answers

714 views

Backgroundimage

In some reports we use the background image.
Sinds the update from Q2 2012 to Q3 2013 SP1 we needed to change the way to set a backgound image.

From
report.Style.BackgroundImage.ImageData = imageData
to
report.PageSettings.BackgroundImage.ImageData = imageData

Sinds this change the backgroundimage is not fully visible anymore. The data from a detail section / subreport is now a overlayer above the backgroundimage.

How can i prevent this?

General Discussions

answered on 27 Nov 2013