Telerik Forums
Reporting Forum
2 answers
173 views

Question Details

I have multiple expressions which redo the same calculation several times. 

Part of the calculation uses an aggregated result of a field.

Is there a way to simplify and increase the maintainability of the report by creating a calculated field for a group? This field would be used multiple times in sub-groups and in the detail section.

Please note that I do not have the power to update the source code and because of this I can not create "custom functions". 

I've tried to store the calculated value in an invisible text box but I can't seem to recall this value to be used in subsequent text boxes. 

 

Very Simplified Example

Let f(x) = Avg( Field.x ) <-- How do I set this in the group header so I can reference it in the detail section?

Let textBox7.Value = "Distance From COM: " + Abs( f(x) - Field.x )

 

 

Note: If this is not possible across groups, but it is within a group please let me know. This would also greatly simplify the maintainability of my report. 

 

Thank you for taking the time.

Pascal
Top achievements
Rank 1
Iron
Iron
 answered on 06 Nov 2023
0 answers
492 views

I would like to populate and disable the From input from the client. I am running into a few issues:

 

1. It appears the viewer page is blocking the bundled javascript include. As a work around I am including the script file in the header which works fine and acceptable for me.

    <script src="@Url.Content("~/scripts/reportsportal.js")"></script>

2. It appears that something is blocking the ability to bind to the event SEND_EMAIL_BEGIN

ex in my script file reportsportal.js I am attempting to bind to the SEND_EMAIL_BEGIN so that I can populate and disable the FROM input using jquery

 

However it appears that my script file is getting blocked and the following message is displayed in the browser console:

Autofocus processing was blocked because a document already has a focused element. 

 

I don't think the script runs at all.

 

$(document).ready(function () {
    if (reportViewer) {

        reportViewer.bind(telerikReportViewer.Events.SEND_EMAIL_BEGIN, function (e) {
            debugger
            console.log(this.id);
        });
    }


});

 

 

 

 

3. As a work around to not being able to bind to SEND_EMAIL_BEGIN , I wired one of the declarative events on the viewer widget:

        .ClientEvents(ev=>ev.PageReady("printPageReady"))

 

In printPageReady I was able to capture the From field with a selector

function printPageReady() {
    var t = $('input[name="from"]')
    t.val('test@yahoo.com')
}

Setting val on input[name="from"] DOES NOT generate any exceptions and checking the variable t in the console shows that a value has been assigned however when the Send Email dialog pops up the From input is still empty.

 

 

Is there another approach that I can use to access, disable and populate the From input from the client.

 

 

Sean
Top achievements
Rank 1
Iron
Iron
 asked on 06 Nov 2023
1 answer
338 views

Hello, 

Is it possible for header from subreports do be shown on the main report? I have four different subreports with their own headers and my main report will not have a header (nor title), so I need in my main report to import header + detail section from subreport.

I think I saw that it could be done by reportBook, but that will not work for me. 
Or by some grouping criteria but I am not sure how is that functioning.

Thanks in advance! 

Best regards,
Tamara Karadjinovic

Momchil
Telerik team
 answered on 03 Nov 2023
0 answers
177 views

Hi Team,

I'm creating a web form application and using Telerik Report Designer 2023 R1. This work fine with string parameter. Then when I am using DateTime parameter on Preview at Configure sqlDataSource its show error "Cannot get preview".

Rahul
Top achievements
Rank 1
 asked on 02 Nov 2023
1 answer
137 views

hi Team,

I want to adjust the panel from one column to two column  in the report along with other components in the report. will it possible ?

Dimitar
Telerik team
 answered on 31 Oct 2023
2 answers
475 views
Can we limit number of columns per page in CrossTab? We have a data-source that contain more than 15 columns, and when we bind it with Cross tab then the remaining columns that  are not fit in the first page goes to the bottom of next page(image- Cross Tab Print at Bottom).Can we control this behavior and make sure remaining columns always print from the top and with correct margin?
Gurpreet
Top achievements
Rank 1
Iron
 answered on 30 Oct 2023
1 answer
246 views

How can I fix it? If you want to export excel that is not CSV. in angular.

Dimitar
Telerik team
 answered on 30 Oct 2023
1 answer
157 views

We use BlazorNative for Reporting.

In the sample with external parameters, there is the idea shown after submitting the Report:

  • Submit, make the Form invisible
  • start a delay (eg. 2000ms)
  • and make the Form visible again.

This works, but from the user perspective it is unclear what is  happening. Cause in the Viewer we have this message "0 pages so far..." and after a log processing time, the (big) report shows up, meanwhile the dialog is visible earlier. This leads to confusion of the user.

A better solution would be, setting the Form visible again after the Report is fully displayed.

Is there a event we can catch? Maybe in JavaScript with JsInterterop to gain this information?

 

Dimitar
Telerik team
 answered on 30 Oct 2023
1 answer
147 views

I am making a telerik report

However, I want to display a diagonal line in the textbox when a specific value comes in.

I want it to be displayed like this.


this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.5D), Telerik.Reporting.Drawing.Unit.Cm(0.5D)); this.textBox10.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center; this.textBox10.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox10.StyleName = "Aspect.TableBody"; this.textBox10.Value = "= IIf(Fields.Name = 'Day', ' ', Fields.Name)";


I wrote the code like this, and first of all, if the data is Day, it is treated as blank, but when the data is Day, I want to display it like an image

Todor
Telerik team
 answered on 30 Oct 2023
1 answer
192 views

When i create report in standalone application with WebServiceDataSource as trdx file i can see section for Authentication with user and password

      <Authentication>
        <WebServiceBasicAuthentication Password="eYk0jBuZWWwHo1LHgtDHjA==" Username="user" />
      </Authentication>

what algorithm do you use to hash password? how it is save?

Momchil
Telerik team
 answered on 30 Oct 2023
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?