Telerik Forums
Reporting Forum
0 answers
104 views

I'm trying to achieve something in a report, and I'm getting nowhere and beginning to wonder whether I'm doing this all wrong.

As a data source for my report, I have a CLR object; It has the following structure (specifically the Bundle object):

 public class Bundle
    {
        public uint BatchId { get; set; }
        public uint BundleId { get; set; }
        public List<BundleItem> Items { get; set; } = new List<BundleItem>();
    }

    public class BundleItem
    {
        public uint CheckNo { get; set; }
        public string ReceivedFrom { get; set; }
        public string Bank { get; set; }
        public string Memo { get; set; }
        public decimal Amount { get; set; }
        public ushort AccountNo { get; set; }
        public string AccountDescription { get; set; }
#if NET6_0
        public DateOnly ContribDate {get;set;}
#else
        public string ContribDate { get; set; }
#endif
        public ushort PaymentType { get; set; }
        public DateTime EntryDateTime { get; set; }
    }

I'm able to instantiate that object, and want to pass it off to a report to render; it's a complicated scenario regarding how that CLR object is instantiated, so I'm not able to use something like a SqlDataSource, so I'm assuming the correct data source type to use is an objectDataSource. That side of things so far is working (as best as I can tell):

I need to build two different reports from this data: one that aggregates the BundleItems (contained in the Items property), and one that displays the list of BundleItems and their fields. I can drag-drop [= Fields.BatchId] and [= Fields.BundleId] to the report designer (I'm using VS integrated designer) and that works fine. I'm binding the datasource to the report via:

BundleReport report = new ();
report.DataSource = (object)_detailsList;
ReportViewer1.ReportSource = report;
ReportViewer1.ViewMode = ViewMode.PrintPreview;
ReportViewer1.RefreshReport();

That causes the report to open and display successfully. Success so far! 

The problems I'm having are related to the List<BundleItems>; no matter what I do the ReportViewer is just (I'm guessing) calling .ToString() on the list and getting back the type name. This has left me to wonder if I'm trying to do something that's just not supported; is there a way for me to visualize a List<BundleItem> in a report directly? Does it have to be done via a sub report? I'm feeling lost - and wondering if I'm just trying to achieve something that it's not really designed for (I know the old ReportViewer WinForm control hated working with anything other than DataSets).

Any guidance is greatly appreciated!

0 answers
184 views

Good Day

I have a report with 15 page, and when I scroll down it seems to hit pages where it won't continue loading.

On Chrome: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36, the limits seems to be on a 5 page boundary, page 5, 10, 15, etc...  On Firefox: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:99.0) Gecko/20100101 Firefox/99.0, I get stuck on a 6 page boundary 6, 12, etc...

Oddly, my coworker doesn't run into this often on Chrome: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36.  When he did run into it, it didn't seem to have a defined page boundary.

Has anything one else seen this happen?

We're using: @progress/telerik-angular-report-viewer: 14.21.915

Thanks

Andrew
Top achievements
Rank 1
 asked on 12 Apr 2022
0 answers
191 views

We use the standalone Telerik report designer to create reports. When we preview them in the html5 viewer, everything looks good. I export the report to PDF and everything shows as expected. However, if I were to examine the text properties, the horizontal scaling is set to -100. I was able to see the horizontal scaling using the free version of PDF XChange Viewer. So while the PDF shows correctly in most places, we have run into rendering problems in certain areas of our software. Other PDF files generated by other software seem to use 100% scaling and they all work as expected. Where is this -100 horizontal scaling setting coming from? Is this part of the report and if so, can it be changed? Or is this the way Telerik generates the PDF?

Appreciate any help on this!

Igor
Top achievements
Rank 1
 asked on 11 Apr 2022
0 answers
199 views

Hello,

 

I can see that for the react sample that you have in your website you are consuming the report from this url https://demos.telerik.com/reporting/api/reportdesigner/reports/Barcodes%20report.trdx/ My question is how do you generate that json in order to display the report? Thanks

Here is the code:

export default class ReportDesigner extends Component {
    componentDidMount() {
        window.jQuery('#reportDesigner1')
            .telerik_WebReportDesigner({
                toolboxArea: {
                    layout: "list" //Change to "grid" to display the contents of the Components area in a flow grid layout.
                },
                serviceUrl: "https://demos.telerik.com/reporting/api/reportdesigner/",
                report: "Barcodes report.trdx"
            }).data("telerik_WebDesigner");
    }
    render() {
        return <div id="reportDesigner1"></div>
    }

}

 

Daniela
Top achievements
Rank 1
Iron
Iron
Iron
 asked on 08 Apr 2022
1 answer
191 views

I suspect the answer is no and that I will be directed to CSV Rendering Design Considerations & CSV Device Information Settings.

However, it seems not a little unintuitive for this to be a global rather than per report (or even per table) setting.

I am not (currently) set anything about reports programatically, my set up is simple, I have a report template on the report server that I run via the REST API and download the output document as a CSV.

I could, after downloading, then open the file and remove the header row. But I'm hoping that I am incorrect and there is some obscure report template setting somewhere, or perhaps an argument I can pass via the the REST api, that might allow me to decide on a per report basis how table headers are treated in CSV format.

Dimitar
Telerik team
 answered on 07 Apr 2022
0 answers
87 views

Hello,

 

Im trying to run the demos in visual studio. I installed the dependencies and clicked run but I am getting the following error, which is weird bcause I I open the report in telerik report designer I get the report correctly , some help would be realy appreciated.

The name of the demo is :reporting-samples\.NET Core 3.1 MVC

kind regards,

 

 

 

 

Daniela
Top achievements
Rank 1
Iron
Iron
Iron
 asked on 07 Apr 2022
1 answer
506 views

I have 3 report parameters. 

Fields.InvYear,

Fields.InvMonth,

Fields.InvQtr

I have 3 corresponding filters:

= Fields.InvYear = = Parameters.Year.Value

= Fields.InvMonth = = Parameters.Month.Value

= Fields.InvQtr = = Parameters.Quarter.Value

The year parameter is required, however I want the user to be able to pick either Month or Quarter. Even if I allow NULL or blank on the Month or Quarter parameters, Telerik says the parameters are required. The filters are hard coded to be AND, which should not make a difference if one of the parameters is blank. How do I create a "blank" entry?

My SQL fields:

DATENAME(YEAR, Invoice.DateCreated) AS InvYear,
DATENAME(MONTH, Invoice.DateCreated) AS InvMonth,
DATENAME(QUARTER, Invoice.DateCreated) AS InvQtr,
1 answer
662 views

- Visual Studio 2022
- Installed Telerik.Reporting (16.0.22.225) Manage Nuget Packages for Solution, Restarted VS, then installed via the Telerik Control Panel and targeted only VS 2022, did not install sample files, Restarted VS.
- Added new class library - Target Framework: .NET 6.0

When I add a new Blank report to the new class library, I get an error:
The reference "System.Windows.Forms, Version 4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" could not be added to the project.

The class library is empty except for this report.

 

Dimitar
Telerik team
 answered on 30 Mar 2022
0 answers
120 views
I have a wpf project, with a telerik reports Report Library project, a lot of time ago I don't make a reports here, I need to make a new report, and I do it, and I add a SQL data source, with a sql query and I run it and response me with the data ok, but in design mode, when I try to add a textbox, the reporter don't show me any info in "fields", I review all and I don't find what is wrong, what's going on??
Cynthia
Top achievements
Rank 1
 asked on 29 Mar 2022
3 answers
478 views

I need a series of reports that display folder information in a hierarchical layout (undeterminate number of folder level parents/children) so i need to find a way to create a report that presents each level and then its children recursively, such as a recursive BandedReport or possibly a Subreport would do...
- Data is retrieved from an SQL database table in a self-referencing datatable(the Folder.ParentID points to another folder record with the same Folder.FolderID. 
- I design the Reports in the StandAlone designer.
- We need them to be "self-processing"... that is, apart from setting parameters being passed from the calling Winforms Application, there should be no "additional processing" or "value setting" or "business logic" from the calling application. We need it to be truly "set parameters and call RefreshReport()" and let it go... This is so that we (AND our clients) can add reports like these to our application without needing to change application code or needing custom programming.

I have looked at and run the project from 2013 "Recursive HierarchyReporting" (https://www.telerik.com/forums/recursive-hierarchy-reporting) and found it somewhat useful except 1) it processes the selection of the subreports within the code class and 2) it uses a dataobject hierarchical layout within the data structure rather than a flat table of records that self reference.
can you point me to some more recent examples of how to accomplish the hierarchical report from a self referencing SQL datatable query?
many thanks!!

Nima
Top achievements
Rank 1
Iron
 answered on 28 Mar 2022
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?