473,324 Members | 1,678 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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

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.
Jul 21 '05 #1
1 1331
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.

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Brian Kelley | last post by:
I have been using gettext and various utilities to provide internationalization for a wxPython application and have not really been liking the process. Essentially it uses a macro-style notation...
11
by: Ville Vainio | last post by:
It might just be that @decorator might not be all that bad. When you look at code that uses it it's not that ugly after all. A lot of the furor about this is probably because it happened so...
3
by: Dave Smithz | last post by:
Hi There, I want to rewrite an application I originally wrote in VB and because of annoying limitations that are not worth taking time to code around. But what language do I use? The...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
1
by: campwes | last post by:
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...
7
by: multicherry | last post by:
Hi, Having searched for a way to fetch a window object by name, all I came across were answers along the line of... "All you have to do is say windowObj = window.open("blah", "name");" which...
9
by: James Crosswell | last post by:
I'm not sure if I'm going about this the right way - it may be that Generics might be able to help me out here... but here goes: I have three classes as follows class BaseEdit class WidgetEdit:...
24
by: dmitrey | last post by:
Hi all, I looked to the PEPs & didn't find a proposition to remove brackets & commas for to make Python func call syntax caml- or tcl- like: instead of result = myfun(param1, myfun2(param5,...
2
by: dude | last post by:
Working on Windows XP Say I have a Windows executable, foo.exe. foo.exe is a command line tool that can take a number of different arguments and perform corresponding actions. I want to invoke...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.