Hi all,

I have the following case with Telerik Reporting. I have a list which is fed with some data. The number of items may vary from 0 to practically unlimited. I want to show up to 3 records on a line. New records should go on a new line in the report.  I used this article as a reference but I still cannot solve it elegantly as the number of elements may be different each time -> https://docs.telerik.com/reporting/knowledge-base/how-to-create-multi-column-report---across-the-page-and-then-down

I'm sending a sample report as a reference. Does anyone have ideas on how to handle this? Some of the problems I encounter are:

• some times some of the values are not rendered
• sometimes there are blank boxes
• I want the number or rows to grow dynamically based on the number of elements I want to visualize in the list

Regards,
Krasi

Hello All!  I am having some difficulties debugging an issue with the ReportViewer not showing the rendered Report.  The Output states that the report was rendered in X seconds.  My report xaml is as follows:

<Window
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:tr="http://schemas.telerik.com/wpf" x:Class="FRAC_FLOW.TestReport"
    Title="Report Viewer Window">

    <Grid x:Name="LayoutRoot">
        <Grid Margin="20" >
            <Grid.RowDefinitions>
                <RowDefinition Height="*" />
            </Grid.RowDefinitions>

            <tr:ReportViewer Grid.Row="0" x:Name="ReportViewer1"/>
        </Grid>
    </Grid>
</Window>

I am setting the source and parameters in the constructor:

public TestReport()
{
    InitializeComponent();


    Telerik.Reporting.Parameter parm = new Telerik.Reporting.Parameter { Name = "JobId", Value = "7215" };
    Telerik.Reporting.Parameter parm1 = new Telerik.Reporting.Parameter { Name = "Date", Value = DateTime.Now.ToShortDateString() };

    var reportSource = new UriReportSource();
    reportSource.Uri = new Uri("Reports/ReplacementParts.trdp", UriKind.RelativeOrAbsolute).ToString();

    ReportViewer1.ReportSource = reportSource;
    ReportViewer1.ReportSource.Parameters.Add(parm);
    ReportViewer1.ReportSource.Parameters.Add(parm1);
    ReportViewer1.RefreshReport();
}

Hello, 

I have two questions,

1. I have a crosstab table with one group and data(fields) from data source. Before clicking on the preview I have some parameters I need to fill, and I would like to have an option for sorting my table. For example having a parameter that is a list of fields from my data source (also used in a crosstab table) as an option, when I click on one of the fields and preview, table is sorted by the option I chose. For better understanding, here is an a example - I chose sort by date (cause Fields.Date exists in data source) before generating, click on preview , all my data is going to be sorted by the group from above and then dates. When I want to generate report again, this time I choose to sort by document number (Fields.DocumentNumber exists in my table and data source) and it generates the report having a group from above and then a sorting by Document Number. How can I achieve that ? I am using Telerik reporting R3 2022.
   
2. I have two text boxes A and B in two columns next to each other in my crosstab. B is conditioned for visibility by binding. When B is unvisible (because the condition = false) I would like to merge my textbox A with B so I have a larger textbox A. And when B is visible (condition = true), everything is back to normal, meaning A has its text box in A's column like before and B has its own text box in B's column. Would that be possible?
   
    Thanks in advance! Hope to hear from you soon!
   
   Best regards,
   Tamara

I'm using 17.0.23.118 version of Telerik report in ASP.net webform. I used Horizontal line(Shape) to separate the rows in DetailArea and PageHeader area.
I want, it should visible in web view but want to hide in exported .xlsx file. Currently its visible in both places.
Please help me out in this.

I'm trying to create a Report that has a dynamically generated DataTable as its DataSource.

I’ve programmatically placed a DetailSection on the Report, and added a TextBox for each column of the DataTable to the DetailSection.

The TextBoxes are databinding, but I can’t figure out what the proper Expression would be to access the column data for each TextBox.

The ReportItem.DataObject.RawData for each TextBox is a DataRowView.

In the Immediate window in Visual Studio, I can access the column data from within the TextBox DataBinding handler with the following:

((System.Data.DataRowView)(((Telerik.Reporting.Processing.TextBox)sender).DataObject.RawData))["ID"]

 Please tell me what Expression would access the column data. 

1. it possible to create telerik report programmatically in asp.net core?

2. I need to create teleik report programmatically in asp.net core and to display in html5 viewer?

can you any let me know ans.

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.

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.