Telerik Forums
Reporting Forum
0 answers
8 views
I have two textboxes that need to be styled differently
I want the first text box to be able to shrink there is less text, but I want the 2nd text box always to be say, .1in from the right border of the 1st box. 

Is this possible? Some Conditional Formatting formula?
1 answer
6 views

I have a table that is grouped by the field CellWCCode. The SQL Query is returning multiple rows (one each for the child item in the BOM), so for example, I might get 5 lines per CellCode. The field StdLabCost returns the one item for each grouped item, but now I want to total the StdLabCost for all of the CellWCCode. I have not figured out how to Sum all of the distinct values.

I attached sample data and the report. 

Petar
Telerik team
 answered on 05 Jun 2025
1 answer
9 views

Hi

I have created reports in the Telerik Desktop Report Designer (v19.0.25.313) and I want to be able to open them in the Telerik Web Report Designer.

When I try to upload the .trdp package into the web Assets Manager I get an error - see screen sample.

How can I migrate a desktop report to a web report?

Thanks

Tim.
==

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 27 May 2025
1 answer
26 views

I'm using Telerik Reporting 2025 Q1 with the standalone Report Designer .NET.

I need to style my reports to match the background color of our application. I thought that using  a Parameter to pass in the color would be a solution, but I can't seem to bind it to the Style.BackgroundColor of the header panel.

I added an Integer parameter called ThemeColor with the value of a hex color (1445712).

First off, there is no editor support for binding for the value of the BackgroundColor (i.e. there is no dropdown menu to select expressions only different color pickets), but I can type in an expression manually. I'm not sure if this indicates that the BackgroundColor doesn't support expressions or it's a quirk of the editor).

I've tried entering =Parameters.ThemeColor, but it says that '=Parameters.ThemeColor is not a valid value for Int32.' 



I've also tried Parameters.ThemeColor.Value, but with the same error.

I've also tried =System.Drawing.Color.FromArgb(Parameters.ThemeColor), but the same error.

It only seems to accept named colors even through the documentation suggests that it should accept hex color.
https://docs.telerik.com/reporting/styling/styling-reports/styling-report-items

Thanks,
Canice

 

Dimitar
Telerik team
 answered on 14 May 2025
1 answer
75 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
25 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
0 answers
24 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
37 views

Our application allows users to enter Rich Text in some fields and we want to be able to print out that Rich Text in a report.

We are using Telerik Report Designer v19.0.25.313

Krasimir
Top achievements
Rank 3
Iron
Iron
Iron
 answered on 16 Apr 2025
1 answer
21 views

I am using a standalone report templates to display the data from SQL data source with using stored procedure. If I  add the columns in the select statement of stored procedure causing the below error.

Designer details,

For datasource since we are passing connection string dynamically we cannot refresh the configuration manually from report designer. In that case how do we resolve this issue?

Thanks in advance

Suresh
Top achievements
Rank 1
Iron
 answered on 15 Apr 2025
1 answer
24 views
I am generating an image of a highly complex and customized report as an image. From that image I am then generating a data uri to pass off to another report as part of its JSON datasource. The property that contains the data uri is being set to the value property of a picture box (see image for picture box settings). However, no image ever renders in the report. I've stepped through the code and confirmed the data uri is valid and I can load the image that is generated using the data uri in my browser. Is there some additional configuration I need to do to get this working with the picture box element?
Ivet
Telerik team
 answered on 14 Apr 2025
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?