Telerik Forums
Reporting Forum
1 answer
360 views

When I start the telerik report designer I get this error message:

Clicking ok opens the designer but in the main screen I see:

Telerik.Reporting.Xml.XmlSerializerExcepion: An error has occurred during xml serialization. The xml serializer cannot resolve type with name: Report
   at Telerik.Reporting.Xml.ObjectXmlReader.ReadXmlElement(String name)
   at Telerik.Reporting.Xml.ObjectXmlReader.Deserialize()
   at Telerik.ReportDesigner.Packages.ReportDesigner.Serialization.ReportDesignerLoader.ReadReport()
   at Telerik.ReportDesigner.Packages.ReportDesigner.Serialization.ReportDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)

I don't think this error is related with a particular report because it shows every time I open the software.

I used the designer just few days ago and worked perfectly, what can I do? Thanks

 

Plamen Mitrev
Telerik team
 answered on 09 Jul 2021
1 answer
168 views

hi,

I have a question about Line chart. When all the data values are zero, the line is drawing at the axis line. I would like to adjust the axis line to less than zero automatically for this case. I have attached the existing and expected screenshots. 

How to set the Y axis scale minimum value to less than zero when all the data value are zero. 

Thanks in advance

 

Neli
Telerik team
 answered on 09 Jul 2021
4 answers
660 views

Hi

I'm developing an WPF app that imports trdx file, serializes to a report object, set an ObjectDataSource and generate (using RenderReport method) to pptx file.

The trdx file contains a subreport with the same DataSource but different DataMember. The DataMember of the subreport get an input from the a report parameter (=Parameters.Param1.Value). The subreport parameter filled by the main report (Param1 =Fields.Id).

For example, for each order in the report, the subreport get its ID as parameter and returns all its order details.

In the generated report (pptx) I see all the reports data but the subreport data is empty. How should I set the DataSource, DataMember and Paramerters of the subreport correctly?

 

Thanks

Michal

 

2 answers
346 views

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.

Christopher
Top achievements
Rank 1
Iron
 answered on 07 Jul 2021
1 answer
154 views

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.


Neli
Telerik team
 answered on 05 Jul 2021
1 answer
248 views

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.

 

Neli
Telerik team
 answered on 01 Jul 2021
1 answer
453 views

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)

 

 

1 answer
260 views

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 

2 answers
673 views

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

Joel
Top achievements
Rank 1
Iron
 updated answer on 28 Jun 2021
1 answer
646 views

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

Neli
Telerik team
 answered on 25 Jun 2021
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?