Create CrystalReport from DataSet

[redneon]

I've populated a DataSet in my C# program and verified that it contains the
data I passed it. I've then created a blank CrystalReport and set it's
DataSource to my DataSet. Then I created a CrystalReportVi ewer and set it's
ReportSource to my CrystalReport. When I run the program though nothing get's
shown in my viewer. The following is how I did it...

OdbcConnection dbConn = new OdbcConnection( );
OdbcCommand dbCommand = new OdbcCommand();
OdbcDataAdapter dbAdap = new OdbcDataAdapter ();
DataSet dbData = new DataSet();
CrystalReport1 report = new CrystalReport1( );

dbConn.Connecti onString = @"DSN=Crystal;" ;
dbConn.Open();
dbCommand.Comma ndText = "SELECT * FROM Student ORDER BY studentid";
dbCommand.Conne ction = dbConn;
dbAdap.SelectCo mmand = dbCommand;
dbAdap.Fill(dbD ata, "Students") ;
report.SetDataS ource(dbData);
reportViewer.Re portSource = report;

I don't want to use the wizard that comes with VS .NET because I want to
completely understand Crystal Reports and be able to manipulate the report
just by editing the DataSet by using SQL commands.

Any ideas?

Darrell

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

First you have to design your report, how you want it to looks like, the
grouping, etc

after that you can set the datasource of it to your dataset. At design time
you only need the structure of the dataset.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"redneon" <re*****@discus sions.microsoft .com> wrote in message
news:11******** *************** ***********@mic rosoft.com...

I've populated a DataSet in my C# program and verified that it contains
the
data I passed it. I've then created a blank CrystalReport and set it's
DataSource to my DataSet. Then I created a CrystalReportVi ewer and set
it's
ReportSource to my CrystalReport. When I run the program though nothing
get's
shown in my viewer. The following is how I did it...

OdbcConnection dbConn = new OdbcConnection( );
OdbcCommand dbCommand = new OdbcCommand();
OdbcDataAdapter dbAdap = new OdbcDataAdapter ();
DataSet dbData = new DataSet();
CrystalReport1 report = new CrystalReport1( );

dbConn.Connecti onString = @"DSN=Crystal;" ;
dbConn.Open();
dbCommand.Comma ndText = "SELECT * FROM Student ORDER BY studentid";
dbCommand.Conne ction = dbConn;
dbAdap.SelectCo mmand = dbCommand;
dbAdap.Fill(dbD ata, "Students") ;
report.SetDataS ource(dbData);
reportViewer.Re portSource = report;

I don't want to use the wizard that comes with VS .NET because I want to
completely understand Crystal Reports and be able to manipulate the report
just by editing the DataSet by using SQL commands.

Any ideas?

Darrell

[redneon]

> At design time you only need the structure of the dataset.

Is there no way to make a CrystalReport completely dynamic? I don't know the
structure of the DataSet at design time becaue I don't populate it with data
until run time. And depending on what SELECT statement I run at run time
changes the structure of the DataSet.

Darrell

"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,

First you have to design your report, how you want it to looks like, the
grouping, etc

after that you can set the datasource of it to your dataset. At design time
you only need the structure of the dataset.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"redneon" <re*****@discus sions.microsoft .com> wrote in message
news:11******** *************** ***********@mic rosoft.com...

I've populated a DataSet in my C# program and verified that it contains
the
data I passed it. I've then created a blank CrystalReport and set it's
DataSource to my DataSet. Then I created a CrystalReportVi ewer and set
it's
ReportSource to my CrystalReport. When I run the program though nothing
get's
shown in my viewer. The following is how I did it...

OdbcConnection dbConn = new OdbcConnection( );
OdbcCommand dbCommand = new OdbcCommand();
OdbcDataAdapter dbAdap = new OdbcDataAdapter ();
DataSet dbData = new DataSet();
CrystalReport1 report = new CrystalReport1( );

dbConn.Connecti onString = @"DSN=Crystal;" ;
dbConn.Open();
dbCommand.Comma ndText = "SELECT * FROM Student ORDER BY studentid";
dbCommand.Conne ction = dbConn;
dbAdap.SelectCo mmand = dbCommand;
dbAdap.Fill(dbD ata, "Students") ;
report.SetDataS ource(dbData);
reportViewer.Re portSource = report;

I don't want to use the wizard that comes with VS .NET because I want to
completely understand Crystal Reports and be able to manipulate the report
just by editing the DataSet by using SQL commands.

Any ideas?

Darrell

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

No it's not, at least with the version shipped with Vs.NET

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"redneon" <re*****@discus sions.microsoft .com> wrote in message
news:E9******** *************** ***********@mic rosoft.com...

At design time you only need the structure of the dataset.

Is there no way to make a CrystalReport completely dynamic? I don't know
the
structure of the DataSet at design time becaue I don't populate it with
data
until run time. And depending on what SELECT statement I run at run time
changes the structure of the DataSet.

Darrell

"Ignacio Machin ( .NET/ C# MVP )" wrote:

Hi,

First you have to design your report, how you want it to looks like, the
grouping, etc

after that you can set the datasource of it to your dataset. At design
time
you only need the structure of the dataset.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"redneon" <re*****@discus sions.microsoft .com> wrote in message
news:11******** *************** ***********@mic rosoft.com...

> I've populated a DataSet in my C# program and verified that it contains
> the
> data I passed it. I've then created a blank CrystalReport and set it's
> DataSource to my DataSet. Then I created a CrystalReportVi ewer and set
> it's
> ReportSource to my CrystalReport. When I run the program though nothing
> get's
> shown in my viewer. The following is how I did it...
>
> OdbcConnection dbConn = new OdbcConnection( );
> OdbcCommand dbCommand = new OdbcCommand();
> OdbcDataAdapter dbAdap = new OdbcDataAdapter ();
> DataSet dbData = new DataSet();
> CrystalReport1 report = new CrystalReport1( );
>
> dbConn.Connecti onString = @"DSN=Crystal;" ;
> dbConn.Open();
> dbCommand.Comma ndText = "SELECT * FROM Student ORDER BY studentid";
> dbCommand.Conne ction = dbConn;
> dbAdap.SelectCo mmand = dbCommand;
> dbAdap.Fill(dbD ata, "Students") ;
> report.SetDataS ource(dbData);
> reportViewer.Re portSource = report;
>
> I don't want to use the wizard that comes with VS .NET because I want
> to
> completely understand Crystal Reports and be able to manipulate the
> report
> just by editing the DataSet by using SQL commands.
>
> Any ideas?
>
> Darrell
>