Telerik Forums
Reporting Forum
0 answers
376 views

I'm generating a report, getting the data from a sproc. I assigned the result of the sproc to Data Source  of my report, and I'm able to et data when binding the report and tables, but before rendering the report the Data Source is deleted and not data is shown in the report. 


 Private Sub EmployeeComplianceStatement_NeedDataSource(sender As Object, e As EventArgs) Handles Me.NeedDataSource
        Dim ContractID As Integer? = Me.ReportParameters("ContractID").Value
        Dim EmployeeID As Integer = Me.ReportParameters("EmployeeID").Value
        Dim StartMonth As Integer = Me.ReportParameters("StartMonth").Value
        Dim StartYear As Integer = Me.ReportParameters("StartYear").Value
        Dim EndMonth As Integer = Me.ReportParameters("EndMonth").Value
        Dim EndYear As Integer = Me.ReportParameters("EndYear").Value
        DS = EmployeeBenefitsManager.GetEmployeeBenefitsCompliance(ContractID, EmployeeID, StartMonth, StartYear, EndMonth, EndYear)
        Dim pageHeader = TryCast(Report.Items.Find("pageHeaderSection1", True)(0), Telerik.Reporting.PageHeaderSection)
        Dim txtNodata = TryCast(pageHeader.Items.Find("txtNoData", True)(0), Telerik.Reporting.TextBox)
        If DS.Length = 0 Then
            txtNodata.Visible = True
        Else
            txtNodata.Visible = False
        End If
        Report.DataSource = DS
    End Sub
Private Sub Table1_NeedDataSource(sender As Object, e As EventArgs)
        Dim Table1 As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)
        Table1.DataSource = DS
    End Sub

    Private Sub Table2_NeedDataSource(sender As Object, e As EventArgs)
        Dim Table2 As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)
        Table2.DataSource = DS
    End Sub

    Private Sub Table3_NeedDataSource(sender As Object, e As EventArgs)
        Dim Table3 As Telerik.Reporting.Processing.Table = DirectCast(sender, Telerik.Reporting.Processing.Table)
        Table3.DataSource = DS
    End Sub


csst
Top achievements
Rank 1
 asked on 25 Apr 2022
0 answers
672 views

I have used the Telerik Report Designer and use the Expression window a lot to select fields, find functions, etc.

When I go to the Web Report Designer, the window is blank. How can I get the same functionality? I noticed on the sample web designer report, I run into the same limitation.

See the attachment.

Marvin
Top achievements
Rank 2
Veteran
Iron
 updated question on 25 Apr 2022
1 answer
295 views

Good morning,

Every time I hit this button, I get a NullReferenceException:

As I don't actually need to have search capability, I'd like to just remove this button. Is there a way to do this and/or intercept the handler so I can suppress the action and/or is there a simple fix?

My XAML declaration is just:

Thanks!

Dimitar
Telerik team
 answered on 21 Apr 2022
1 answer
482 views

안녕하세요, 보고서 디자이너에서 subReport를 검색하는 방법으로 CSVDataSource를 사용하고 있습니다. CSVDataSource는 메인 리포트의 ReportParameter를 이용하여 값을 지정하므로 subReport의 ReportSource는 '=Parameters.SubReport Value'가 됩니다. 또한 Telerik에서 제공하는 ReportConnectionStringManager 클래스를 사용하여 소스 코드의 ConnectionString도 변경하려고 합니다. ReportConnectionStringManager 클래스는 SubReport의 ReportSource를 사용하지만 실제 매개변수 값을 가져오지 못하고 '= Parameters.SubReport.Value' 문자열을 가져와서 오류가 발생합니다. 문제를 처리하는 방법을 회신해 주시면 감사하겠습니다. 고맙습니다.

 

CC :  https://docs.telerik.com/reporting/knowledge-base/change-the-connection-string-dynamically-according-to-runtime-data#description

1 answer
827 views

Hello,

 

We have WPF app running on .NET Core 6 and Telerik.Reporting.16.0.22.225, Nuget package is installed. We are using VS 2022.

Now we are getting the error while adding Telerik Reporting R1 2022 new item into the project:

"The reference System.Drawing, Version=4.0.0.0 could not be loaded to the project"

As a result the Telerik Reporting Designer could not be opened

 

Do you have an idea how to resolve it?

 

Regards,
Yurii

Dimitar
Telerik team
 answered on 18 Apr 2022
1 answer
228 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
151 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
254 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
154 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
261 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
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?