Telerik Forums
Reporting Forum
4 answers
88 views
Hi,

I would like to export a treeview in a report.
I have to do a page-break in some cases between my nodes.. I read that's not possible to do a page-break programmatically !

How can I solve this problem ?? Any idea ??

Thanks a lot

Cheers,
David
David Chételat
Top achievements
Rank 1
 answered on 28 Sep 2009
3 answers
939 views
I have a main report that contains quite a few subreports. The outline of the main report is below:

------------------------------------
SUBREPORT 1
SUBREPORT 2
SUBREPORT 3

When I generate the report, if SUBREPORT1 does not contain any data I expect the rendered report to look like:

--------------------------------------
SUBREPORT2 DATA
SUBREPORT3 DATA

However, what I am getting rendered is similar to below:
------------------------------------

SUBREPORT 2
SUBREPORT 3

I want SUBREPORT2 to move up closer to the line if SUBREPORT1 does not get rendered. How do I accomplish this? I've played around with the CanGrow and CanShrink properties but that does not seem to solve the issue? Can this be done? Thanks!
PJ Rodriguez
Top achievements
Rank 1
 answered on 27 Sep 2009
3 answers
282 views
Hi all

I am using DataSet as datasource and within each record it has ExtendedProperty. The only way to utilise this, I have to do in ItemDataBinding event doing some manipulatation.

In detail, I have DataTable that I pass to Telerik Reporting class. I believe I need to do the manipulation on the ItemDataBinding so I register that.
Here's my DataSet looks like:

KeyUser; Weight, 705; 707; 709; 711; 713; 715; 717; 721; 723     >> FieldName
User1; 10; A; B; C; D; A; B; C; D; A; B;                                            >> Record1 
User2; 20; B; C; D; A; B; C; D; A; B; C;                                            >> Record2
User3; 30; C; D; A; B; C; D; A; B; C; D;                                            >> Record3


705; 707; 709; 711; 713; 715; 717; 721; 723 are dynamics heading which is mapped to Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10. These field name could be different depending on the query.

We put this mapping under the ExtendedProperties within DataSet that we have.

In the report designer, I set in such a way in the detail section of the report, I put name the textbox as follow:

txtbxdtlKeyUserValue
txtbxdtlWeightValue
txtbxdtlAnswer1Value
txtbxdtlAnswer2Value
txtbxdtlAnswer3Value
txtbxdtlAnswer4Value
txtbxdtlAnswer5Value
txtbxdtlAnswer6Value
txtbxdtlAnswer7Value
txtbxdtlAnswer8Value
txtbxdtlAnswer9Value
txtbxdtlAnswer10Value

So my question is now how do I loop through recordset in my DataSet in order to fill in to these textboxes (in Telerik Reporting) ?

Heres my sample MostPreferredReport class report.

namespace EUCTVIReports   
{   
    using System;   
    using System.ComponentModel;   
    using System.Drawing;   
    using System.Windows.Forms;   
    using Telerik.Reporting;   
    using Telerik.Reporting.Drawing;   
   
    /// <summary>   
    /// Summary description for MostPreferredReport.   
    /// </summary>   
    public partial class MostPreferredReport : Telerik.Reporting.Report   
    {   
        public MostPreferredReport()   
        {   
            /// <summary>   
            /// Required for telerik Reporting designer support   
            /// </summary>   
            InitializeComponent();   
            ItemDataBinding += new System.EventHandler(MostPreferredReport_ItemDataBinding);   
        }   
   
        public DataTable Source   
        {   
            get   
            {   
                return this.Source;   
            }   
            set   
            {   
                this.DataSource = value;   
            }   
        }   
   
        void MostPreferredReport_ItemDataBinding(object sender, System.EventArgs e)   
        {   
            // SEE: http://www.telerik.com/help/reporting/faq-combine-values2.html   
   
   
            //Telerik.Reporting.Processing.DetailSection section = (Telerik.Reporting.Processing.DetailSection)sender;   
            //System.Data.DataRow row = (System.Data.DataRow)section.DataObject.RawData;   
            //if ((row["ProductName"] != null) && (row["ProductName"].ToString().Length != 0))   
            //{   
            //    Telerik.Reporting.Processing.TextBox procTextbox = (Telerik.Reporting.Processing.TextBox)section.ChildElements.Find("productNameDataTextBox", true)[0];   
            //    procTextbox.Value = row["ProductCategory"].ToString() + " " + row["ProductSubCategory"].ToString();   
            //}   
   
        }   
    }   
}  


I am appreciated your comment.

Steve
Telerik team
 answered on 25 Sep 2009
1 answer
250 views
I have a customer that reports that when they render a report, the CPU on the server spikes to 100%. They are not too worried about the CPU usage in itself (it is a big report and they know it will take some time to render). But they ARE concerned that the report generation is consuming so much CPU that other interactive requests to the server cannot be quickly serviced.

Is there a way to limit the amount of CPU used or to set the thread priority to lower than normal for the thread that is servicing the render request? In .NET, I know you can set a thread's priority before starting the thread, but can it be changed once the thread has started? I am thinking that in the NeedDataSource callback for my report I could set the current thread's priority to belowNormal, but I don't know if there will be unwanted side effects. I am assuming that the thread that services the render request is a normal IIS-provided thread and that when it is done servicing the rendering request it will exit (thus, the low priority setting of the thread won't affect any other requests since the thread won't be servicing any other requests).

Has anyone tried limiting the cpu usage of a rendering request?

Thanks,
-Eric

keywords: Telerik Reporting Performance
Svetoslav
Telerik team
 answered on 25 Sep 2009
1 answer
187 views
I'm making a SSCC barcode using EAN128 symbology and i'm having trouble inserting the end of field character for a concatenated barcode.

Example:   (01)12345678901234(37)20(10)09092559725

I need a FNC1 character which scans as "F1" after the quantity of 20. <GS> or Chr(29) does not conform to the customer's standards and Chr(200) is an invalid character. It seems the "StartC" and "F1" characters are inserted automatically to the start of the barcode. I just need to know what the ascii code or string representation for the "F1" character is, please.

Charlie
Ivan
Telerik team
 answered on 25 Sep 2009
1 answer
44 views
Hello

A while back someone said they'd heard you were going to bring out a report creator that a web/win user can use to design their own reports.

I cannot find anything about this on this site, so I am wondering if I am missing something or this person misunderstood?

Thanks

Bex
Steve
Telerik team
 answered on 25 Sep 2009
7 answers
282 views
Hello,
I'm trying to have a page count based on the gruping I've set on a int, if I exceed a page (considering header and footer) I wish to reset the number of the page to 1... for example page 1/2...page 2/2 for user "aaa", then page 1/1 for user "bbb" and so on... how can I achive this?
Michele
Top achievements
Rank 2
 answered on 25 Sep 2009
1 answer
59 views
Hello,

          I am using RadSchedular in my application.
          Now i want to open new aspx page in Popup window, when i click on any of the date region inside RadSchedular.

          I want new page to be open inside PopUp on this event.
          Also i want to remove the small popup which opens when we click on specific date inside radschedular.

          IS it possible to do so?
          Its very important for me to do so.

          Please reply me as soon as possible.




Thanks,
Kunal

        
        
Peter
Telerik team
 answered on 25 Sep 2009
2 answers
85 views

 

hi!  I have create chart using xml data...I have use below code in chart need datasource event... I have get the output as pichart with salesorpurchasedesc column...But Now I want the output piechart with labels as itemlineamount data but this data in percentage format...and each salesorpurchase desc data left side of the pie chart that referring each itemline amount data..please help me...

chart needdatasource event
string
fileName = @"D:\text\jccantera\jccantera\jcc.xml";

 

 

var reader = new StreamReader(fileName);

 

 

XmlSerializer serializer = new XmlSerializer(typeof(NewDataSet));

 

 

var report = (NewDataSet)serializer.Deserialize(reader);

 

Telerik.Reporting.Processing.

Chart procChart = (Telerik.Reporting.Processing.Chart)sender;

 

 

DataSet ds = report;

 

procChart.DataSource = ds.Tables[

"BillItemLine"];

 

 

ChartSeries series = new ChartSeries();

 

series.DataYColumn =

"ItemLineAmount";

 

series.DataLabelsColumn =

"SalesOrPurchaseDesc";

 

series.Appearance.ShowLabelConnectors =

true;

 

 

JCChart.Series.Add(series);

 

procChart.DataSource = ds.Tables[

"BillItemLine"].DefaultView;

 

JCChart.DefaultType = Telerik.Reporting.Charting.

ChartSeriesType.Pie;

Xmldata

 

<

NewDataSet>

 

<

BillItemLine>

 

<

ItemLineAmount>844.35</ItemLineAmount>

 

<

ItemLineItemRefListID>350000-1247582799</ItemLineItemRefListID>

 

<

EstimateKey>Plan 804-1:804-1-502</EstimateKey>

 

<

Plan>804-1</Plan>

 

<

HouseAddress>3341 West Avenue, Beaumont</HouseAddress>

 

<

EstimateLineAmount>6000</EstimateLineAmount>

 

<

Name>804-1-502</Name>

 

<

SalesOrPurchaseDesc>Foundation Labor</SalesOrPurchaseDesc>

 

</

BillItemLine>

 

<

BillItemLine>

 

<

ItemLineAmount>84.87</ItemLineAmount>

 

<

ItemLineItemRefListID>370000-1247585073</ItemLineItemRefListID>

 

<

EstimateKey>Plan 804-1:804-1-633</EstimateKey>

 

<

Plan>804-1</Plan>

 

<

HouseAddress>3341 West Avenue, Beaumont</HouseAddress>

 

<

EstimateLineAmount>300</EstimateLineAmount>

 

<

Name>804-1-633</Name>

 

<

SalesOrPurchaseDesc>Portalet</SalesOrPurchaseDesc>

 

</

BillItemLine>

 

 



Steve
Telerik team
 answered on 25 Sep 2009
1 answer
236 views

Hello Telerik team,

To achieve the number of records for a group footer or a Report footer we used =Count(‘fieldname’)

 

But I have a scenario where in I need to count only unique values for my number of records for both Group Footer and Report Footer.

 

For example:

I'm printing a report for leave applications

 

1 employee applied a 5 days leave in one transaction (The transaction was tag with an ID)

So I got 5 Rows with Same ID.

 

When I try to display a report it will always show me 5 records which is correct, but how do I count the unique ID? I dont want my number of record to be counted as 5 records instead I want the count of the unique ID.


Steve
Telerik team
 answered on 25 Sep 2009
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?