This is a migrated thread and some comments may be shown as answers.

Custom Report Parameter Interface

6 Answers 316 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

6 Answers, 1 is accepted

answered on 15 Feb 2010, 11:23 PM

Hey Steve.

I am in the process of working on dynamically creating parameters per your suggestion and I am struggling a bit with the dynamic aspect of the data sources for each of the parameters. For example, based on the selected report, I will have different parameters.

I have create a report parameter base class and a report specific parameters class to help with this.

public class ReportParameter

{

public string Name { get; set; }

public string DataSource { get; set; }

public string ValueMember { get; set; }

public string DisplayMember { get; set; }

public Telerik.Reporting.ReportParameterType ParameterType { get; set; }

public bool MultiValue { get; set; }

public bool Visible { get; set; }

public ReportParameterControlType ControlType { get; set; }

}

public class Report1_ReportParameters

{

public List<ReportParameter> rpReportParameters { get; set; }

public Report1_ReportParameters()

{

rpReportParameters =

new List<ReportParameter>();

ReportParameter rpPerson = new ReportParameter();

rpPerson.Name =

"Person";

rpPerson.MultiValue =

true;

rpPerson.ValueMember =

"PersonContactInfoId";

rpPerson.DisplayMember =

"Name";

rpPerson.Visible =

true;

rpPerson.ControlType =

ReportParameterControlType.MultiSelect;

rpPerson.DataSource =

"BLPerson.SelectPossibleContactsByCompany";

rpReportParameters.Add(rpPerson);

ReportParameter rpCreatedBy = new ReportParameter();

rpCreatedBy.Name =

"CreatedBy";

rpCreatedBy.MultiValue =

false;

rpReportParameters.Add(rpCreatedBy);

}

public class Report2_ReportParameters

...

My initial thought was to create a delegate that would set the datasource for each parameter as needed. Did you run into this and if so, how did you deal with it?

Thanks, Mike

answered on 15 Feb 2010, 11:35 PM

We have DB tables to create them dynamically here...

Tables:
1) Stores the reports
2) Stores the parameters (type to render, ie text or dropdown, etc...)
3) Link Table to add X parameter to X report
4) Value table to add in items to the parameter selectors

The parameter interface just loops through the link table and creates the controls based on their type, then adds in the values they need from the value table.

So we can add\remove parameters or values with a quick DB change