Telerik Forums
Reporting Forum
0 answers
141 views

Hi ,

           we are creating dynamic report in that one of the columns contain 100 and above characters . so we set text wrap as true.

Result as 


If we set false for text wrap, then result as below

data not show as fully, 

Below the code that we create dynamic report Dim detailsTxt As New Telerik.Reporting.TextBox
                detailsTxt.Size = New SizeU(Unit.Inch(col.ColumnName.Length), Unit.Inch(0.2))
                detailsTxt.Location = New Drawing.PointU(Unit.Inch(iniLeft), Unit.Inch(0.01))
                detailsTxt.Style.Font.Size = New Unit(10)
                detailsTxt.Style.VerticalAlign = VerticalAlign.Middle
                detailsTxt.Style.TextAlign = HorizontalAlign.Left
                detailsTxt.TextWrap = False
                detailsTxt.StyleName = "Data"
                detailsTxt.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid
                detailsTxt.CanGrow = True
                detailsTxt.KeepTogether = True
                detailsTxt.Multiline = True
                ' detailsTxt.Format = Format("{0:n}")
               detailsTxt.Value = "=Fields.[" + col.ColumnName.ToString & "]"
                detail.Items.Add(detailsTxt)

What we expect 


Pls reply with any solution, we are using Telerik version is 11.1.7.614  , is it new version fixed this bug ?

Thanks.

M Kumar
Top achievements
Rank 1
Iron
Veteran
 asked on 11 Oct 2021
0 answers
120 views

After updating old version of Reporting to the newest we get an error:

An exception has occurred while processing 'TableContent' item:
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Telerik.Reporting.Processing.Data.DataMember.<GetMembers>d__63.MoveNext()
   at Telerik.Reporting.Processing.GroupHierarchyWalker`1.WalkHierarchy(TGroup group, IDataMember parentData, Double distance, Int32 startIndex, Double& totalSize)
   at Telerik.Reporting.Processing.GroupHierarchyWalker`1.WalkHierarchy(IEnumerable`1 groups, IDataMember parentData, Int32 startIndex)
   at Telerik.Reporting.Processing.TableBuilder.Fill(IMultidimensionalDataSet resultSet)
   at Telerik.Reporting.Processing.Table.BindToData(IMultidimensionalDataSet result)
   at Telerik.Reporting.Processing.DataItem.ProcessItem()
   at Telerik.Reporting.Processing.Table.ProcessItem()
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement()
   at Telerik.Reporting.Processing.DataItem.ProcessElement()
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext)

 

This is happening when we add header to table

        protected void CreateSingleHeader(Unit columnWidth, string header, Table table)
        {
            Telerik.Reporting.TableGroup tableGroupColumn = new Telerik.Reporting.TableGroup();
            tableGroupColumn.Name = "Header1";
            table.ColumnGroups.Add(tableGroupColumn);
            table.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(columnWidth));
            var textboxGroup = new Telerik.Reporting.HtmlTextBox();
            textboxGroup.Style.Padding.Left = Unit.Cm(0.1);
            textboxGroup.Style.VerticalAlign = VerticalAlign.Middle;
            textboxGroup.Style.Font.Size = Unit.Point(10);
            textboxGroup.Value = header;
            textboxGroup.Size = new SizeU(columnWidth, Unit.Cm(1));
            tableGroupColumn.ReportItem = textboxGroup;
        }


 

Please advise how to resolve this issue?

Jan
Top achievements
Rank 1
 updated question on 08 Oct 2021
0 answers
236 views

I'm using a HTML5 Web Forms Report Viewer

Here is my code:

            var reportPackager = new ReportPackager();

            var reportInstance = new Report();

            using (var sourceStream = System.IO.File.OpenRead("PathToTRDPFile"))

            {

                reportInstance = (Report)reportPackager.UnpackageDocument(sourceStream);

            }

            var table3 = reportInstance.Items.Find("table3", true)[0] as Telerik.Reporting.Table;

            table3.DataSource = CreateDataTable(); //A function that returns a datatable

            var instanceReportSource = new InstanceReportSource { ReportDocument = reportInstance };

            this.reportViewer1.ReportSource = instanceReportSource;

The error that I got: 

Error CS0029 Cannot implicitly convert type 'Telerik.Reporting.InstanceReportSource' to 'Telerik.ReportViewer.Html5.WebForms.ReportSource'

Any idea on how to resolve this?

1 answer
110 views

I have a HTMLTextBox in my report... In design it the text appears correctly, but in run time some text appears on top of other text (as you can see in the image).

If I export this report to a PDF file, the text appears as it should.

What's the problem?

Is it a bug in ReportViewer? What can I do?

(I'm using Telerik Reporting R2 2021)

I appreciate your help. Greetings

 

Todor
Telerik team
 answered on 07 Oct 2021
1 answer
106 views

Hi,

I'm trying to install our application and one of the dependencies is Telerik.UI.for.AspNet.Core.  Our application is set up to work with version 2020.2.513 but when I build the app it automatically pulls down version 2021.3.914 (we're connecting through a feed).  The dependency is showing the warning that the app depends on 2020.2.513 and the approximate best version was found.  When I go to the Nuget Package Manager there are only three versions available, all from 2021.  Is it possible to pull down the specific 2020 version?

Thanks,

Nate

 

Karina
Telerik team
 answered on 05 Oct 2021
2 answers
749 views

Recently I created a report.  The report was linked to a stored procedure in MS SQL.  When I would fire off the SPROC the data would return.  One issue I had with my SPOC was 1 column name was duplicated.  I had for example "column_1" in my output twice.  I know this is a bad design on the query, but it's even worse that telerik report designer just returns "No page to display".

The report designer lacks error messages, or anything to point to where the issue was.  Your message of No page to display is to generic.

Today I'm working with another issue.  I have a SPOC with 1 field being outputted, when I run the query in SQL it works.  When I run the in the data source setup to execute top 10, it works.  When I run the report in Preview mode, the generic error No page to display.  I have found no event logs, no information as to where I can see where the designer is getting stuck or not liking the data.  

 

Todor
Telerik team
 answered on 05 Oct 2021
2 answers
774 views

Hello...

I have a report where pixel-accurate placement is critical. I understand the basic CanGrow functionality, how text boxes will grow with more data, how they will cause a panel to expand accordingly, etc. What I'm facing is a situation where I need to display ONLY upper-case letters or numerals toward the bottom of the panel, so there will be no descenders. I have the textbox set to CanGrow = False and CanShrink = False. But when I use a larger font (set dynamically), one that will display the characters properly in the report, the textbox DOES grow, causes the parent panel to grow, and destroys the rest of the report placement. 

You'll see in the attached partial screenshot of a preview that the item on the left has a textbox that has grown and caused the panel (in orange) to grow. What I believe it should do is NOT grow, even if that means it cuts off any descenders. Various threads and docs have said that a textbox would not grow with CanGrow set to false, but in this case it most definitely does. 

So... Is there a way to set a panel to a fixed size in some other way. I have every object in that panel set to CanGrow = False, but it does not seem to matter.  Can I set the Height programmatically in some way that will override the CanGrow internal logic? I've tried setting it in the Bindings, but it seems to get overridden.

I'm using Reporting R2 2021.

Any help is much, much appreciated!!! Cheers...

Brian Norris
Top achievements
Rank 1
Iron
 answered on 28 Sep 2021
1 answer
998 views

Hi, 

I was using Crystal Reports but we move to Telerik Reporting. 

I try to use Case stament or something similar.

Select {Command.ACTID}
Case 1   : "AAAAAAA"
Case 2  : "BBBBBBBB"
Case 3  : "<center>CCCCCCCCC<font face='symbol'>\</font>'

......

Case 21  : "<center>ZZZZZZZZZZ</br>(Tekrar Müzakere)"

But I could not find ant method to do this and tech dept. sont anzwer my ticket.

Dimitar
Telerik team
 answered on 27 Sep 2021
1 answer
449 views

Hi,

As per screenshot I attach, on the screen, users have to do some filtering then click on Generate button to show the report.

However, there is an intermittent issue when user generate report, which is "Document/refresh with ID 'xxx' not found". Users have to refresh the screen or click on Generate button again.

Please advise how can we resolve the issue.

Thank you.

 

Dimitar
Telerik team
 answered on 22 Sep 2021
1 answer
176 views
I would like to add marked zones to a Line Graph. I found this How-To as well as that but these links are referencing the obsolete Chart item.

 

How can I create a marked zone, similar to the ones shown in this example with the Graph item?

Marked Zone with Chart item

I couldn't find any hint regarding Marked Zonesin Telerik's documentation.

Any pointers into the right direction are highly appreciated. Thank you very much!

Todor
Telerik team
 answered on 22 Sep 2021
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?