Telerik Forums
Reporting Forum
1 answer
144 views

Hi there.

I have a multivalued parameter called of type int called "Person". With that in mind, I have 2 questions:

1. How do I pull the data out programmatically? Basically, I want to do something like this:

foreach (int personId in (List)this.ReportParameters["Person"].Value)
{
    myList.Add(personId);
}

I can't quite figure out how to get at the collection and extract the values.

2. Along those same lines, how would I programmatically populate a multivalue parameter?

Thanks, Mike

Michael Love
Top achievements
Rank 1
 answered on 20 Nov 2009
9 answers
226 views
The parameter box disappears when I have a dropdown parameter after pressing preview and data is not retrieved. It disappears even when there are other parameters in the box (all input types). It works with multi-select, but I cannot use that with the reports I'm trying to generate. The datasource is currently a LINQ object. It also happens with data I grab using the built in wizard.

Help!

namespace Reporting 
    using System; 
    using System.ComponentModel; 
    using System.Drawing; 
    using System.Windows.Forms; 
    using Telerik.Reporting; 
    using Telerik.Reporting.Drawing; 
    using IRWLReporting_Rules; 
 
    /// <summary> 
    /// Summary description for Report1. 
    /// </summary> 
    public partial class ActivityRegistrationReport : Telerik.Reporting.Report 
    { 
        public ActivityRegistrationReport() 
        { 
            /// <summary> 
            /// Required for telerik Reporting designer support 
            /// </summary> 
            InitializeComponent(); 
 
            try 
            { 
                this.ReportParameters["ActivityId"].UI.AvailableValues.DataSource = new Reporting_Rules().GetActivityDataForReportParamDropdown(); 
            } 
            catch (Exception ex) 
            { 
                throw ex; 
            } 
        } 
 
        private void ActivityRegistrationReport_NeedDataSource(object sender, EventArgs e) 
        { 
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender; 
 
            report.DataSource = new Reporting_Rules().GetActivityRegistrantsForActivityReport(Convert.ToInt32(report.Parameters["ActivityId"])); 
        } 
    } 

Hrisi
Telerik team
 answered on 20 Nov 2009
1 answer
70 views
Hello,

Please clarify:

I see from the documentation that there is an ActiveRegion Class defined for Telerik.Reporting.Charting, but not supported?
http://www.telerik.com/help/reporting/telerik.reporting-telerik.reporting.charting.activeregion.html

For example, I can't seem to be able to set series item tooltips, URLs, etc.

Thanks,
Jon
Chavdar
Telerik team
 answered on 19 Nov 2009
2 answers
359 views
Hello there,

I am creating a report whose datasource is an array of a custom object. I am displaying properties from my custom objects in text boxes successfully, however I also want to populate a table from a collection that is a property on my custom object.

If I use the NeedDataSource of the table I can't see how to access the current business object from the report's data source. If I try the following in the itemDataBinding the table does not get populated with any data:

        private void detail_ItemDataBinding(object sender, EventArgs e) 
        { 
            Log.Debug("detail_ItemDataBinding"); 
             DetailSection section = (DetailSection) sender; 
            MyObject c = section.DataObject.RawData as MyObject ; 
            tblHistory.DataSource = c.History; 
        } 

Please can anyone advise where I am going wrong?

Many thanks, Carl
Svetoslav
Telerik team
 answered on 19 Nov 2009
2 answers
198 views
Hi,

  I have added "Lab Name"  as X-axis Items in the bar and Line chart.The label is cut off of if more than 30 characters

For example: if lab Name is "Angeline Elizabeth Kirby Memorial Health Center", It is showing as "Angeline Elizabeth Kirby Memor...".

i would like to show the full name in x axis without ...

How to show the x axis label without overlap and cut off?


Thanks for any help,
Vladimir Milev
Telerik team
 answered on 19 Nov 2009
1 answer
108 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
287 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
341 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
270 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
132 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
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?