Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

the info on the report is not up to date

Status
Not open for further replies.

zls

Technical User
Jan 11, 2006
4
US
hi
i have desgined a report (on crystal reports 7) to show the inventory adjusments betwen to dates, based on a few external .dbf files, was working well for a long time, - but lately it dosent show to me the adjustments for this same day, (only adjustments untill yesterday) i checked in the dbf files nothing is rong there all info is available, Can anybody please tell me whats wrong with my report

thanks

note: keep in mind i'm not a progromer / not so good in english
 
Please post your formula or selection criteria

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Hi Madawc

its a simple report that takes all info from one file called adjust.dbf containes all the following fields
CODE QTY DATE TIME FROM TO MAN ITEM_NO COST PO_NO
i bring this field down in the details line in a basic report, grouped by MFG (called MAN) then i go to "select expert" selecting the field "DATE" set to is between 2 dates
and the report is here with all items entered in inventory in the range of this days - but recently its missing the info of todays transations, i cannot figure out what is the reason that should affect not to show todays transactions.
 
Hi,
Please post the selection formula..you may be excluding the last date in the range unintentionally.

Or, try setting the second date to 1 day after the last update should have happened.


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Choose Report > Selection Formulas > Records, or whatever the equivalent is on Crystal 7. This is much clearer than using 'Select Expert'.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top