-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: LovedJohnySmith
Message 2 in Discussion
Hi,
Good Day...
U may need to Create one Customized Webform
as per ur filter criteria, based on your selected filter criteria, filter
parameters should pass into report using
CrystalDecisions.Shared.ParameterDiscreteValue.
here is the sample code for tat...
rptSample objsample = new
rptSample();
CrystalDecisions.Shared.ParameterDiscreteValue
obj = new
ParameterDiscreteValue();
obj.Value = "Sample";
objsample.DataDefinition.ParameterFields["yourparameterfield"].CurrentValues.Add(obj);
if u wanna export this report into PDF, one
issue will arise called Parameter Not Found. so u better to use
TypedDataset instead of ParameterDiscreteValues. I hereby
give some codesnipets for tat...
rptSample
objSample= new
rptSample();
objSample.Database.Tables["Parameter"].SetDataSource(dsParam.Tables[0]);
CrystalReportViewer.ReportSource
= objSample;
Where dsParameter., u can create one temporary
datatable and append to this dataset... i mean
private
void
MakeParamTable()
{
//
Create a new DataTable.
System.Data.DataTable
dtParam = new
DataTable("ParamTable");
//
Declare variables for DataColumn and DataRow objects.
DataColumn
dcParam;
DataRow
drParam;
//
Create new DataColumn, set DataType, ColumnName and add to DataTable.
dcParam
= new
DataColumn();
dcParam.DataType
= System.Type.GetType("System.DateTime");
dcParam.ColumnName
= "FromDate";
//
Add the Column to the DataColumnCollection.
dtParam.Columns.Add(dcParam);
//
Create second column.
dcParam
= new
DataColumn();
dcParam.DataType
= System.Type.GetType("System.DateTime");
dcParam.ColumnName
= "ToDate";
//
Add the column to the table.
dtParam.Columns.Add(dcParam);
//
Add the new DataTable to the DataSet.
dsParam.Tables.Add(dtParam);
//
Create three new DataRow objects and add them to the DataTable
drParam
= dtParam.NewRow();
drParam["FromDate"]
= Convert.ToDateTime("12-12-2004");
drParam["ToDate"]
=Convert.ToDateTime("12-12-2004") ;
dtParam.Rows.Add(drParam);
dsParam.AcceptChanges();
}
here FromDate and ToDate are
the parameter fields in report.
I hope, this will quite clear idea for your
requirement.
Regards,
smith
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
