Telerik Forums
Reporting Forum
1 answer
159 views
Good afternoon.

I'm hitting a new roadblock that I've never hit before with the standalone report viewer.

The crux of the problem - I have many reports with lengthy WITH () statements, none of them have caused issues to date. That said I have a particular data source with this as the second term of the query:

), L01 AS (
    -- L0 without writeoffs
    SELECT * FROM L0 WHERE [WriteoffTF] = 0

That works fine, if I run it alone in SSMS it runs in 7515 ms

I need to make a change based on an output mismatch the client noticed, it's a very simple change - only removing the WHERE clause:

), L01 AS (
    -- L0 without writeoffs
    SELECT * FROM L0 

This query runs alone in SSMS in 8219 ms


In Telerik Standalone Report Viewer the first version works fine but the moment I remove the WITH statement I get this:

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


Where I'm stuck:

1) The connection string is in a .Net Core / Angular project (pulling from the .Net Core side) so there's no web.config until the app is published. The connection string being used is from my appsettings.json file.
2) Adding time to my connection string, like 'Connect Timeout=600', this unfortunately has no impact.

I also tried opening up the .trdp as a .zip and looking at the definition.xml but I couldn't find any reference to time and if I need to add something there I don't have any examples as to what the syntax should be.

I just went to File > Help to see which version of the standalone report viewer I'm using, it's
14.0.20.115.

Please let me know if you have any ideas on how I can resolve this as well as whether you need any additional information.


Ron
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 06 May 2025
1 answer
35 views

I'm using    JsonConvert.SerializeObject(ds)  to convert to JSON string     dataset composed of three tables   the resulting JSONcomes back with something the result shown below.  These fields are part of header section in the report and they are giving me errors.  Someone suggested to remove the square brackets in order to make it work and it did the trick.  Is there a way I can access these fields in the header section without making changes to the resulting JSON?  

Petar
Telerik team
 answered on 05 May 2025
1 answer
52 views
I think I want to do something simple.  I just want to link PictureBox image to a file I uploaded into my Project in Visual Studio.  See screenshot below.

What is the syntax I should use in a UserFunction to link the value of the PictureBox to the image located in the directory indicated below.

Ivet
Telerik team
 answered on 05 May 2025
1 answer
34 views

hi,

    I would like to ask, why does Telerik Report request the /info api multiple times? Can this info interface be requested in other ways to reduce the number of times?

thanks.




Petar
Telerik team
 answered on 02 May 2025
1 answer
32 views

Hi everyone,

I'm having an issue with Telerik Report Viewer (HTML5 version) and Telerik Report Designer. I'm trying to change the database connection dynamically, and although the new connection string is being passed correctly (I’ve confirmed this by printing the in-memory values), the report viewer keeps using the initial connection and doesn't apply the new one.

What's even stranger is that after clearing cookies, browser data, and restarting the site, it still sticks to the first connection it received. It feels like Telerik stores this connection internally (maybe through caching or some static variable) and won’t allow it to update.

Has anyone experienced something similar or knows how to force the viewer to use the new connection?
Any suggestions or guidance would be greatly appreciated.

Thanks in advance.

1 answer
82 views

I'm using ReportProcessor in my .NET 8 project to render a trdp report.  Rendering in PDF works fine but when I try to render as XLSX I'm getting the error in the subject line.

I've triple checked that I have installed all dependencies per this article OpenXML and XPS options not visible. Unavailable rendering format - Telerik Reporting

Any suggestions?


        [Authorize]
        public IActionResult Export(long id, string reportName="Statement.trdp", string format="PDF")
        {
            var baseUrl = $"{Request.Scheme}://{Request.Host}{Request.PathBase}";

            var reportProcessor = new ReportProcessor();
            
            var uriReportSource = new UriReportSource
            {
                Uri = Path.Combine(_environment.ContentRootPath, "Reports", reportName)
            };

            uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("stmtId", id));


            uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("url", baseUrl));

            var result = reportProcessor.RenderReport(format, uriReportSource, null);

            return File(result.DocumentBytes, result.MimeType);
        }


B
Top achievements
Rank 1
Iron
 answered on 30 Apr 2025
0 answers
31 views

I have a report with three parameters - two drop-downs and a date. All have AllowNull set to False.

The two drop-downs work fine when I pick data, but the Date parameter still has the red mandatory asterisk even though I have selected a date from the calendar - see below

What am I doing wrong?

Thanks

Tim.
==

Tim
Top achievements
Rank 1
 asked on 24 Apr 2025
1 answer
28 views

Can I run the VS report designer in a .net 8 Class Library project?

I can do it with .net 4.8 but not with standard nor .net 8?

Dimitar
Telerik team
 answered on 22 Apr 2025
2 answers
31 views

I am trying to replicate ssrs reports into telerik, and I need to have a Table layout like,

   column title         column title          column title

subtitle subtitle        subtitle            subtitle subtitle

  data      data              data                  data      data

 

can that be done from the webreportdesigner?

Ivet
Telerik team
 answered on 22 Apr 2025
1 answer
58 views

Hey forum members, 

My company recently decided to move the apps from IIS to Kubernetes. We had some issues with fonts but we solved. Telerik can render pdf succesfully but we see some shifts on texts and spaces in words get bigger. It renders on IIS on windows server fine, but in docker container, it seems weird a bit. We could not the reason. 

I m attaching the screenshots.
Note: all the data in the attached pictures are test data. They are not valid.

What is your suggestions about the cause? 

Thanks

Said

Todor
Telerik team
 answered on 22 Apr 2025
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?