Recently I've had to upgrade reports in one of my projects to a newer version so I could install the Plugins for VS2019. I have a Devcraft Ultimate develop license and installed the _DEV package as mentioned in this article.

This article states 

"Developer licenses come with modified DLLs which work without license keys"

I uninstalled the previous version completely prior to installation, upgraded my Reports to the latest version via the wizard, and the binaries in my project were updated to point to the Telerik install directory as expected. When I run the application locally I can execute the reports without seeing a watermark however if I publish the project for deployment and deploy it to IIS on my client's server all my Reports get the watermark below.

So my question is, where are the actual modified DLL's that are mentioned, all I can see are the DLL's in the install directory and those targetting specific versions.

C:\Program Files (x86)\Progress\Telerik Reporting R2 2021\Bin

I have copied the exact DLL from the build running locally on my machine and still have this problem.

Hi,

I'm trying to pass a parameter value to the sql query like described in the KB article. Sample:

SELECT * FROM Person.Contact WHERE FirstName = @FirstName
This works fine, but if I try with a multi valued parameter, the query gives no results:
SELECT * FROM Person.Contact WHERE FirstName IN (@FirstName)
Any ideas? Thanks in advance.

Hi, 

I would like to know if Telerik Reporting tool able to generate excel that have multiple worksheets? If yes, can each worksheet tab name be customised?

Thank you.

Hi, I am looking into several frameworks to be able to run app in offline mode in mobile devices (Windows app, Android App).

My requirement is to be able to load the .trdx telerik report template in mobile app in offline mode.

May I know which of below are supported?

1. Xamarin Forms
2. WPF
3. Blazor WebAssembly
4. Flutter
5. Angular (PWA)
6. Ionic (WebView)
7. React Native 
8. ReactJS (PWA)

I'm using Telerik Reporting 7.0.13.220.

When I create an HtmlTextBox on a report and set the CanGrow property to true, it will output the following HTML/CSS in the web viewer:

.s10 {font-family:Segoe UI;font-size:11px;color:Black;word-wrap:normal;white-space:nowrap;padding-left:0px;padding-right:1px;padding-top:0px;padding-bottom:-2px}

<div title="" class="htmltextbox1 .s10" style="position:absolute;overflow:hidden;left:634px;top:69px;width:363px;height:77px;">
  <div class="html-root" style="margin-top:0px;">
    <p class="s1">content</p>
  </div>
</div>

When the white-space attribute is set to "nowrap" longer lines in the HtmlTextBox are cut off and do not display properly.  When I remove the white-space attribute using Chrome's developer tools, the content displays correctly.  Since this CSS is coming from an .axd request and is generated from the web viewer's iframe, I cannot override this value.  Is there a workaround for this?

Code in Designer :

        Me.HtmlTextBox1.Name = "HtmlTextBox1"
        Me.HtmlTextBox1.Size = New Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9530130624771118R), Telerik.Reporting.Drawing.Unit.Inch(0.34999999403953552R))
        Me.HtmlTextBox1.Style.BorderColor.Default = System.Drawing.Color.LightGray
        Me.HtmlTextBox1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
        Me.HtmlTextBox1.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5R)
        Me.HtmlTextBox1.Style.Visible = True
        Me.HtmlTextBox1.Value = "<span style=""word-wrap: break-word;white-space: normal; "">{Replace(Fields.descr_corr_action_descr, ""&""" &
    ", ""&amp;"")}</span>"

descr_corr_action_descr this property is using two columns in database 

pls provide solution how  to remove white-space:nowrap; or provide any workaround solution 

I am having difficulty accessing report params on the backend in order to properly generate a report. I am able to generate a blank report. But the backend is not receiving the parameters from the angular tr-viewer

on the front I have a tr-viewer with params { MemberID: 59, Date: '3/31/2021', }

    #totalReport1
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="'http://localhost:1088/api/reportapi/'"
    [reportSource]="{
        report: 'ReportAssetAllocation',
        parameters: { MemberID: 59, Date: '3/31/2021' }
    }"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0"
    [ready]="ready"
    [viewerToolTipOpening]="viewerToolTipOpening"
    [enableAccessibility]="true"
>
</tr-viewer>

The report is generated in the C# constructor below

Please note that the way data is being fetched below was with a previous version of this application which used angularjs and took in the parameters through http headers.

    public partial class ReportAssetAllocation : Telerik.Reporting.Report
    {
        public int MemberID { get; set; }
        public string Date { get; set; }

        public ReportAssetAllocation()
        {
            try
            {
                if (HttpContext.Current.Request.Headers.GetValues("memberID") != null)
                {
                    MemberID = Convert.ToInt32(HttpContext.Current.Request.Headers.GetValues("memberID")[0]);                     
                    Date = Convert.ToString(HttpContext.Current.Request.Headers.GetValues("Date")[0]);
                }
            }
            catch { }

            InitializeComponent();
        }

I want to modify this constructor to accept the params from the Angular tr-viewer but I have not had any success in doing this after trying multiple methods from other posts and documentation.

What is best way to access these reportSource parameters { MemberID: 59, Date: '3/31/2021', } in my C# file?

For reference, here is the report api controller just in case:

  public class ReportApiController : ReportsControllerBase
    {
        static readonly ReportServiceConfiguration preservedConfiguration;

        static ReportApiController()
        {
            {
                var resolver = new UriReportSourceResolver(HttpContext.Current.Server.MapPath("~/Reports"))
                    .AddFallbackResolver(new TypeReportSourceResolver()
                        .AddFallbackResolver(new TypeReportSourceResolver()));

                preservedConfiguration = new ReportServiceConfiguration
                {
                    HostAppId = "REPORTS",
                    ReportSourceResolver = resolver,
                    Storage = new Telerik.Reporting.Cache.File.FileStorage(),
                };
                var assemblyName = typeof(ReportCatalog).AssemblyQualifiedName;
                var namespaceOfClass = typeof(ReportAssetAllocation).Namespace;
            }
        }

        public ReportApiController()
        {
            this.ReportServiceConfiguration = preservedConfiguration;
        }
    }

Thank you

Hello,

When I tried to use 

            RenderingResult result = reportProcessor.RenderReport("XLSX", instanceReportSource, null);

The footer is not included in the excel. Why is that?

Thanks,

Arjay

We use the Report Designer to design a report that we want to access through the browser.
Does the Telerik Report service support Linux installation? What if I could include a link in my reply?

Here is my expression...

= IIF(ReportItem.Parent.DataObject.SoldtoAddress.CustKey = "ADEEL", "M3","") + Fields.RollID

As-is, the expression works. But, if the expression is false and I put anything in the empty quotes, the report won't run and gives the error, "Object reference not set to an instance of an object."

Am I doing something wrong? Thanks!

Ok - pulled my hair out for a couple of days testing out the telerik reporting - the report works as expected, but I am trying to get report viewer object and update the parameters from some bootstrap controls, but just get the following:

Uncaught TypeError: viewer.reportSource is not a function
    at HTMLButtonElement.<anonymous> (ReportViewer?type=4:37)
    at HTMLButtonElement.dispatch (jquery-3.6.0.min.js:2)
    at HTMLButtonElement.v.handle (jquery-3.6.0.min.js:2)

I have hardcoded the parameters to try and test - what I have in the page so far is as follows (using MVC).
It looks like jQuery cant find the report viewer by its id - some help would be appreciated here please and yes the code is quick and dirty :)

@model Platform.Code.ReportParamters

@{
    Layout = null;
}

@{
    TypeReportSource typeReportSource = Model.ParamReportSource;
    typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("YardID", Model.ParamYardID));
    typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("StartDate", Model.ParamStartDate));
    typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("EndDate", Model.ParamEndDate));
    typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("MovementCategoryID", Model.ParamMovementCategory));
    typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("Username", Model.ParamUsername));
}



<link href="https://kendo.cdn.telerik.com/2018.2.620/styles/kendo.common.min.css" rel="stylesheet" />
<link href="https://kendo.cdn.telerik.com/2018.2.620/styles/kendo.blueopal.min.css" rel="stylesheet" />
<script src="~/Scripts/jquery-3.6.0.min.js"></script>
<script src="@Url.Content("~/api/reports/resources/js/telerikReportViewer")"></script>


<div class="row">
    <button type="button" id="updateReport" class="btn btn-primary">Primary</button>
</div>


@(
    Html.TelerikReporting().ReportViewer()
        .Id("reportViewer")
        .ServiceUrl("/api/reports/")
        .ReportSource(typeReportSource)
        .ViewMode(ViewMode.Interactive)
        .ScaleMode(ScaleMode.Specific)
        .Scale(1.0)
)



<script>
    $(document).ready(function () {
        $('#updateReport').on('click', function () {
            var viewer = $('#reportViewer').data('telerik_ReportViewer');
            viewer.reportSource({
                report: viewer.reportSource().report,
                parameters: {
                    YardID: 1,
                    StartDate: '2020-06-21T00:00:01',
                    EndDate: '2021-06-21T23:59:59',
                    MovementCategoryID: 3,
                    Username: 'David Smith'
                }
            });
            //setting the HTML5 Viewer's reportSource, causes a refresh automatically
            //if you need to force a refresh for other case, use:
            //viewer.refreshReport();
        });
    });
</script>