My suggestion for building datareport from two tables is, first you build a query with fields required for datareport. Then there should not be any problem creating datareport since its just like building datareport from single table.
Please help me i have 2 table Std(Roll_No(PK),Std_Name,Father Name,ETC) and Fee(FeeID(PK),Roll_No(FK),Due_fee,Paid_Fee,Total_Fee etc.).
i have to generate a report for due fee ,one by one std who have to pay fee,they pay monthly it will detect from Payable fee at least when he will pay all fee disappear from due fee report.
First of all thanks lot for responding and where r u from ? secondly, I almost completed project about college management system .as i posted be4 i have to generate a Due Fee report ,tables are posted be4 (Please Scroll up to read my last post).I saved all data about Student Fee in FEE tab as i said in Fee table Roll_No is foreign key .i made two VB6 Forms 1.Add new Student 2.Monthly /semester vice fee pay form.as student Admit to college he has to pay admission fee+Advance Monthly College Fee.Student Form send data about to FEE Table and personal data to Student Table.I generated Report for first time it was ok ,But after month they entered Fee software didn't generate report of Last Fee Record of Each Roll_no.....that's problem.if u can solve it then please as soon as possible do it, I will Wait.
I have attached what I think is what you needed. I took your datafields and build 3 reports upon that. Also look at the database, I have added another table as well. Is this what you were looking for?
Please note that there is no comments etc, just ask if you do not understand anything. I was a bit rushed for time on my side. You obviously need to add error trapping etc to suit your needs, this is just an outline...
It is a pleasure. Unfortunately we do not have Skype at work. Too busy any ways managing my team. Good luck though. You will always find me here, or you can send me a private message, and I will help where possible.
What is it that you are having a problem with. As I mentioned, I do not have Skype at work, and I also would not get involved with posters here at all. This is why we have Daniweb, to discuss and find solutions to problems.
Post your problem from what I have send you and I will gladly help.
hello all specially anderet,
i have a question ...is Setup file so important if i just made exe file to run my project?and what is difference b/n Setup file and exe file? bz i got error when i tried to make a setup file... i will be glade to see ur response..
You will have to create a setup file for your application to work 100% on a users machine. a Normal exe might work IF they have all the vb6 run files installed on their system.
Lets presume that your application in VB6 is interacting with MS Access etc. If the user machine does not have the necessary drivers for Access, ODBC, VB6 and so forth, your application will crash right there and then. Setup takes care of these problems by installing AND including them in your app.
i checked ur VB6 code... but i want a sql query ... qfter the full payment student name has to dis apeared from due fee report....i tried it but could not.. SELECT Student.Admission_date,Student.Student_Name,Roll_No, MAX(fee.Balance_Fee) AS PaidFee,
MIN(fee.Due_Fee) AS DueFee, fee.Total_Fee FROM Fee WHERE student.Roll_no=fee.Roll_no and
(Due_Fee > 0) GROUP BY fee.Roll_No, fee.Total_Fee,Student.Admission_date,Student.Student_Name
but it doesnt give me that result which i want...plz gude me. i have to submit this Project uurgentlly.
First off, use M$ Access Query Designer Tool to create your more complex queries.
2nd, if you cannot look up CDbl in help, then do you actually have a legal copy VB?
3rd, and your right! What is the purpos of that code...
Okay, for using the Query Builder in M$ Access, once you have your sample query built, you can goto view SQL view. Copy it from there and paste it into your program. You will of course have to clean it up a little and make it so that it can accept your inputs in the where clause.
Then for your display problem, once you have updated the account, you should be able to do a requery or refresh on your rs and if you have it bound to a control, that control may need to do a rebind, refresh or whatever method the control supports.
If you look at the database I included, you will see that I had a field that got updated everytime that a payment has been made. If I look at your select statement above, I do assume that you update the record everytime that a student made a payment to eventually get to a student that made the full payments, i other words his balance is zero (0). Your statement will then look like this -
"SELECT * FROM student WHERE Roll_no = fee AND Due_Fee = 0 GROUP BY ...
Again, look at the tables I have included for you, this will show you the flow on what you need. To get to your question, once you have the record of a student that paid all his fees, delete the record if you like. I personally would keep the record for future reference. Just do not call it if you do not want the user to see it...
CDbl is a declared double. If you are working with currencies, there are many formats used. Lets say that you want to calculate the sum of $3, 210.53 and $1, 900.25, you will get an answer of $5, 110.78. When you are trying to do his sum in vb6, you will get an error, because it will read the commas (,), point (.) etc as well. CDbl basically removes everything except the number, do the sum and gives you an answer again (not formatted i.e. 5110.78)
Thx for guidance ..But I want to keep record in Database but When Student Paid all dues their name has to disappear from DUE_FEE Report.I understood why Use CDbl() function, But how u ur currency Field Formatted they show Commas,$ sign and points?
and how i can Refresh/update record every Time I mean what kind of command?
and which u sent me it also doesnt update When we enter new Std it doesnt show new Std until we Stop Program. next time when we start then it shows new Std name and other record..Please tell me is it Possible if we add new std we want to view report with stop program if yes then how.?plz don't get bore on my questions.It is my habit,i am keeping to ask until i understand..Advance appologize..