Telerik Forums
Reporting Forum
1 answer
628 views

Good Afternoon Telerik Forums,

 

Somehow, while messing with my Parameters I made a parameter within the Telerik Standalone report designer as a Text field. Where instead of selecting something displaying. it allowed you to type in your request. I did not need that at the time so I erased my parameter and started again. Now I am needing to know how to replicate this so that I can have someone type in one of the fields (in example an employee number).

How can I accomplish this again?

Thank you!

1 answer
244 views

Greetings!

I have some reports that contain tables created dynamically by the C# application. The procedure is more or less similar to what you describe in the documentation. Those reports are inserted in a report book and displayed in an Angular app with the viewer.  My problem is this: some of those reports need an extra row added that will sum the content of columns with monetary values. This row must be either at the bottom of the report or at the bottom of a group inside the table. I 've read relevant entries in the forum and the documentation, but all I could find is how to add the sum row in the designer, which is not my case. So what I'm asking is if there is any way to add it programmatically. 

Thanks!

Dimitar
Telerik team
 answered on 21 Feb 2023
1 answer
865 views

Actually, we use the TR-Viewer. But can you call the serviceURL REST API telerik report to print directly on a local printer?

In the same way to download automatically the PDF result of a report?

Dimitar
Telerik team
 answered on 20 Feb 2023
2 answers
169 views

Currently, I have two different parameters. One uses Fields.ID the other needs to use Field.ID2 However, using the code below. I am unable to rename ID to ID2. If I use ID It modifies Parameter1's ID field instead of Parameter2's ID field. I need to use dual union to be able to select all employees but when I run it with the "AS" command for renaming ID to ID2 it errors out(see below code). If I run it without the dual union. It works and renames ID to ID2. But, then I do not have the ability to select all employees which I need. How can I fix this in the report designer? is there a better way or am I using my code wrong, what would be a good solution to this?

 

How can I get this to work and rename ID to ID2 for the second source using the code below so that I can still use the dual union?

 

[Doesn't work]

SELECT TO_NCHAR('All Employees') AS FirstName, TO_NCHAR('*') AS LastName, 0 AS ID FROM DUAL
UNION
select FirstName, LastName, ID AS ID2

FROM Personnel
ORDER BY LastName NULLS FIRST

 

[Works]

select FirstName, LastName, ID AS ID2

FROM Personnel
ORDER BY LastName NULLS FIRST

 

 

Thank you!

1 answer
886 views

I'm trying to implement Telerik web report designer to blazer .NET MAUI hybrid app, and it keep giving above mentioned error when I try to view the created. report. But I have already add Cors to the app.

{
    ReportingEngineConfiguration = sp.GetService<IConfiguration>(),
    HostAppId = "newcumstomreportAPI",
    Storage = new FileStorage(),
    ReportSourceResolver = new UriReportSourceResolver(
        Path.Combine(Environment.CurrentDirectory, "Reports"))
});
builder.Services.AddSingleton<IReportDesignerServiceConfiguration>(sp => new ReportDesignerServiceConfiguration
{
    DefinitionStorage = new FileDefinitionStorage(Path.Combine(Environment.CurrentDirectory, "Reports")),
    SettingsStorage = new FileSettingsStorage(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Telerik Reporting")),
    ResourceStorage = new ResourceStorage(Path.Combine(Environment.CurrentDirectory, "Resources"))
});

builder.Services.AddCors();

var app = builder.Build();




app.UseStaticFiles();
//app.UseCors(MyAllowSpecificOrigins);
app.UseCors(builder =>
                builder.WithOrigins("*")
                .AllowAnyHeader()
                .AllowAnyMethod()
            );

app.UseRouting();

app.UseEndpoints(endpoints =>
{
    endpoints.MapControllers();
});
Is it possible to add web report designer to Blazor Hybrid?
Dimitar
Telerik team
 answered on 16 Feb 2023
1 answer
639 views

Hi guys

I created a small Blazor WebAssembly (ASP.NET Core hosted) application to test out your ReportViewer. I have a Razor page with the following code:

@page "/"
@using Telerik.ReportViewer.Blazor 
  

<style>
    .trv-report-viewer {
        width: 1300px;
        height: 880px;
    }
</style>

<button type="button" @onclick="LoadReport">Load Report</button>
  
<ReportViewer @ref="reportViewer1"
                ViewerId="rv1"
                ServiceUrl="/api/reports/"
                ScaleMode="@(ScaleMode.Specific)"
                Scale="1.0"
                ViewMode="@(ViewMode.Interactive)"
                EnableAccessibility="true"/> 

@code {
    ReportViewer reportViewer1;
    Dictionary<string, object> parameters;

    private async void LoadReport()
    {
        parameters = new Dictionary<string, object>()
        {
            { "TextboxValue", "My Testvalue" }
        };

        reportViewer1.ReportSource = new ReportSourceOptions()
        {
            Report = "TestReport.trdp",
            Parameters = parameters
        };

        await reportViewer1.RefreshReportAsync();
    }
}

In my project I added a folder "Reports" to the .Server project and created a sample Report called "TestReport.trdp" using the Telerik Report Designer application. For the report I created a parameter named "TextboxValue" which I'm setting in the code above.

I also added this code snippet to my Server's Program.cs:
builder.Services.TryAddSingleton<IReportServiceConfiguration>(sp => new ReportServiceConfiguration
{
	ReportingEngineConfiguration = sp.GetService<IConfiguration>(),
	HostAppId = "ReportingTest.Server",
	Storage = new FileStorage(),
	ReportSourceResolver = new TypeReportSourceResolver().AddFallbackResolver(new UriReportSourceResolver(reportsPath))
});

The application runs ok, no errors. But when I hit the "Load Report" button, it simply shows "No report" in the ReportViewer. Can you guys see what I'm missing or what I'm doing wrong? I uploaded my sample application for you to better see behind my code. Since the file size is bigger than 20MB, I had to upload it to another website where you can download it. See this link: https://we.tl/t-9FKRVgpdmh (the link expires after seven days).

Best Regards,
Roman
Dimitar
Telerik team
 answered on 15 Feb 2023
1 answer
619 views

We are getting an error "A StartDocPrinter call was not issued" when running reports at one of our customers.  I want to believe this is a printer/os issue and not a Telerik reporting issue, as we have not seen this at other customers.   

TIA for any input.

Dimitar
Telerik team
 answered on 15 Feb 2023
1 answer
233 views

Good Afternoon Telerik Forums,

I have a MainData (SQLDataSource) a (Tech1DataSource) and a (Tech2DataSource).

 

I have 4 parameters currently. From Date(start date), To Date(end date), Tech1IDParameter, Tech2IDParameter.

If I remove Tech2IDParameter- the report loads fine without an error. However, when I add in Tech2IDParameter (pointing to Tech2DataSource) I get the error below.

 

Tech1IDParameter and Tech2IDParameter are virtually identical in the settings and parameter fields except for what they query. Any help would be greatly appreciated! Please see the error below.

 

Unable to get report parameters.
An error has occurred.
Cannot evaluate parameter 'Tech2IDParameter'.

Austin
Top achievements
Rank 2
Iron
Iron
Iron
 updated answer on 14 Feb 2023
2 answers
279 views

Hi,

Recently, my customers often report a problem when accessing report reviewer (see attachment Error1.jpg). I inspected and found out that the problem is the error when registering the client with reporting service. I try to re-produce the issue by using Postman and it happens but not frequently (see attachment Error2.jpg). Sometimes it happens, sometimes not. I cannot figure out the cause.

Please help!

Scott Waye
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 14 Feb 2023
1 answer
106 views

I would like to design some reports in my visual studio project using Telerik Reporting.

While I can basically create the report object, I am unable to bind data from my project dataset to the report. All attempts to bind data source  present many data sources (SQL server, JSON, etc.) that are not my aim. I just what to use predefined tables, queries from my project dataset the same way I use them in the forms. My project dataset is a MS Access database.

Momchil
Telerik team
 updated answer on 10 Feb 2023
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?