Questions on Reporting Forum

1 answer

109 views

Hi,
         I am using Telerik Reporting Q2 2008 service. I want to generate tabular reports by using Crosstab & Table reporting controls.
I want to know how to add these controls in toolbox? Also I want to know how to add & work with crosstab & table wizards?
Which DLL's should I add to work with these contols?
          Please reply....

General Discussions

answered on 17 Jul 2009

3 answers

239 views

Unable to convert ActiveReports reports

I am trying to convert some of our reports from ActiveReports (5.2.1013.2) to Telerik Reports (Q1 2009). While using the Telerik Report Wizard, I am able to select ActiveReports from the Available Converters and browse to the dll that contains the ActiveReports reports. After I select the dll, no reports appear. Please provide some insight on this problem.

General Discussions

answered on 17 Jul 2009

1 answer

393 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

327 views

[Solved] 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

125 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

317 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

349 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

597 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

206 views

[Solved] 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

167 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