Telerik Forums
Reporting Forum
1 answer
177 views

Report Services Are work 

 

[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLS","localizedName":"Excel 97-2003"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"MHTML","localizedName":"Web Archive"},{"name":"XPS","localizedName":"XPS Document"}]

 

but when we call from react js

Dimitar
Telerik team
 answered on 15 Apr 2022
0 answers
109 views
I have two tables in my detail section with the different data sources. The report preview itself is fine and it displays the contents of the tables separately, table 1 at the top and table 2 at the bottom, as expected. But when I want to export it to CSV format it shows the content of table 1 and the content of table 2 in the same row. Is there a way to display the content of the tables in separate rows? 
0 answers
178 views

I have a report with two data sources. There is not anything complicated about my report, but I do have 18 Report Parameters. The report takes a good 5 minutes to generate. When I performed a SQL trace, the first query is sent to the server repeatedly, (this is the slow-down) whereas the the other query is sent just once. Why is it doing this? Report is attached.

Thanks!

0 answers
107 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
187 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
203 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
194 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
88 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
524 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,
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?