Questions on Reporting Forum

1 answer

320 views

List of Supported HTML tags supported by Telerik Reports HTMLTextBox

Where can I find a detailed list of the HTML tags supported by the HTMLTextBox control in Telerik Reports? I need to write a converter program to convert text stored as RTF to HTML and would like to limit the output to only tags that Telerik Reports will support.

Thanks in advance!

General Discussions

answered on 17 Jul 2009

3 answers

276 views

Setting ReportParameter member values in code

I am not finding any examples in the documentation on this.

I have two report parameters, and I want to populate their values in the code-behind. The first one to be populated with a static (string) list. The second one to be populated from a SQL datasource.

Can you point me towards some sample code for this?
Thanks

Dan

General Discussions

answered on 16 Jul 2009

1 answer

97 views

Generating Series programatically

Hi,

I am binding the Table to Barchart programmatically.

ID Status Value Type

--------------------------------------------------

1 Status1 100 Type1

2 Status2 300 Type1

3 Status3 200 Type2

4 Status1 400 Type2

5 Status2 400 Type2

6 Status3 200 Type2

My requirement is

a) Status should be series.

b) Type should be grouped in X axis

c) Value should be in Y axis

Kindly please tell me how to do this?

Regards,

Jones

General Discussions

answered on 16 Jul 2009

1 answer

262 views

Trying to bind textbox to an arraylist

I have a dataset that contains multiple tables in it. What I want to do is find a way to take the values(and when I say "values" I do mean the plural "values") from a column within one table of the dataset and display them in a textbox. When I try to feed the values into an arraylist the values do not display correctly in design time. (Just shows the namespace object in the preview tab of VisualStudio) When I add the values to a string, I get the last value in the column which doesn't help me but it at least means I can iterate through the column values. Any idea as to how to make this work? How to get all the values in the column and bind to a textbox value. Below is the code i'm trying to use.
-Jason

    
               SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=cmdiapp;Password=adiadmin");  
        
                        SqlCommand selectCommand;  
        
                        connSomsys.Open();  
        
                        selectCommand = new SqlCommand("sprocgetProductListQuoteTotals", connSomsys);  
        
                        selectCommand.CommandType = CommandType.StoredProcedure;  
        
                        SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);  
        
                        DataSet dataSet = new DataSet();  
        
                        adapter.Fill(dataSet);  
        
                        ArrayList myAL = new ArrayList();  
        
                        DataTable tbl = dataSet.Tables[1];  
        
                        for (int i = 0; i < tbl.Rows.Count; i++)  
        
                        {  
        
                            DataRow myRow = tbl.Rows[i];  
        
                            myAL.Add(myRow["ProductList"].ToString());  
        
                        }  
        
                          textBox4.Value = myAL.ToString();

General Discussions

answered on 15 Jul 2009

1 answer

295 views

Trying to calculate percentage on the fly

I have three textboxes(textbox1,textbox2,textbox4). Am trying to calculate the percentage of textbox1.value to textbox3.value. Want to display the percentage in texbox4 on the fly. Is there an easy way to do this? it currently tells me the input string is not in correct format. Have tried numerous things. Any direction would be greatly appreciated. See code below.

Jason

    
                        SqlConnection connSomsys = new SqlConnection(@"Server=cmdivst004\Jason08;Integrated Security=false;Database=QuoteDB; Persist Security Info=True;User ID=cmdiapp;Password=adiadmin");  
        
                        SqlCommand selectCommand;  
        
                        selectCommand = new SqlCommand("sprocgetQuoteProductTotals", connSomsys);  
        
                        selectCommand.CommandType = CommandType.StoredProcedure;  
        
                        SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);  
        
                        DataSet dataSet = new DataSet();  
        
                        adapter.Fill(dataSet);  
        
                        this.DataSource = dataSet;  
        
                        this.DataMember = "Table";  
        
                        this.textBox3.Value = dataSet.Tables[1].Rows[0][0].ToString();  
        
                        int textbox1val;  
        
                        int textbox3val;  
        
                        textbox1val = Convert.ToInt32(this.textBox1.Value);  
        
                        textbox3val = Convert.ToInt32(this.textBox3.Value);  
        
                        decimal percent = (textbox1val * 100) / textbox3val;  
        
                        string textbox4val = Convert.ToString(percent);  
        
                        this.textBox4.Value = textbox4val;

General Discussions

answered on 15 Jul 2009

3 answers

557 views

NeedDataSource event not firing when updating the ReportViewer

Hello,

I upgraded to Telerik Reporting Q2 2009 and my reports are encountering an issue. I have a button on the page that sets the parameters for the report and updates the ReportViewer. However, since I upgraded to Q2 the NeedDataSource event is not firing. If I use Q1 it works fine. I have to use Q2 because Q2 has a fix regarding the page count issue.

ASPX:
1) the aspx has checkboxes and dropdowns so the user can have different options when running the report.
2) View Report button that when clicked assigns the report parameters and sets the report to the reportviewer, just like the examples.

Report NeedDataSource:
Here I would dynamically get the data and show or hide sub reports based on the parameters that were passed. I would also be able to store the previous datatable/dataset by using a global variable so that I could reuse some data if there were no change, and only generate new data that is needed.

As with Q2 the NeedDataSource event is only fired the first time the button is pressed. The second time the button is pressed, I only get to :

Public Sub New()
InitializeComponent()
End Sub

I have also tried : Me.DataSource = Nothing after InitializeComponent() but that didnt help.

Thanks for any assistance.

General Discussions

answered on 15 Jul 2009

4 answers

187 views

pie chart

Hi everyone,

i am trying to get a pie chart like those shown on this example or this one with a legend or serie that would associate a colour with a name.

My problem is that those names are not fixed so i would like to attribute them during runtime. I already use NeedDataSource event for populating the datasource.
Do you have an example where that legend of a pie chart is populating depending of what is in the datasource at run time?

I get trought the documentation but i must have missed something (I am not even sure that it's legend or what and most of the example are with bar chart).

Thank you

regis

General Discussions

answered on 15 Jul 2009

1 answer

136 views

Grouping and template column issues with RadGrid client-side binding

Hi,

I am trying to bind a grid from client-side. And it works fine, if it is a plain grid with GridBoundColumns. If my grid has grouping functionality, it does not work. The data is bound but grouping never works. Also, if I am using a template column, with a link button in it, the data is not bound to that column. Can you please help me on this?

Thanks.

General Discussions

answered on 15 Jul 2009

1 answer

152 views

DataSet bind to Chart

Hi,

In C# .Net 3.5, I have a DataSet that I would like to Bind to a horizontal Telerik Reporting Bar Chart.

The DataSet data essentially contains 2 column fields, NameOfGroup and NumberOfHits.

So for example, a name of a group could be "The Beatles" and the number of hits could be 43.

Another row in the DataSet could be "Led Zeplin" and the number of hits could be 22.

As my DataSet data comes from a Store Procedure which does a SUM of "Hits" and groups by group name I will be adding more groups and new hits to the database.

How do I build a Reporting Chart that will automatically represent dynamically the number of horizontal bars to the number of Groups I have in my DataSet. My Hits column will be the length of the bars.

Any online examples would be most appreciated.

Thanks

David

General Discussions

answered on 15 Jul 2009

1 answer

130 views

Getting an extra empty when i assigned pagebreak=after

Hi,

I have huge recrods in the reports and one of the column i am using for grouping. I assigned a "pagebreak=After" for the customers groups(which i used for groupding). Everything works well but the last page is empty. I am getting a empty page at the end.

Moreover "GroupKeepTogether=None".

Thanks.

Regards

Arshad

General Discussions

answered on 14 Jul 2009