Telerik Forums
Reporting Forum
1 answer
91 views
Hi All,
I am binding a report to viewer using code at run time.
report details and header are displaying well.
I want to show sum/count summary information of all columns within report in  "GroupFooterSection".
I have written following code
Telerik.Reporting.ReportItemBase[] reportitmfooter = new ReportItemBase[ds.Tables[0].Columns.Count]; 
for (int i = 0; i < ds.Tables[0].Columns.Count; i++) 
 { 
//Fill the Group footer for show sum or count 
            Telerik.Reporting.TextBox txtGroupFooter = new Telerik.Reporting.TextBox(); 
            txtGroupFooter.Value = "=count([" + headcolumnname + "])"; 
            txtGroupFooter.Name = "Sum" + headcolumnname; 
            //textBoxDetails.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(xaxis, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(yaxis, Telerik.Reporting.Drawing.UnitType.Inch)); 
            textBoxDetails.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Cm)); 
            reportitmfooter[i] = txtGroupFooter; 
 
                  
 
 
//group footer 
        Telerik.Reporting.GroupFooterSection groupFootersection = new GroupFooterSection(); 
        groupFootersection.Height = new Telerik.Reporting.Drawing.Unit(0.2, Telerik.Reporting.Drawing.UnitType.Inch); 
        groupFootersection.Style.BackgroundColor = System.Drawing.Color.Blue; 
        groupFootersection.KeepTogether = true
        groupFootersection.Visible = true
        groupFootersection.Name = "rptGroupFooter"
         
        groupFootersection.Items.AddRange(reportitmfooter); 
        report.Items.Add(groupFootersection); 

Group Footer is not displaying on web.
Please provide help.

Thank you in advanced.
Milen | Product Manager @DX
Telerik team
 answered on 18 Nov 2009
7 answers
210 views
Hello,

I'm using a trial version of Telerik reporting. I have some reports created with active reports and i want to convert them into telerik format.
I have created a new item an I started to nevigate throught the wizard checking the convert from existing report radio button.
The problem is : the browse button is not active.
I have also try this
http://www.telerik.com/support/kb/reporting/general/converting-reports-from-various-versions-of-activereports.aspx
but it is still not active.
I don't understand what I'm doing wrong?

Gica
Svetoslav
Telerik team
 answered on 18 Nov 2009
1 answer
295 views
1) I understand that to have a default value for a parameter, it's ReportParameter rp.Value, even with MultiValue turned on. But there appears to be a select all choice when i use multivalue. How can i do this w/o throwing a  whole list of values to that field?

2) With the DateTime filter, is there a way to do a range of dates using 1 report parameter?

3)Is there a way to programmatically fix the size of field itself, I have a double parameter that's huge when I only need at most 4 chars in it?
Milen | Product Manager @DX
Telerik team
 answered on 18 Nov 2009
1 answer
219 views
Hi there
I just installed Telerik reporting Q2 2009 and I have a problem with new Table control ColumnHeadersPrintOnEveryPage
property. I want to bind a data source to my table programmatically. Its a simple table with 2 columns:(PersonnelID, PersonnelName). Here is what I do for data binding:


public Report5() 
 
InitializeComponent(); 
 
SqlConnection sqlConnection1 = new SqlConnection(); 
SqlCommand sqlSelectCommand1 = new SqlCommand(); 
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(); 
sqlConnection1.ConnectionString = myconnectionString; 
sqlSelectCommand1.CommandText = mycommand; 
sqlSelectCommand1.Connection = sqlConnection1; 
sqlDataAdapter1.SelectCommand = sqlSelectCommand1; 
 
this.table1.DataSource = sqlDataAdapter1; 
 


I use default rows and columns of table control and just in header row cells write the header text for each column and in details row bind each cell to it's related feild using "=Fields.FieldName". Every thing is ok and table shows my expected data but ColumnHeadersPrintOnEveryPage property doesn’t work Correctly and column header just appear in first page while this property is true. When I use a TableWizard and a sqlDatasource as Datasource this property work correctly and column headers appear in every page. I search forums and read documents but can't find any solution. Is this a bug or I'm in a wrong way?
Milen | Product Manager @DX
Telerik team
 answered on 18 Nov 2009
2 answers
102 views
Hi

I'm attempting to position my labels for marked zones outside the PlotArea, but I can't see how to do it. Basically my problem is the labels get obscured by the first bar and as they get printed behind the bar I can't see them (if the bar is smaller I can see the labels - however, the first bar always has to be the largest so I'll never see the labels!)

Can I position the labels outside the PlotArea? Alternatively, is there a way to increase the padding between the edge of the PlotArea and the first bar in order for me to see the labels?

Thanks
Rob
Rob
Top achievements
Rank 1
 answered on 18 Nov 2009
2 answers
201 views
Hi,

I just created a few simple reports, used the query builder (data preview shows some records, so data config is ok), specified groups, items etc. When i press preview or just show report on website, it shows no data. I followed a tutorial from learning guide.
Please help, i need to show a report it to customer tomorrow..

Sample solution (using AdventureWorks database)- http://vitexner.eu/testpp.zip

Best regards

Vit Exner
Exi
Top achievements
Rank 2
 answered on 17 Nov 2009
3 answers
653 views

For my application I need to build report parameters programmatically.  I have tried to follow the examples available but I cannot get the parameters to display as a dropdown list of values.  The parameter does show up in the viewer but as a textbox.  Below is the code that I am using to build my parameter -  

 

 

Dim vals As New ArrayList   
 <fill vals with strings of option values> 
 
Dim param As New ReportParameter   
param.Type = ReportParameterType.String  
param.UI.Visible = True   
param.UI.MultiValue = True   
param.Value = vals   
   
Me.ReportParameters.Add(param)  
 
 

This is wrapped in a routine that is called when the report is bound to it's data source.  When I try to call the routine from the report's constructor it results in a run-time error.

My questions are:
1. How do I get my options to show up as a dropdown list?
2. When should this routine be called? 
3. Is it possible to build it with a value/key pair rather than just a list of values? 

----------------------------------------------------------------------------------------------------------------
Upon further investigation, either programmatic definition of parameters is not supported or the documentation is severely lacking because I have tried every example (there are just a few) that I can find and it either results in no parameter or a run-time error.  For example, just trying to add a simple test parameter with the following code results in no parameter in the viewer:

    Public Sub New()  
        InitializeComponent()  
        ReportParameters.Add("Test", ReportParameterType.String"test")  
    End Sub 

Thanks,
Dave

 

 

 

 

 

 

 

Kristy
Top achievements
Rank 1
 answered on 17 Nov 2009
1 answer
193 views
Hi,

I have a table in wich the datasource is loaded in the NeedDataSource event.  It's using a Stored Procedure wich requires as parameter a value that is available in the main report.  How do I access this value ?

I want to either get the value of textbox txtIndividualId or the field IndividualId from the Reports datasource...

Thanks

private void MyTable_NeedDataSource(object sender, EventArgs e)  
{  
    SqlCommand sqlSelectCommand = new SqlCommand  
                                      {  
                                            CommandText = "SP_MyStoredProc",  
                                            Connection = new SqlConnection {ConnectionString = ConnectionString},  
                                            CommandType = CommandType.StoredProcedure  
                                      };  
    sqlSelectCommand.Parameters.Add("@individualId", SqlDbType.Int);  
    sqlSelectCommand.Parameters["@individualId"].Value = txtIndividualId.Value; //This is incorrect  
      
    Telerik.Reporting.Processing.Table tbl = (Telerik.Reporting.Processing.Table)sender;  
    tbl.DataSource = new SqlDataAdapter { SelectCommand = sqlSelectCommand };  
}  
 
Steve
Telerik team
 answered on 17 Nov 2009
1 answer
120 views
I'm having an issue when exporting a report to pdf. The Pie chart mirrors itself. Any ideas?
Steve
Telerik team
 answered on 17 Nov 2009
1 answer
124 views
Hi,

My question is does Telerik Report can use LINQ like integrated Datasource ?

Z. Rusev
Steve
Telerik team
 answered on 16 Nov 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?