Questions on Reporting Forum

1 answer

111 views

Hello,

Just like to ask, does telerik support sorting for other culture like SQL does (Through Collation)? Example for Taiwan culture it sorted by strokes and for china it sorted by pronunciation using SQL. If not, does telerik intend to cater for this?

Thanks.

General Discussions

answered on 20 Jul 2009

3 answers

201 views

ReportParameters Collection Editor and Constants

I've noticed that, when entering a parameter's value within this editor dialog, if you use the "Edit Expression" screen to generate the value's new text then it automatically puts an equals sign, '=', at the beginning of both the boolean constant values. This seems to cause the text to be treated as a string rather than as a boolean, and it gives you an "unable to convert string to a boolean" error, (or similar), as it's trying to parse the text "=True" into a boolean.
Removing the equals sign resolves the error, but as it took me a while to realise this I wanted to let everyone else know, and also to see if Telerik are aware of this.

Paul

General Discussions

answered on 20 Jul 2009

1 answer

94 views

Reporting controls:CrossTab & Table

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

203 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

355 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

292 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

106 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

275 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

309 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

576 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