Report Designer

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - Historical FoxPro That makes sense, but the required DLL is on the system, presumably reloaded by the new installation. But FoxPro does not know where it is, and clearly I do not know where it ought to be. Dumarest Tag: Report Designer
  - 2
    - Validations on Textbox To check type of the expression you can use either vartype() or type functions. Check both of them in Help. Tag: Report Designer
  - 3
    - File is in use by another Hi all, One of my client is using my inventory program (developed in FoxPro 2.6 for windows) for last 4 years without any problem. Two days before client's computer operator reported to me the following situation; "I just turned on pc. First thing I did after that is I started your program and suddenly got an error message 'FILE IS IN USE BY ANOTHER' and stopped on the line 'INDEX ON CO_NO TO COMPANY' from the .prg file." I approached the client's office and had a look on the code and made sure that the dbf is opened exclusively in that workarea. I tried to run the program and got th same error message as reported above. When I came out of foxpro by cancelling the program, System Tray ballooned up the message 'FILE COMPANY.IDX FILE IS CORRUPTED. RUN CHKDSK/F'. When I tried to run the CHSDSK /F from the DOS Prompt, It gave an error mssage; 'CANNOT LOCK CURRENT DRIVE. CHKDSK CANNOT RUN BECAUSE THE VOLUME IS IN USE BY ANOTHER PROCESS.' What should be wrong with it Please help me. Tag: Report Designer
  - 4
    - Drag and Drop with Listbox >> Hence I may still persevere with perfecting my algorithm for determining which item in a listbox the mouse is over. If anyone can offer any help with this I would be grateful What do you mean If you use the native methods you always know which is the source object. I use this code in the DragDrop event of a listbox class (my form has FOUR lists AND a Treeview) and users can drag from one to the other: Code Snippet LPARAMETERS oSource, nXCoord, nYCoord IF oSource. Class # THIS . Class *** Hand off to the form method passing both Source and Destination objects ThisForm .DoDragDrop( oSource, This ) ENDIF The form method handles all the necessary interaction and any additional processing like this: Code Snippet *********************************************************************** * Program....: FRMMANAGEPLANS.DODRAGDROP * Purpose....: Control method for responding to drag actions from the Tree *********************************************************************** LPARAMETERS toSource, toTarget LOCAL lcTarget, loNode, lnLevel, lcDropZone, lcLevel, lcBelow, lcTable, lcWhere, lcMsg, lnPK, llOk LOCAL lcDesc *** Assume Success STORE .T. TO llOk IF VARTYPE ( toTarget ) = 'O' *** Called with a drop target, and, therefore, a Source Object lcTarget = LOWER ( ALLTRIM ( toTarget. Name )) ELSE *** Called from the button, so neither source or target *** Set lcTarget = '' so that ANYTHING compared to it returns .T.! lcTarget = '' ENDIF So at this point you know both the Source Object (and hence can get any of its properties, and the intended Target object (and so can get any of its properties). I also have code in the DragOver events which calls another form method to handle changing the icon so that the user know whether this is a valid target object for the drop Code Snippet LPARAMETERS oSource, nXCoord, nYCoord, nState ThisForm .ChangeIcon( oSource, nState ) Again, you have a reference to the Source object and in that method all I do is: Code Snippet LPARAMETERS toSource, tnState LOCAL loTarget loTarget = SYS ( 1270 ) IF VARTYPE ( loTarget ) = 'O' IF loTarget. Class = toSource. Class *** Only allow drop between controls of different classes toSource. DragIcon = This .cNoDropIcon ELSE IF tnState = 0 *** Entering a DD enabled control toSource. DragIcon = This .cDropIcon ELSE IF tnState = 1 *** Leaving a DD enabled control toSource. DragIcon = This .cNoDropIcon ENDIF ENDIF ENDIF ENDIF You may want to change the 'disallow' line (since you are allowing drag from the same Class), but the basic methodology is the same - you need to check the source to see if you want to allow dropping from that source on the target and you get the target by using SYS(1270) to see what is actually under the mouse. It's really very simple.... Tag: Report Designer
  - 5
    - Memo file is missing or invalid Hi Cindy, Apologize for my english. My question is: How if I don't know the exact name of the column table. It happens that he shared me a .dbf file but I can't open it, "Memo file is missing or invalid." And I dnt have any idea what is memo column or structure of the table. Please help. Thanks. Tag: Report Designer
  - 6
    - image from file thanks for your help how do i bring image in my field ( field name is " image " and data type is memo(binary) ) instead of thisform.image1.picture = lcfile thanks Tag: Report Designer
  - 7
    - Need better performance with FP Tables I dont suppose I meant that FP itself was slow. It's more of a "Way things are" being slow. I set up IIS and ran some tests making the ADO calls through ASP and the results were astonishing. I didnt bother with any real testing but my guess is that it's happening at about 1/100th of the time that the Access/linked tables method. To give an examble of slow, I had a recordset of 4300 records that needed 1 field updated. Select client, udf3, name from tablename where client='xyz' and name like '%WALMART%'; I would open the recordset and run a loop. If the record meet some simple conditions, I would update UDF3 with some text. It seemed real simple. I ran it with access / linked tables through a module and it was averaging 1 record per second. The same procedure using IIS server side, did 850 records in under 2 seconds. Anyway, thanks for the help. Dave Tag: Report Designer
  - 8
    - Problem with Vista Windows mail You aren't getting mail from Outlook though, you're getting it from Exchange if it's MAPI. So I don't understand what you mean by "fetching" mail from Windows Mail (which is just a client piece of software) Tag: Report Designer
  - 9
    - DCT FILE I tryed both but no results. Full error message is: "Memo file n:\data\data.dct is missing or is invalid" All is fine with vfp 7. I can build a new dbc file, and make tables free and add them in new vfp 9 dbc but I will lose long field names .... Tag: Report Designer
  - 10
    - Visual FoxPro9 Report Designer BUG I got the same error and I have VFP 9.0. I also have VFP 6.0 installed, also. Mine is ran Windows XP, too. Tag: Report Designer
  - 11
    - Sqlexec() command line maybe too long. Hello, Yes it does work if exclude subject, it does work perfectly, the problem is I need to include subject and some more fields after subject, its just that i beleive when i enter the subject field, by then i would have reached my limits. Thank you Tag: Report Designer
  - 12
    - OLEDragDrop errors Good you got it working Sometimes a fresh look at the code can help. Tag: Report Designer
  - 13
    - Display "Running query..." progress bar Yes, may be VFP thinks it is not going to take long time to run it. Anyway, this class can come handy for other selects. Tag: Report Designer
  - 14
    - Recursive function call stack cleanup Below is a program that calls two recursive functions. With the first one, I am able to watch as the call stack is built with each instance of the function one by one, and then am able to watch as each instance of the function is removed from the call stack, one by one. With the second function, I can watch the call stack grow as each instance of the function is added, but after the last instance of the function is added, and the call stack pointer is at the top of the stack, that function then returns, and it seems as if that instance of the call stack immediately returns to the next line in the program, after the line that initially called the function. It seems as if all of the parent instances of the function on the call stack are skipped. I know this is not what really happens, because the final value after the functions return to the main part of the program is correct. However, I would like to be able to use a breakpoint or a suspend, so that after the second function is called, as each instance of the call stack have all been added, and then start returning to the parent instances, I can stop the program each time and know that those instances are actually being removed one at a time, and not being cast off into memory as a leak. Any ideas All of my efforts with the second function have not been successful. Struggling with this led me to creating the first function, in which I was able to successfully watch the recursion step by step. However, I really would like to verify the same thing on the second function. Thanks. *------------------------------------------------------------------------------ *- Program Name..: recursiveFun.prg *------------------------------------------------------------------------------ *- Description: Visual Foxpro Recursive Factorial functions *------------------------------------------------------------------------------ *- Synopsis...: This program demonstrate two different versions *- of recursive functions that both determine the factorial *- value for a number. In this case, I've used 10 *- for simplicity. *- *- Source: http://fox.wikis.com/wc.dll Wiki~RecursionInVFP~VFP *- *------------------------------------------------------------------------------ Private ll_Cntr PRIVATE ll_funcCntr PRIVATE ll_stuff CLEAR ll_Cntr = 10 ll_funcCntr = 0 ll_stuff = 0 "Beginning program!" fact = Factorial1(ll_Cntr) STR(ll_Cntr) + "! = " + STR(fact) *!* fact = 0 *!* fact = recFun(ll_Cntr) *!* STR(ll_Cntr) + "! = " + STR(fact) "End of program!" FUNCTION Factorial1 LPARAMETER n IF (n < 1) IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF ll_stuff = ll_stuff + 1 ELSE IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF && recursive call ll_stuff = ll_stuff + n*Factorial1(n-1) ENDIF && program returns here after each recursive call IF (ll_funcCntr > 0) && track function call cleanup "Performing Cleanup on function instance " + ; STR(ll_funcCntr) ll_funcCntr = ll_funcCntr - 1 ENDIF RETURN ll_stuff && returns to next line after function call && in the main code above **-- End Function FUNCTION recFun LPARAMETERS n && After the last recursive call, does the instance && of the function on the top of the call stack && return to the line after 'fact = recFun(ll_Cntr)' && && Or does it return to the next parent instance of the && function on the call stack until the last instance && of the function has returned to the calling command && && Is there a way I can stop the program in this function && after each instance of the function on the call stack && returns RETURN IIF(n>1,n*recFUN(n-1),1) **-- End Function Tag: Report Designer
  - 15
    - Little Doubt with Grids Hi Markish, Well. But those are different tables... Tag: Report Designer
  - 16
    - Catch "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window Hi Everybody, Help me, please I have problem with unique index. How to catch the message "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window (or Grid control). Because I want to display my message instead VFP's meassage. I use VFP9. Sorry because my english is not good! Thanks everybody Tag: Report Designer
- Next
  - 1
    - Opening VFP tables with Fox2.6 (Dos) Thanks to the authors of this and the two previous posts. VFP is not an option, we just do not have it. Changing the first byte actually does work in some cases, but not all. I'm still trying to nail down the reason for this. My intention is still to manufacture a "replacement" header, I presume some things are going to have to be stripped or altered (like the db container link you mentioned). Thanks Tag: Report Designer
  - 2
    - VFP 8 Form Issue TRJ48 wrote: I have developed a form in VFP 8 which has multiple grids on it. It runs fine from VFP but when I run it from the EXE it gives the following error when trying to load the form. Error Loading File - Record Number 66. ResoGrd <or one of its members>. Parent : Not a Table. Just a SWAG here - is the grid class that is causing the problem using member classes Tag: Report Designer
  - 3
    - Urgent - Need Help In VFP 8 Deployment Hi Greetz, Thanks for showing me way, however i have main prg file in which i have define menu and no " do form " is called i have simple display menus and in that i called forms. so where should i include read events in main prg so that as per my exe my deploy project also run fine, Regard Hemangi Tag: Report Designer
  - 4
    - How to Filter Records in a Grid Okay, I've put the lcKey = alltrim(this.value) command in the interactive change code but I'm not sure where to put the SET KEY to m.lckey command. I thought that it might go in the Keypress code but when I put it there I get a "variable not found LCKEY" error message. Tag: Report Designer
  - 5
    - Retrieving values of every selected item in a listbox Its loaded from a field in a table. It fails on the myString = myString + ' ' + ThisForm.myListBox.List(Counter) Tag: Report Designer
  - 6
    - how to fix the width of a column in grid? with thisform.myGrid .Columns( .columnCount ).Width = 75 .Columns( .columnCount ).resizable = .f. endwith Tag: Report Designer
  - 7
    - Performance problem: Querying fox tables with oledb Hi, I have a big performance problem querying fox tables using oledb provider from a win32 (C#) application: one select takes 30 seconds to done!!! Is there anyone who has experience the same problem and has a way to improve querying performance Thanks! Tag: Report Designer
  - 8
    - memo file c:\...\.sct missing or invalid Hi, plase help me I heve a form and in one moment .sct file is missing, and thear message memo file c:\...\.sct missing or invalid Thanks Tag: Report Designer
  - 9
    - about vfp9 sp2 does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, Tag: Report Designer
  - 10
    - Cursors Help Lightening wrote: ...... Select yourCursorName Report form YourReportFileName nonconsole preview Ok, but don't I need to have the table in the data environment I am new to reports Tag: Report Designer
  - 11
    - numeric values hi all, i would like to know why my columns on grid display numeric values as ***,*** I had set the columns format = !R and inputmask = 999,999. thanks in advance. regards. Tag: Report Designer
  - 12
    - Error Anomaly in Control Valid Events Hi... I'm getting some very weird problems when an error occurs in the valid event of a form combo box. I am attempting to handle form errors within a TRY block that wraps a READ EVENTS. When an unhandled form error occurs, the CATCH releases the form, and then evokes the READ EVENTS again. In this way, I can dump the form without losing the whole app. This methodology works fine - except when errors occur in valid events for combo boxes, text boxes, and edit boxes!!!! For some reason in these cases, the form cannot be released - almost as if a reference to the form or form-object is being maintained somewhere that I am unaware of, and this is preventing the form and it's objects from being destoyed. This problem can be easily reproduced with the following code: LOCAL frm SET CLASSLIB TO misc TRY frm = CREATEOBJECT ("frmCrash") frm. Show() READ EVENTS CATCH frm. Release () ENDTRY Any takers Tag: Report Designer
  - 13
    - Accessing VFP 8 through C# and ODBC AlexIn(warm)Miami... As I recall, the shuttle had to be taken to the local shop to have hail damage fixed, right Well, after this morning, we can add my car to that list. I'm afraid I'm not that experienced in using VFP. My previous places of employment all used either Oracle or SQL Server. We just wrote the connection into the code. How would I use OLEDB to connect a C#2003 program to VFP8 data Thanks for your help! KevinIn(not-so-cold-but-REALLY-wet)Indy Tag: Report Designer
  - 14
    - export file question Hi, I don't know how to export a dbf file to a text file with character fields without quotes. For example, I need that in the text file, fields appear like this: simon 150 manager robert 300 sales representative Thanks, Tag: Report Designer
  - 15
    - DBCs and Citrix/ Terminal Server This looks like something I could check out for my post. Thanks for the link. Tag: Report Designer
  - 16
    - same field on several tables Yes, this is useful. I was just trying to solve the original problem. Tag: Report Designer

MillBear

Hi all

Is there date sorting on the field in the report designer

Thank you.

Re: Report Designer

Naomi Nosonovsky

No as far as I know. You may need to sort the data before running the report (I mean prepare data in the correct order).

You may also try to use third party report generator tools such as Foxfire or SFReports. I haven't tried them, so can not provide more recommendations.

Re: Report Designer

Tamar E. Granor

Although you can do some calculations in the Report Designer, in VFP 6, it's basically a dumb engine. It takes the data you give it in the order you provide it and formats it for output.

Your best bet is to always prepare the data before running a report. Typically, you do that with a SQL SELECT (or more than one).

Often, you need to collect data from the user anyway. A good approach is to have a form class that it set up for reporting (with the Print button, and with appropriate methods) and then create a form for each form based on this class.

Tamar

Re: Report Designer

MarciaAkins

MillBear wrote:

Just a VPF version 6 Beginner! Need Help Badly!

The you need to get a copy of Fundamentals: Building Visual Studio Applications on a Visual FoxPro 6.0 Foundation at http://www.hentzenwerke.com/catalog/fund6.htm. It is without a doubt the best beginners book out there.