We help IT Professionals succeed at work.

billing

burgerking
burgerking asked
on
Medium Priority
531 Views
Last Modified: 2010-05-18

hai ,

  I have two listboxes
listbox1. contains all the names of the treatments
listbox2  contains all the drugs name.

  now the doctor has to check the listbox1 and listbox 2
to do billing.

All the drugs are quantity 1. i have given option by inputbox if he wants to increase the quantity then double click near the appropriate drug and add quantity for the drugs.

So far no probs now i should do billing can anybody tell me how to do billing in a very simple way.


Comment
Watch Question

Commented:
What do you mean when you say "do billing"?
Create a printable invoice?
Determine the aggregate amount due?
Accounting and book keeping of orders?

I would like to offer you assistance, however I don't know what exactly it is you are looking for.

Author

Commented:

hi CArnold
yes ofcourse

printing bill, first to display and then print.

it should look like this

Treatment name      quantity     cost

 massaging                       10

 drug1                 1          .99
 drug2                 2         1.78
                             -------------


i think all these can be done in a text box itself but i havent got a clue.


                       total



Commented:
  What you want to do is create it in a VB's Data Report Writer.  Use the Data Environment to create your connection to the database containing your information.  Using the data explorer, you can drag-and-drop the SQL command object responsible for collecting the billing information onto the report.
   After dropping the command onto the report, it will automatically become populated with textboxes and respective captions.
   You may also manually insert each control onto the report, but I find doing so very tedious.
   You don't necessarily have to use the Data Environment to create the report, but if  you're trying to do this in a hurry, I would reccommend it.  The alternatives (using ad-hoc SQL, calling stored procedures from a module or form based connection) would require more explaination to use and is kind of quirky.

   You can display your report (Print Preview style) with:
DataReport1.Show

This command will display your report in a Print Preview-type window.  From this window, you can click the print icon to print, or you can close the window.  To bypass the Preview, just use:
DataReport1.PrintReport

   The report writer is a banded report writer.  To eliminate banding, I suggest creating a large Detail section.

   The best way to learn the report writer is just to play with the properties and methods associated with it.  I would also reccomend you learn the Data Environment, as well, if you are new to either.  They are really simple tools and not that difficult to learn.

   Hope this helps!  If you have any further question, feel free to ask.

CArnold

Commented:
What you want to do is create it in a VB's Data Report Writer.  Use the Data Environment to create
your connection to the database containing your information.  Using the data explorer, you can drag-and-drop
the SQL command object responsible for collecting the billing information onto the report.
  After dropping the command onto the report, it will automatically become populated with textboxes
and respective captions.
  You may also manually insert each control onto the report, but I find doing so very tedious.
  You don't necessarily have to use the Data Environment to create the report, but if  you're trying
to do this in a hurry, I would reccommend it.  The alternatives (using ad-hoc SQL, calling stored procedures
from a module or form based connection) would require more explaination to use and is kind of quirky.

  You can display your report (Print Preview style) with:
DataReport1.Show

This command will display your report in a Print Preview-type window.  From this window, you can click
the print icon to print, or you can close the window.  To bypass the Preview, just use:
DataReport1.PrintReport

  The report writer is a banded report writer.  To eliminate banding, I suggest creating a large Detail
section.

  The best way to learn the report writer is just to play with the properties and methods associated
with it.  I would also reccomend you learn the Data Environment, as well, if you are new to either.
 They are really simple tools and not that difficult to learn.

  Hope this helps!  If you have any further question, feel free to ask.

CArnold

Author

Commented:
Sorry for the delayed response,

iam using only crystal reports to do my rest of the projects, hope we can do this in crystal report, but i think instead of going into reports we can do it in simple vb coding itself.

Commented:
Burgerking,
   I would like to assist, however your last response is open to interpretation.  You make two comments that are contrary to each other:

"iam using only crystal reports to do my rest of the projects"

and

"i think instead of going into reports we can do it in simple vb coding itself"

Which approach will you be pursuing?

CArnold

Author

Commented:


Thats true what you said i would like to do this billing with simple vb coding, what i want to do i will make much clearer , for each treatments that has been checked from the list view the billing should be done , similarly for each drugs that has been checked in another list view the billing should be done, and all should be batch inserted in to the data base (Access) , and bill should be displayed and printed.
Hope you can help me.

Commented:
I see...

   I'm not very fluent with Crystal Reports.  Our company had a hard time getting it to work on all necessary PCs, so we currently use a combination of Actuate and VB's report writer.  More complex and difficult reports are usually handled via Actuate (a marvelous report writer).  More simple and less intense reports are handled via VB's report writer.

   From the description of what you are attempting to accomplish, I would strongly recommend using VB's report writer.

   I'll try to outline what you need to do to accomplish this.  Give me your e-mail address and I will try to send you a project that will get you started in the right direction.

CArnold

Author

Commented:


Alright sabeeru@yahoo.com...

Lets see ....there.
Dear CArnold
I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See: <http://www.experts-exchange.com/jsp/communityNews.jsp>
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

EXPERTS: I will return in seven days to close this question.
Please leave your thoughts and recommendations here

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Thanks !

kodiakbear
Experts Exchange Moderator
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ/no refund
Please leave any comments here within the
next seven days.
Commented:
Finalized as proposed

modulo

Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.