Hello everybody



If anyone could help me.  I need to make a report with InventTable, Inventrans and InventTransPosting.  If I use the wizard to structure the query and different ranges it works fine, but when I try to organize the report, move all the information to one line, the information is no longer consistent and I am not able to filter it. 



The information of the report is the following: InventTransPosting_TransDate, InventTrans_ItemId, ItemName, InventTrans_QTY, InventTrans_CostAmountPosted, InventTransPosting_AccountOffset, InventTransPosting_account

Filtered by TransDate, Dimension [4], ItemId.



A possible solution to this is, I think, is to make a TmpTable with the information of the report and the filtered fields, doing the query and saving it to the tmptable.  I have been searching how to do this but not have been able to figure it out. 



So if someone could tell me how or send me an easy example, it would help me a lot.



HIlda


           
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.

[Non-text portions of this message have been removed]





YAHOO! GROUPS LINKS




Reply via email to