Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report
Message
From
01/05/2005 16:43:35
 
 
To
01/05/2005 08:10:55
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Report
Environment versions
Visual FoxPro:
VFP 8
Miscellaneous
Thread ID:
01009875
Message ID:
01010034
Views:
20
hi,
thank you so much,
it works.
best regards.
m.qasem

>Is this your exact code? In this case, the first thing you should do - before you start to correct your error message - is to give your objects meaningful names. "Text2" is not an appropriate name for a TextBox - rename it to something that describes the content. For instance, if it contains a client code, you might call it "TxtClientCode". Otherwise, it will be very difficult to make corrections to your program, since you will have to look up, every time, what "Text2" or "Text18" is supposed to do.
>
>The same for a table and field names, and other filenames - "Table1" is not an appropriate name for a table (or for a report). Give your table a name that describes the content, for example, "account", "client", "product", etc., or the equivalent in Arabic (I recommend using the singular for table names).
>
>The next thing you should do is to use SELECT statements to prepare your reports. I assure you that this will cause you much less trouble than filters, etc. Your code might be adapted to:
>
>
>select * from Table1;
>  where MONTH(dat)=MONTH(thisform.text2.Value);
>    AND table1.mac1=ALLTRIM(thisform.text18.value );
>    AND TYP=THISFORM.TEXT24.VALUE;
>  into cursor TempReport
>if _tally = 0
>  MessageBox("No data selected - check your options.")
>else
>  report form ...
>endif
>
>
>
>>hi,
>>thank you,
>>i remove the table from myreport DataEnvironment.
>>and this the code under,i useit befor run my report,atmyform via grid it works,
>>but when i want to run the report via command botton at the same form, i get error message index tag not found.
>>
>>
>>        LOCATE FOR   dat=(thisform.text2.Value) .AND. table1.mac1=ALLTRIM(thisform.text18.value ) AND TYP=THISFORM.TEXT24.VALUE
>>IF  FOUND()
>>          SET FILTER TO MONTH(dat)=MONTH(thisform.text2.Value) .AND. table1.mac1=ALLTRIM(thisform.text18.value ) AND TYP=THISFORM.TEXT24.VALUE
>>          report form table1 preview
>>ENDIF
>>
>>
>>thanks.
>>
>>>In case you are not doing it already, I strongly suggest you prepare all data before running the report (usually, with one or more SELECT - SQL commands), and eliminate any tables from the report's DataEnvironment.
>>>
>>>>hi all,
>>>>i tray to run my report via my form,via fvb5,or vfp8
>>>>but i get error message
>>>>
>>>>index tag is not found
>>>>
>>>>but if i copy all field as new report , and i run it again, it works
>>>>
>>>>after 2 days or more if i try to run it i get the same message.
>>>>
>>>>any idea,
>>>>thanks .
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform