473,735 Members | 1,903 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report or MS Word?

I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...

I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works

OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you

end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.

As I upgrade this program to VB.net, I am trying to clean up this whole

issue. Users have loved the ability to edit/e-mail so I'm thinking the

way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of

a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.
I need some input - feel free to offer your comments/suggestions on any

or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database

method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a

user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?
Thanks in advance for any help...
Jmar

Sep 30 '06 #1
5 3736
I used VB6.0 and have now upgraded to VB.Net. I have always used Word to
store large documents. No problems, but you need to learn how to stick things
into word objects - like text boxes, word tables, referencing those tables
and paragraphs.
You can even have the word document look for things in your DB on opening.
If you are good at VB this should be easy

"jmar" wrote:
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...

I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works

OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you

end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.

As I upgrade this program to VB.net, I am trying to clean up this whole

issue. Users have loved the ability to edit/e-mail so I'm thinking the

way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of

a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.
I need some input - feel free to offer your comments/suggestions on any

or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database

method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a

user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?
Thanks in advance for any help...
Jmar

Sep 30 '06 #2
I might be missing something here, but why not just handle the
creation, editing, and emailing of the quotes from within your app?
Things like email and printing are *much* easier in .Net than they were
in VB6. Doing everything from the app would also allow you to batch the
records into the database whenever a change is made - therefore keeping
the database accurate (and allowing your clients to use all the
benefits of MS Access).

Just my 2 cents,

Seth Rowe
Joseph wrote:
I used VB6.0 and have now upgraded to VB.Net. I have always used Word to
store large documents. No problems, but you need to learn how to stick things
into word objects - like text boxes, word tables, referencing those tables
and paragraphs.
You can even have the word document look for things in your DB on opening.
If you are good at VB this should be easy

"jmar" wrote:
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...

I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works

OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you

end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.

As I upgrade this program to VB.net, I am trying to clean up this whole

issue. Users have loved the ability to edit/e-mail so I'm thinking the

way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of

a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.
I need some input - feel free to offer your comments/suggestions on any

or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database

method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a

user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?
Thanks in advance for any help...
Jmar
Oct 1 '06 #3
Seth,

Can you provide some more details? I don't understand what type of
file you'd write the database fields to and how you would allow
editing/e-mail from that file.

Any additional insight would be much appreciated!
Jmar
rowe_newsgroups wrote:
I might be missing something here, but why not just handle the
creation, editing, and emailing of the quotes from within your app?
Things like email and printing are *much* easier in .Net than they were
in VB6. Doing everything from the app would also allow you to batch the
records into the database whenever a change is made - therefore keeping
the database accurate (and allowing your clients to use all the
benefits of MS Access).

Just my 2 cents,

Seth Rowe
Joseph wrote:
I used VB6.0 and have now upgraded to VB.Net. I have always used Word to
store large documents. No problems, but you need to learn how to stick things
into word objects - like text boxes, word tables, referencing those tables
and paragraphs.
You can even have the word document look for things in your DB on opening.
If you are good at VB this should be easy

"jmar" wrote:
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...
>
I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works
>
OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you
>
end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.
>
As I upgrade this program to VB.net, I am trying to clean up this whole
>
issue. Users have loved the ability to edit/e-mail so I'm thinking the
>
way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of
>
a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.
>
>
I need some input - feel free to offer your comments/suggestions on any
>
or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database
>
method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a
>
user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?
>
>
Thanks in advance for any help...
Jmar
>
>
Oct 1 '06 #4

I would create a form in vb.NET and allow users too add/edit the data
in the database before creating the report. Once the data has been
finalized and you have updated the database, then send the data to
crystal and either export it to PDF and email it or Print it.

I do this all day long, so if you need some code examples, let me know.

For instance, I have a form with textboxes, users add/edit data and the
data gets saved to the database. Then they click an "Email Invoice"
button and the data gets dumped into a crystal report and saved as a
PDF file. I then attach the pdf to an email "System.Net.Mai l" and send
it out in an HTML formated email.

Easy stuff.

I also keep the PDF file for record keeping purposes. Because someone
could go in the next day and change the data in the database.

Izzy

jmar wrote:
Seth,

Can you provide some more details? I don't understand what type of
file you'd write the database fields to and how you would allow
editing/e-mail from that file.

Any additional insight would be much appreciated!
Jmar
rowe_newsgroups wrote:
I might be missing something here, but why not just handle the
creation, editing, and emailing of the quotes from within your app?
Things like email and printing are *much* easier in .Net than they were
in VB6. Doing everything from the app would also allow you to batch the
records into the database whenever a change is made - therefore keeping
the database accurate (and allowing your clients to use all the
benefits of MS Access).

Just my 2 cents,

Seth Rowe
Joseph wrote:
I used VB6.0 and have now upgraded to VB.Net. I have always used Word to
store large documents. No problems, but you need to learn how to stick things
into word objects - like text boxes, word tables, referencing those tables
and paragraphs.
You can even have the word document look for things in your DB on opening.
If you are good at VB this should be easy
>
"jmar" wrote:
>
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...

I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works

OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you

end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.

As I upgrade this program to VB.net, I am trying to clean up this whole

issue. Users have loved the ability to edit/e-mail so I'm thinking the

way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of

a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.


I need some input - feel free to offer your comments/suggestions on any

or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database

method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a

user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?


Thanks in advance for any help...
Jmar
Oct 1 '06 #5
Unfortunately, I don't know enough of the details of your app, to help
on the design part, but everything you need for emailing is in the
System.Net.Mail namespace. The following website will walk you through
it:

http://www.systemnetmail.com/
I don't understand what type of file you'd write the database fields to and how you would allow editing/e-mail from that file.
Actually, I wasn't suggesting a different file, I meant you should
design a form that would provide all the functionality your clients
need. If you could provide some more details of what the form needs to
do (like which parts the user does, what calculations are made, what
you want the app to look like, etc) I could give you some more
suggestions. Basically, the point I was trying to get across is that
you can build just about anything with VB.Net, (including a MS Word
replacement if you have the time and knowledge) so you don't have to
rely on outside programs to accomplish all your goals.

Thanks,

Seth Rowe
jmar wrote:
Seth,

Can you provide some more details? I don't understand what type of
file you'd write the database fields to and how you would allow
editing/e-mail from that file.

Any additional insight would be much appreciated!
Jmar
rowe_newsgroups wrote:
I might be missing something here, but why not just handle the
creation, editing, and emailing of the quotes from within your app?
Things like email and printing are *much* easier in .Net than they were
in VB6. Doing everything from the app would also allow you to batch the
records into the database whenever a change is made - therefore keeping
the database accurate (and allowing your clients to use all the
benefits of MS Access).

Just my 2 cents,

Seth Rowe
Joseph wrote:
I used VB6.0 and have now upgraded to VB.Net. I have always used Word to
store large documents. No problems, but you need to learn how to stick things
into word objects - like text boxes, word tables, referencing those tables
and paragraphs.
You can even have the word document look for things in your DB on opening.
If you are good at VB this should be easy
>
"jmar" wrote:
>
I posted a week ago and received one response. I'm looking for the
opinion of several experienced .NET people before I proceed so I'm
posting again. Sorry for the repost...

I am updating a VB4.0 quote generation program to VB.net. The old
program takes user inputs, performs calculations, saves the data to
Access databases and uses Crystal Reports 5.0 to generate a quote. A
while back users obviously wanted to be able to edit/e-mail the quote
(these ancient Cyrstal 5.0 reports don't allow PDF creation) so I
modified the old VB4.0 code to allow users to save the Crystal Report
as Word document which they can then edit/e-mail from Word. This works

OK but there are two big downfalls: 1) the initial report data is
saved in the database and the modifications made in Word are not so you

end up with database data that isn't accurate 2) The conversion of
the Crystal Report to Word is clunky - the Word document that is
generated is touchy when it comes to editing - blocks of data move in
an unpredictable fashion when data is added.

As I upgrade this program to VB.net, I am trying to clean up this whole

issue. Users have loved the ability to edit/e-mail so I'm thinking the

way to go in VB.net is to forego storing in databases and simply have
my application fill in a Word Template with the quote data. Instead of

a database with quote data, they end up with a collection of Word
Documents, each representing an individual quote.


I need some input - feel free to offer your comments/suggestions on any

or all of the following:
1) Is this a good idea? Am I overlooking an advantage to the database

method?
2) Does anyone have any links/samples that show me how to easily fill
a Word Template from VB.Net 2003?
3) Can I set up the Bill of Material part of my template such that if a

user changes the cost of a line item the TOTAL is changed at the
bottom? If so, how?
4) Has anyone who has done this before have any words of
wisdom/experiences they could share as to the difficulty/issues they
faced?


Thanks in advance for any help...
Jmar
Oct 1 '06 #6

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

Similar topics

2
3340
by: vijaym | last post by:
Hi, Am trying to export a crystal report to word format as a word table. Have tried using borders, tables and lines (in the report) to no avail. Has anybody done this before ? Is it possible. Thanks in advance V
1
3275
by: CBKowitz | last post by:
I have an intermittent problem, when viewing a crystal report. This problem only happens to some users and some report formats. When they try to view the report in Microsoft Word format the system prompts them to login (User name and Password). If they view it in PDF format they do not get the login prompt. I do not get the login prompt at all. This problem occurs with users on the Internet and our Intranet. I checked the web site and...
2
1856
by: Agnes | last post by:
I will use crystal report to design a report (e.g invoice) As the user run/preview the report, can he save the report as his own template , and then he adjust the report layout ??? Can crystal report do it ??? if not, any reporter write can do it ??? Thanks in advance From Agnes
3
2207
by: Agnes | last post by:
I write the invoice by using crystal report in vb.net . I can export it into *.pdf very well, However, it can also export to word, excel also. we are afraid that the user export the invoice into excel format and then amend it by himself. Can I allow the crystal report export to *.pdf only ?? or make their excel or word file (read only) ??? Thanks a lot
7
4176
by: Li Pang | last post by:
Hi, I built a web form to display a crystal report in web, every thing work properly. I added then a button to display the report in the embedded adobe reader by using the below codes: Dim oStream As New MemoryStream oStream = crReportDocument.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows) Response.Clear()
0
1188
by: julie | last post by:
I have a CrystalReportViewer on a web page and when I click on the export button and select Word, the report opens in separate window in ..doc format, but the user cannot print / save as the standard word toolbar / menubar is not available. Toolbars and menus are also missing when I export to other formats e.g. excel and rich text format (pdf is ok). Any ideas how to export the report in Word and see the usual Word toolbars and menu...
0
1178
by: julie | last post by:
I have a CrystalReportViewer on a web page and when I click on the export button and select Word, the report opens in a separate window in ..doc format, but the user cannot print or save as the standard word toolbar and menubar is not available. Toolbars and menus are also missing when I export to other formats e.g. excel and rich text format (pdf is ok). Any ideas how to export the report in Word and see the usual Word toolbars and...
3
1946
by: Rabbit | last post by:
Dear All, I am working on the formatting of a Crystal Report, I'd noticed that setting BottomLineStyle, and other xxxLineStyle can only be shown when user export the report into PDF format, other than that, displaying such crystal report on ASP.Net 2.0 pages will not show the lines. Because I use CrystalReportViewer control to call the report, I had turn off property, still can't show the BottomLineStyle. Is this a limitation of...
3
3286
by: Simon Says | last post by:
Hi all, I've a vb application that uses the crystal report to display some reports. User have the option to export the report to pdf format. My question is that the report that the users export out, I do not want to them to be able to do any changes (i.e. convert to word doc, do the changes and convert back to pdf). I understand that the crystal report is not able to accomplish this. Can anyone please advice? I tried looking at the...
0
8965
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8786
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9466
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9255
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9202
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8202
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6748
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4823
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2191
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.