I wanted to update everyone that put in helpful suggestions for my original question. It took me quite a long time with many interruptions to try each and every approach. I realize now, that I didn't make it any easier I still used Version 2.5 terms. I did print out all pages of this forum...
Thanks Olaf and JRB
I have printed out everything (all 25 pages) will study that, re-examine the Garfield videos and write a new report. And if I have questions I'll come back to you guys. I'll also let you know how Report #2 comes out next week.
Yes, I still confused but confused on a much...
To all,
You have all been kind enough to give me many opinions and options -- I don't know which way to turn and most I don't know how to implement.
I am willing to start over but although I thought I understood report designer and I did relate tables real good 36 replies to my questions...
Dan, and many others,
I will do Dan's suggestion but I won't be able to until late this evening.
I did try a "copy" of Olaf suggestion where I deleted all data environment and that gave me errors on my report because it couldn't find all my data in the linked databases.
I will let you know...
Dan,
No, nothing I do will screw up our billing situation. This application is for on the spot purchases (of seat foam)-- cash or credit card; at aviation shows. I bring the credit card information home and run the cards from here.
I opened these tables to link each of the line entries of...
Olaf,
Yes, when I open that it has a number of tables there. these tables are all linked with information used in the report.
These all need to be closed?
JRB
The Private Data Session in the report was checked. I "unchecked" it,
In the report properties I had
DataEnvironment tab
has copy from another report file is checked
(tried and can not uncheck it)
Variables tab
I have two variables set up to do calculations in the report
I did...
JRB
I followed each step and up came the VFP debugger. I typed in the command window and my database (showinvoice) opened with the curser on the record that I had entered on the form (invoiceentry) and all the information was displayed there. I then added the NEXT 1 clause to my report line...
Foxup,
How do I set up a variable for the current record number?
My record number is a computer generated field on my form/screen.
Am I getting in over my head?
JRB,
Because I am entering field information on my form/screen that I want to see in the report I can't put in a locate in by program because it's being generated by my form screen.
You are so patient, thank you
Olaf,
thanks for responding and I think you understand that when my report runs it pulls the first record.
I want to see only the current record the one in the form I working with and/or the last one in the database and no "scope" fits that situation that I can find.
GO BOTTOM
REPORT FORMAT "C:\MYREPORT.FRX" PREVIEW
I still get a preview of all records.
(I'm the only user so that won't be a problem).
I understand that my cursor is pointing at the top record in my database when it is giving me all the records.
Back to "basics" I'm running a form to...
Dan,
No at that time last night I couldn't "try" anything, I was so excited to hear from someone with help that I wanted to respond.
Today I have taken the environment out tried the command with REST and still got all records.
I tried NEXT 1 and got only the first record.
Now, I will try some...
Dan,
What I get is a preview or print of the invoice report for every record in the database including the last entered-that's the one and only one I want to see and then print.
Jrbbldr,
I will definately study your suggestions, as I stated I'm really a newbie with a stick to it attitude. I...
I have limited knowledge about FoxPro 9; but have done hours of trial and error. I need help with this as I have struggled now for many hours.Application: Form will be used for invoice at point of purchase. My form is working except for my preview and print command buttons. It is adding the...
Microsoft Visual FoxPro 9
I have limited knowledge about FoxPro 9; but have done hours of trial and error. I need help with this as I have struggled now for many hours.
Application: Form used for invoice
My form is working except for my preview and print command buttons.
It is adding...
when I append blank I get a clear screen ready to enter next record.
It does not post to my table.
How do I properly bind controls to the form's fields. My Control source in Properities reads "table name.field name"
visual fox pro9
I have nothing fancy. One table that I want to add records to.
I must not have something right because nothing enters the table when I hit my command button with code of
append blank
entryscreen.refresh
my screen does come up clean for the next entry
My data enviroment shows...
Sorry guys I will explain further but THANKS, I wasn't sure if anyone would even care.
My entry screen form has on the top part customer information (table 1) to include fields of date, recordnumber computer generated, name, credit card information.
The next part of the form (table 2) has the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.