Telerik Forums
Reporting Forum
2 answers
116 views

Trying to integrated HTML 5 viewer and REST service into my existing application, but have hit a wall I can't for the life of me work out

 Report (very simple file, just plain text) is being executed as output in the Debug window

DocumentFormat.OpenXml.Packaging.WordprocessingDocument
DocumentFormat.OpenXml.Packaging.PresentationDocument
DocumentFormat.OpenXml.Packaging.SpreadsheetDocument
 
*** RenderReport #0 STARTED ***
*** RenderReport #0 DONE in 00:00:00.2709344 ***

 All calls to the service are executing successfully as shown in the Fiddler log

POST http://localhost:36584/api/reports/clients
200 OK (application/json)
 
POST http://localhost:36584/api/reports/clients/112900-47f1/parameters
200 OK (application/json)
 
POST http://localhost:36584/api/reports/clients/112900-47f1/instances
201 Created (application/json)
 
POST http://localhost:36584/api/reports/clients/112900-47f1/instances/102544-4330/documents
202 Accepted (application/json)
 
GET http://localhost:36584/api/reports/clients/112900-47f1/instances/102544-4330/documents/112901-c304112901-f7a7/info
202 Accepted (application/json)
 
GET http://localhost:36584/api/reports/clients/112900-47f1/instances/102544-4330/documents/112901-c304112901-f7a7/info
202 Accepted (application/json)
 
GET http://localhost:36584/api/reports/clients/112900-47f1/instances/102544-4330/documents/112901-c304112901-f7a7/info
200 OK (application/json)
 
GET http://localhost:36584/api/reports/clients/112900-47f1/instances/102544-4330/documents/112901-c304112901-f7a7/pages/1
200 OK (application/json)

Output from the main call seems OK 

pageContent=<div><div class="sheet page1" style="padding-left:0px;padding-right:0px;padding-top:0px;padding-bottom:0px;width:605px;height:340px;"><div class="layer"><div title="" class="Report2 s0-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:0px;top:76px;width:605px;height:189px;"></div><div title="" class="Group s0-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:0px;top:76px;width:605px;height:189px;"></div><div title="" class="detailSection1 s1-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:0px;top:76px;width:605px;height:189px;"></div><div title="" class="textBox1 s2-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:249px;top:151px;width:108px;height:38px;"><div style="position:absolute;top:0px;white-space:pre;left:3px;">THIS IS ONLY A </div><div style="position:absolute;top:15px;white-space:pre;left:3px;">TEST !!!!!!!!!!!</div></div><div title="" class="pageHeaderSection1 s3-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:0px;top:0px;width:605px;height:76px;"></div><div title="" class="pageFooterSection1 s4-112901-c304112901-f7a7" style="position:absolute;overflow:hidden;left:0px;top:265px;width:605px;height:75px;"></div><div class="trial">Telerik Reporting v9.1 trial version. Copyright Telerik AD © 2006-2015.<br />To remove this message, please obtain a commercial version from <a href="http://www.telerik.com" target="_blank">www.telerik.com</a></div></div></div></div>

Yet my UI still remains at the default / placeholder text of Loading ...

app.controller("reportViewController", function () {
    $("#reportViewer1")
    .telerik_ReportViewer({
        serviceUrl: '/api/reports/',
        templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate-9.1.15.731.html',
        reportSource: {
            report: 'Report1.trdx',
            parameters: {
                CultureID: "en"
            }
        },
        scaleMode: telerikReportViewer.ScaleModes.FIT_PAGE,
        scale: 1.0
    });
});

<style>
    #reportViewer1 {
        position: absolute;
        left: 5px;
        right: 5px;
        top: 5px;
        bottom: 5px;
        font-family: 'segoe ui', 'ms sans serif';
        overflow: hidden;
    }
</style>
 
<div id="parent">
    <div id="reportViewer1" class="k-widget">
        LOADING ...
    </div>
</div>

Thanks in advance!

Stef
Telerik team
 answered on 02 Oct 2015
3 answers
327 views

Hey Guys ,

 

I have used the examples below to create a pie chart and set the data alignment to outside column assuming this would fix overlapping data labels. how ever this did not seem to change anything and my data labels are still overlapping am i missing something is there a setting i forgot to set or change??

http://www.telerik.com/help/reporting/graphhowtocreatepiechart.html

http://www.telerik.com/help/reporting/piecharts.html

Stef
Telerik team
 answered on 02 Oct 2015
3 answers
349 views
Hi,

Is it possible to convert a Crystal Report report to a Telerik Report using the Telerik Report Designer?

If so, how?
If not, can I put it on the feature request list? :)

I have tried to convert several Crystal Report files by adding then onto a page, but this way I cant seem to convert it to a TRDX file..
And since we need to check them all by hand using the Report Designer it would be a very neat feature in the Report Designer.

Insad
Stef
Telerik team
 answered on 02 Oct 2015
3 answers
78 views

Hey folks,

 Was just wondering if it would be possible to get an status update on this reporting feature request? http://feedback.telerik.com/Project/162/Feedback/Details/128861-nested-tables-should-not-be-kept-together - its currently showing as being in development and looks like its been that way since last year.

 

Thanks.

Stef
Telerik team
 answered on 02 Oct 2015
3 answers
132 views

Hi

Do we have smart labels feature for telerik reporting graph? lot of cool features in chart are missing in graph or we are not able to find.

do you have a comparison sheet of what features are missing in reporting.graph compared to reporting.chart?

1. smart labels

2. label aligned to vertical position

3. tooltips on mouseover on bars 

4. auto resize graph if we have lot of data?

can you suggest us how to implement these as labels could have long names or lot of chart datapoints we would like to show on mouseover etc.

 

Stef
Telerik team
 answered on 02 Oct 2015
5 answers
518 views
In the CrossTab Table I have two columns for each column group and I want those columns to size according to the largest value in the list.  I tried to use the CanGrow and CanShrink properties but they don't appear to work.  I have set them to True for every column in the table but it still either wraps the text or leaves it too wide.  How can I get the column sizes to size properly?
Stef
Telerik team
 answered on 02 Oct 2015
1 answer
528 views

Hi all. I have a problem and don't know how to fix. I add a reportviewer control to aspx and try to set the ReportSource from code behind. The report is rendering on page, but unfortunately there is no content. When debugging i see that the ReportSource of report viewer is the same, which i bind, but no table shows on screen. I'm creating the Report object programmatically. If load report, created from standalone Report Designer there is no problem. 
 This is the custom object I've tried to bind:
"[DataObject]
public class ReportSource
{
    [DataObjectMethod(DataObjectMethodType.Select)]
    public IList<Source> GetData()
    {
        var result = new List<Source>();
        var data = ActiveTradesCache.GetActiveTradeData();

        foreach (var item in data)
        {
            result.Add(new Source() { Rate = item.OrderRate });
        }


        return result;
        //trgOpendDeals.DataSource = new Object[0];
        //trgOpendDeals.MasterTableView.VirtualItemCount = 0;
        //trgOpendDeals.DataBind();
    }

}

public class Source
{
    public double Rate { get; set; }
}

"
 And the fill source method, which is in Page_Load event:
 "
Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = typeof(ReportSource);
objectDataSource.DataMember = "GetData";
Telerik.Reporting.Report report = new Telerik.Reporting.Report();
report.DataSource = objectDataSource;
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
rvOpenDeals.ReportSource = reportSource;
// Calling the RefreshReport method in case this is a WinForms application.
rvOpenDeals.RefreshReport();


reportSource.ReportDocument = report;

"

 

Best regards,

Lachezar

Stef
Telerik team
 answered on 02 Oct 2015
4 answers
418 views
I am brand new to Telerik and focused on learning both HTMLChart and the ReportViewer for reporting in an ASP.NET web site. Got a simple HTMLChart working first day.  Now I want to learn the reporting side using the report-designer tools. I have come to conclusion that reports using the designer should be built using the design environment within VS 2013 (although I was able to display a simple, no parameters report from a .trdx file by using UriReportSource()). However, I cannot figure out how to get the report designer started in VS 2013.

The link below says to click on or right-mouse "report.cs". However, I don't have a report.cs file in my project. Any thoughts? What am I missing? I have installed both the DevCraft AJAX UI and Reporting using the "Control Panel" from Telerik. All of the tools are there. But no option to start the report designer in the Telerik menu.

- VS 2013
- Latest Telerik build Q2 2014 as of yesterday.
- Windows 8.1

http://www.telerik.com/help/reporting/ui-report-designer.html

TIA
Don
Stef
Telerik team
 answered on 02 Oct 2015
4 answers
331 views

I have a problem with the newest telerik Reporting component. I have successfully designed a report and embedded every thing in an application. The source of the report is a SqlDataSource which has access to an SAP Sybase SQL Anywhere 12 database. Every thing works fine with the following statement:

 

select * from document

 

A problem occures if i add some parameter to the statement:

 

select * from document where id = ?

 

If i add this i don't get any error message nore the report works correctly. I only get a blank page. In the designer and in the viewer. I tried some different parameter passing methods but nothing works. What is the problem here? I also could not find anyhing in the documentation for SAP Sybase SQL Anywhere 12. Is this not supported? (It should because it is simple ADO.Net). I've tried a lot with the parameter system but still wount work. Thank you very much!

 P.S. i add the parameter like this to the report:

SqlDataSource ds = (report.DataSource as SqlDataSource);
ds.Parameters.Add(new SqlDataSourceParameter(​"Id", DbType.Guid, ​... some guid ...));

Stef
Telerik team
 answered on 02 Oct 2015
1 answer
201 views

Hi, 

 

I'm evaluation the Telerik Reporting to buy some licence in my company but the first problem I found, the documentation is basic, so I can't found how to can do pagination with SQL Server data source, the report has around 30,000 rows so when it try to render in the browser crashing.

 

I'm using HTML5 Viewer and WebAPI to render the reports, 

I'm thinking in page from store procedure but I not found information how  to configure the pagination control to return the number of records or to identify the page number

 

Somebody can help me to resolve it?

 

Nasko
Telerik team
 answered on 02 Oct 2015
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?