using Crystal Reports to display data in my dataset correctly (display the data I selected instead of all the data in table)

[JK]

In my win form, I'm trying to display a Crystal report with the data in my
dataset only but, if I follow the steps in this msdn page:

http://msdn.microsoft.com/library/de...tinaviewer.asp

it always displays all the data regardless of the Select statement I run.
Here's my code:

InitializeCompo nent();
//my code

CrystalReport1 oRpt = new CrystalReport1( ); //CrystalReport1. rpt - it
contais 3 fields from table ClientData: clientid, fname, lname

SqlConnection SQLConn = new SqlConnection(" Data Source=localhos t; Integrated
Security=SSPI;" +

"Initial Catalog=invoici ng");

string strThisQuery = "select clientid, fname, lname from ClientData where
clientID = 4"; /it returns only one record

SqlDataAdapter MyDataAdapterCl ients = new SqlDataAdapter (strThisQuery,
SQLConn);

DataSet DS_MyReportsDS = new DataSet();

MyDataAdapterCl ients.Fill(DS_M yReportsDS, "ClientData ");

oRpt.SetDataSou rce (DS_MyReportsDS );

crystalReportVi ewer1.ReportSou rce = oRpt;
It doesn't matter what my Select returns, it'll always display all the data
in ClientData. I posted a similar message a few days ago, and someone posted
this:
"If it contains the schema of all the columns, the CrystalReportVi ewer will
display all the data in the table regardless of your select." but I really
didn't understand what he meant. How would I be able to pass my Select
statement into the report?
Thanks.

[Steven Wood]

Hi.

One solution is to create a parameter in your Crystal Report (called
'ClientID') and set the properties at runtime in the code before setting the
Report Source, something like:

CrystalReport1 rpt = new CrystalReport1( );
ParameterFieldD efinitions paramFieldDefs;
ParamterFieldDe finition paramFieldDef;
ParameterValues paramVal = new ParameterValues ();
ParameterDiscre teValues paramDiscreteVa l = new ParameterDiscre teValues();

paramDiscreteVa l.Value = "4"; // the client id

paramFieldDefs = rpt.DataDefinit ion.ParameterFi elds;

paramFieldDef = paramFieldDefs. Item("ClientID" );

paramVal = paramFieldDef.C urrentValues;

paramVal.Add(pa ramDiscreteVal) ;

paramFieldDef.A pplyCurrentValu es(paramVal);

rpt.SetDataSour ce(DS_MyReports DS);

crystalReportVi ewer1.ReportSou rce = oRpt;

crystalReportVi ewer1.Refresh() ;

---
Steven Wood
"JK" <NONE> wrote in message news:%2******** *******@tk2msft ngp13.phx.gbl.. .

In my win form, I'm trying to display a Crystal report with the data in my
dataset only but, if I follow the steps in this msdn page:

http://msdn.microsoft.com/library/de...tinaviewer.asp
it always displays all the data regardless of the Select statement I run.
Here's my code:

InitializeCompo nent();
//my code

CrystalReport1 oRpt = new CrystalReport1( ); //CrystalReport1. rpt - it
contais 3 fields from table ClientData: clientid, fname, lname

SqlConnection SQLConn = new SqlConnection(" Data Source=localhos t; Integrated Security=SSPI;" +

"Initial Catalog=invoici ng");

string strThisQuery = "select clientid, fname, lname from ClientData where
clientID = 4"; /it returns only one record

SqlDataAdapter MyDataAdapterCl ients = new SqlDataAdapter (strThisQuery,
SQLConn);

DataSet DS_MyReportsDS = new DataSet();

MyDataAdapterCl ients.Fill(DS_M yReportsDS, "ClientData ");

oRpt.SetDataSou rce (DS_MyReportsDS );

crystalReportVi ewer1.ReportSou rce = oRpt;
It doesn't matter what my Select returns, it'll always display all the data in ClientData. I posted a similar message a few days ago, and someone posted this:
"If it contains the schema of all the columns, the CrystalReportVi ewer will display all the data in the table regardless of your select." but I really
didn't understand what he meant. How would I be able to pass my Select
statement into the report?
Thanks.