Telerik Forums
Reporting Forum
2 answers
354 views
Hello, i am trying to setup a simple example of reports on our MVC 4 application but i am having difficulty in referencing my report.

i have setup my view and controller as described in these articles:
http://www.telerik.com/help/reporting/html5-report-viewer-embedding.html
http://www.telerik.com/help/reporting/telerik-reporting-rest-implementing-http-service.html

I do NOT want to use a trdx file to reference my report, i just want to be able to use the Report.cs file as we would have in the past.  None of the documentation talks about using the .cs report files anymore, which is somewhat confusing.

According to this post, we still can use .cs report files.

When i try to view the report, the viewer is displayed but there is just a message saying 'Not Found'.  So what is the correct way to reference a .cs report?

Currently my viewer is setup as:
        $("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: "/api/reports/",
                templateUrl: '../Content/ReportViewer/templates/telerikReportViewerTemplate.html',
                reportSource: { report: 'new Telerik.Reporting.TypeReportSource() { TypeName = "Application.Reports.TestReport, Application" }' },
                scale: 1.0
            });

Application is the main assembly.
Reports is the folder where my reports are stored, in the Application project.  
TestReport is the .cs report file.

what am i missing? please n thanks.

Edit: there is also a javascript error when the report is displayed that says:
Failed to load resource:      http://localhost:53661/api/reports/clients/115240-ff1a/parameters
I assume its related to the fact that it cant find the report but thats about all i can figure out from that.
Peter
Telerik team
 answered on 06 Dec 2013
3 answers
260 views
Hi,

I am using Telerik Reports with my Silverlight 4 application and wanted to know if there is a way to change the layout and format of the parameter controls?  For example, I want to change the width of the controls.

Please help.
Stef
Telerik team
 answered on 06 Dec 2013
1 answer
342 views
Same question but for HTML5 Report viewer.   I know the HTML5 report viewer has a template but not sure about the ASP.net report viewer, but in either case, is it possible to customize the layout and format of the parameter controls in one or both of the previous?
Stef
Telerik team
 answered on 06 Dec 2013
1 answer
56 views
Hello,

Last year, our company bought a license for "Reporting Q3 2012". And now, we need to upgrade to "Reporting Q3 2013", is the same license bought last year still working ? if yes, how ?

Thanks
JP
Top achievements
Rank 1
 answered on 05 Dec 2013
3 answers
597 views

I cannot get any of the following to work for me:

 

 

I have a WPF project that contains several Telerik Report Q3 2013 objects. The reports also have parameters and they preview just fine. During runtime, each report runs a query that fetches data from a SQL Server database and displays the results in the reports.

 

The WPF app has a menubar. At runtime, a user can go to the Reports menu, and choose to preview Report1, Report2, or Report3. There is a WPF window that hosts a report viewer control (called RptViewer). When the code behind a menu option executes, such as the Report3 menu option, the code basically does the following:

 

    private void mnuReports_View_Report3_Click(object sender, RoutedEventArgs e) {

        InstanceReportSource irSrc = new InstanceReportSource();

        RptViewer winRptView = new RptViewer();

        irSrc.ReportDocument = new Report3();

           

        winRptView.rptViewer.ReportSource = irSrc;

        winRptView.Show();

    }

This all works fine and the correct report is previewed every time. My problem is that each report stores a static connection string.

 

I intend for some of my clients to install and use this WPF app within their own network. The reports will need to access the data within their own SQL Server databases. So I need the connection strings to be updated accordingly. We already have the correct connection strings; we just need the string to be assigned to a report whenever it is loaded by the report viewer. I don’t know why I can’t get this to work.

Nasko
Telerik team
 answered on 05 Dec 2013
1 answer
329 views
Hello,
I'm trying to get a handle at runtime to the total page count of a generated report but am unable to find a property containing this data. Being able to get it from a saved PDF file would also work for me.  Any tips help would be appreciated.
Thanks
Nasko
Telerik team
 answered on 05 Dec 2013
2 answers
382 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
159 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
109 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
284 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
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?