Telerik Forums
Reporting Forum
1 answer
48 views

hi,

    I want to display a report book with the .trbp suffix in the ReportViewer component of Telerik UI For Blazor, but when I assign the ReportSource, it prompts that it cannot be converted from Telerik.Reporting.UriReportSource to Telerik.ReportViewer.Blazor.ReportSourceOptions. Is there any specific case reference?

 

ReportViewer.razor code::
<ReportViewer ViewerId="rv1"
              ServiceUrl="API/Reports"
              ReportSource="@BookReportSource"
              Parameters="@(new ParametersOptions { Editors = new EditorsOptions { MultiSelect = EditorType.ComboBox, SingleSelect = EditorType.ComboBox } })"
              ScaleMode="@ScaleMode"
              ViewMode="@ViewMode"
              PageMode="PageMode.SinglePage" />

public object BookReportSource { get; set; } = new Telerik.Reporting.UriReportSource()
{
    Uri = $"{ReportParameters.ReportName}.trbp"
};

protected override Task OnParametersSetAsync()
{
    switch (ReportParameters.ReportName)
    {
        case nameof(Report.StaffCapitalisationRatioReport):
            BookReportSource.Parameters.Add("StartDate", ReportParameters.StartDate);
            BookReportSource.Parameters.Add("EndDate", ReportParameters.EndDate);
            BookReportSource.Parameters.Add("BusinessUnit", ReportParameters.BusinessUnit);
            BookReportSource.Parameters.Add("FormatDate", Convert.ToDateTime(ReportParameters.EndDate).ToString("yyyy / MMMM"));
            BookReportSource.Parameters.Add("StaffNo", ReportParameters.StaffNo);
            BookReportSource.Parameters.Add("NormalWeekdayHours", ReportParameters.NormalWeekdayHours);
            BookReportSource.Parameters.Add("NormalWeekendHours", ReportParameters.NormalWeekendHours);
            break;
    }

    return base.OnParametersSetAsync();
}



Dimitar
Telerik team
 answered on 17 Oct 2024
1 answer
26 views
I use a table to display my data, there maybe 2-3 pages, and I want to achieve the effect of cross-page calculations.

For example 
The first page has 10 rows
Then the total number of the first page is 10
The second page has 20 rows
Then the total number for the second page is 30

How should I design it? I want to display this total on PageFooter
Dimitar
Telerik team
 answered on 17 Oct 2024
0 answers
233 views

I have created a REST Report Service in my .Net 8 MVC Project in Visual Studio. I can set Multiple Startup Projects and launch the debugger in Visual Studio, and everything works fine.

I will eventually need to have this REST service running on my IIS Server in production, but for now, I am attempting to get it working on IIS on my Windows 11 machine. 

I created a new REST Service using the Telerik template:

After creating the project, I launched the debugger, and the project launched a browser to http://localhost:59655/index.html with the message Telerik Reporting REST Service is up and running.

Still in Visual Studio, I have published the REST Service to a folder using the following settings:

In IIS, I create a new Site and App Pool with No Managed Code like my other .Net Core apps. I set the bindings to Port 59655 as it does in Visual Studio (not sure if this is necessary, or the wrong thing to do) but when I try to browse to http://localhost:59655/index.html, it gives the error: No webpage was found for the web address: https://localhost:59655

If I bind to HTTP instead of HTTPS, then I get the error: This site can’t provide a secure connection. 

So my question is, should I be using this port on IIS? What other settings must I change when publishing the app to a folder? There are settings in the launchSettings.json file that apply to IIS Express, so I don't think those apply.

I really have to figure this out before I attempt to deploy this to production, but I'm not really sure how to run the service with IIS.

Thanks for any help in advance.

 

 

Kevin
Top achievements
Rank 1
 asked on 11 Oct 2024
1 answer
61 views

Hello Telerik Support Team,

I am experiencing an issue with a report generated from a database in my desktop application developed in C#. I am using Visual Studio 2015 with .NET Framework 4.0 and Telerik Reporting version R1 2017 SP2 (11.0.17.406).

Below is a description of the observed behavior:

  1. I have a report that displays several rows of data (for example, 3 rows).
  2. When clicking on the hyperlink in the first row, the images do not load.
  3. When clicking on the hyperlink in the second row, the images from the first row load.
  4. When clicking on the hyperlink in the third row, the images from the second row load.
  5. Only by refreshing the report do the images corresponding to the selected row load.

Additionally, I have noticed that the hyperlinks appear misaligned in some machines running Windows 11. Interestingly, on some devices with the same version of Windows, the behavior is correct, and the images load appropriately.

I would like to know if there is any solution or adjustment I can make to ensure that the images load correctly when selecting each hyperlink and to resolve the hyperlink alignment issue.

Thank you in advance for your assistance.

0 answers
36 views
An error has occurred while processing Report 'Test':
Object of type 'MySql.Data.MySqlClient.MySqlCommand' cannot be converted to type 'System.Data.SqlClient.SqlCommand'.


report was working when i was using trial version of NuGet packages  when i put piad version of nuget package i am getting below issue 
please help
Mynd Integrated Solutions
Top achievements
Rank 1
 asked on 07 Oct 2024
1 answer
39 views

Hi

I'd like to programmatically (from an OpenEdge ABL procedure) run a Telerik Report (TRDP file) that has been saved on disk.

I'd also like to point that report file to 2 datasources at runtime that are also on disk "invoiceHeader.json" and "invoiceLines.json". 

The output must be a PDF file.

Please can you point me in the right direction.

Many thanks

Jon

 

1 answer
37 views
I will put Vietnamese and Chinese in the same text box
I set the font to Arial Unicode MS
But the result is that the Chinese text becomes a box
I’ve tested many fonts but can’t get the answer.
My preview on the designer is normal, and the PDF output on the designer is also normal.
But on my webpage, the pdf output is abnormal.
I don’t know if there is a solution

Dimitar
Telerik team
 answered on 02 Oct 2024
1 answer
45 views

Hello,

I am very new to Telerik reporting and a client has asked me to resize a column in a table so that the column to the left is smaller and the one to the right can be larger. I'm finding this to be very difficult. If I try to type in a different size, it tells me the property is invalid. I can't slide it over by grabbing anything. I tried removing all text from within the columns first. Is there something I can check that is preventing me from doing this?

 

thanks in advance!

-Crystal

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 30 Sep 2024
1 answer
33 views

Hi All,

(.NET 8 application)

I have created unit tests to run Telerik report component and it works great. I load the report definition file and run using ReportProcessor and get an output pdf file.

I have also created custom functions and configured the standalone report designer (SRD) config file. I can preview the custom functions in the SRD. Now I have a problem, I dont know how to configure the unit test environment to load the custom functions? Can anyone give advice how to configure for unit tests?

Thanks

Tarquin
Top achievements
Rank 1
Iron
 answered on 29 Sep 2024
37 answers
3.3K+ views
Hi,

    I am exporting the report to CSV from report viewer.The report is generated, but it includes the textbox controls name as header. I have attached the screenshot of the CSV file which i have exported. Is there any way to fix this?


Thanks,
Nisha

Christopher
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 26 Sep 2024
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?