You can create a MAP and then use that in the report wizard.
HK
hilda cabrejos <[EMAIL PROTECTED]> wrote:
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
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
