Hi

I am new to reporting and have looked at using either crystal and Telerik.  I have to say that as a newcomer TR is many times more intuitive than CR.  However i am a little stuck on how to approch a problem.

I want to produce a grid type layout based on a users request at runtime.  The layout is just header rows and detail rows.  However i do not know how many columns there will be.  Ther could be as few as three or as many as 8.  The data requested by the user contains the number of columns and the approprate widths of each coumn.  This was made to work by a progammer using vb6 and CR by creating a grid of 10 columns and hiding the unwanted ones at runtime.

However, i guess we could add the columns at runtime using code behind.  Unforrtunately there is very few examples for me to look at.  Can someone provide some examples of adding columns programmatically to simple header detail table.

Is it posible using the group structure to do this without code behind.  So that the table automatically adds the headers along the top creating as many columns as neccessary and then places the row data below?

My Table
Header 1	Header 2	Header 3	…	Header x
Row 1 detail 1	Row 1 detail 2	Row 1 detail 3	…	Row 1 detail x
Row 2 detail 1	Row 2 detail 2	Row 2 detail 3	…	Row 2 detail x
Row 3 detail 1	Row 3 detail 2	Row 3 detail 3	…	Row 3 detail x
Row 4 detail 1	Row 4 detail 2	Row 4 detail 3	…	Row 4 detail x

Many thanks

Al

I'm getting my data for the chart from a linq query


And setting the data in NeedDataSource


where chartColumn is OrderTotal, Profit, Costs, or Orders depending on the chart.  The DefaultLabelValue I understand is getting ignored because of the DataLabelsColumn.  Is there a way to supply the "#Y - #%" to the chart along with the DataLabelsColumn as it would be needed for the label as well?

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

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!

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.

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

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

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

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?

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