Maybe what I want to do isn't possible...

[campwes]

I've searched the forums, but haven't come up with a way to do this. This is
what I want to do:

1. Pull records from an Oracle database into a datagrid on a winform.
2. Select one of those records, and then have a button on the winform
generate a document (a letter that is 4 pages in length, and includes text,
and tables).
3. After, or during the generation of the letter, save a copy of the letter
off someplace on a server.

This is what I've done (all in C# by the way):

1. Pull records from an oracle database into a dataset that fills a datagrid
on a winform.
2. There is a button on the form that generates a letter using a Crystal
Reports file converted to a web service. I'm using the version of Crystal
Reports embedded into VS.NET 2003 Pro.

For those who don't know, Crystal Reports allows you to create a document
fed from a datasource (databse, XML file, etc.). The limitation of Crystal
is its cludgy integration with databases. It doesn't keep database login
information reliably, so you sometimes have to supply login info after
launching the form.

My limitation is that I cannot buy a third-party product (Aspose, Data
Dynamics, etc) because of budgetary constraints.

Suggestions are greatly appreciated. I'm at wits end, here.

[Tony]

why not use ADO.net, DataSet to create your crystal report, it will save
your user name and password in code.

http://support.crystaldecisions.com/...etdatasets.pdf
Tony

"campwes" <ca*****@discussions.microsoft.com> wrote in message
news:D4**********************************@microsof t.com...

I've searched the forums, but haven't come up with a way to do this. This is what I want to do:

1. Pull records from an Oracle database into a datagrid on a winform.
2. Select one of those records, and then have a button on the winform
generate a document (a letter that is 4 pages in length, and includes text, and tables).
3. After, or during the generation of the letter, save a copy of the letter off someplace on a server.

This is what I've done (all in C# by the way):

1. Pull records from an oracle database into a dataset that fills a datagrid on a winform.
2. There is a button on the form that generates a letter using a Crystal
Reports file converted to a web service. I'm using the version of Crystal
Reports embedded into VS.NET 2003 Pro.

For those who don't know, Crystal Reports allows you to create a document
fed from a datasource (databse, XML file, etc.). The limitation of Crystal is its cludgy integration with databases. It doesn't keep database login
information reliably, so you sometimes have to supply login info after
launching the form.

My limitation is that I cannot buy a third-party product (Aspose, Data
Dynamics, etc) because of budgetary constraints.

Suggestions are greatly appreciated. I'm at wits end, here.