Telerik Forums
Reporting Forum
2 answers
2.1K+ views

We're using Azure Reids Cache for our report storage provider. Long running reports result in this error: 
One or more errors occurred.
Timeout performing SET (5000ms), next: SET DispatchAnywhere3Reports\16.1.22.622\Is\948f13fe22c\Rs\6b25108b8df\Ds\6faa346e5ae\R\page30, inst: 108, qu: 0, qs: 0, aw: False, bw: SpinningDown, rs: ReadAsync, ws: Idle, in: 0, serverEndpoint: *********************, mc: 1/1/0, mgr: 7 of 10 available, clientName: WS039(SE.Redis-v2.6.48.48654), IOCP: (Busy=0,Free=1000,Min=8,Max=1000), WORKER: (Busy=44,Free=8147,Min=8,Max=8191), v: 2.6.48.48654 (Please take a look at this article for some common client-side issues that can cause timeouts: https://stackexchange.github.io/StackExchange.Redis/Timeouts)

Rest Reports Config:

<restReportService hostAppId="DispatchAnywhere3Reports" reportSharingTimeout="0" clientSessionTimeout="15">
<storage provider="Redis2">
<parameters>
<parameter name="configuration" value="****,password=****,ssl=True,abortConnect=False />
<parameter name="databaseNumber" value="6" />
</parameters>
</storage>
</restReportService>

Does anyone have experience using Azure Redis? Are there additional configuration settings required?

Thanks for your help!

Aleksandar
Top achievements
Rank 1
Iron
Iron
 answered on 23 Feb 2023
1 answer
448 views
Hi

I'm wondering if there is any possibility to print a report using a specific network printer. From the list of commands I've seen that there is a Print command, that does not take any arguments. I've tested this out and this shows the printing dialog from where I can select the printer and then print the report. This is not exactly what I need.

Is there a way to directly send the report to a network printer (it doesn't matter if it was visible in a ReportViewer before or not, I can handle this in my project) without showing the print dialog?

Best Regards,
Roman 
Todor
Telerik team
 answered on 23 Feb 2023
1 answer
205 views

Hello Support,

we use older version 7.0.13.426, 2012 as a part of GMSC. I face an issue with hiding Panel report item. When I set in Bindings both Visible and Style.Visible params to False for sure:

It causes extension of the DetailSection that exceeds to the next page and causes "blank" page. I set yellow background color for the DetailSection (orange is pageFooterSection) to make it more clear.

Could you help me please? This topic seemed to be similar to my issue and the link http://www.telerik.com/support/kb/reporting/details/collapse-the-container-when-hiding-child-report-items- is not working.

Thank you,

Lukas

Dimitar
Telerik team
 answered on 23 Feb 2023
1 answer
385 views

Hi,

I have designed a report template using web report designer using json data(for invoice pdf).

Now I want to display pdf/report using different data by passing an argument.

I want to use the same template for all invoice pdf.

Kindly explain is this possible in telerik also can you provide a sample code for this?

I am using ASP.net mvc for developing the project

Dimitar
Telerik team
 answered on 22 Feb 2023
1 answer
665 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
274 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
892 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
182 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
936 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
681 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
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?