If your report is not consistent because you move all
the information to one line, then create a body that
hold a table which is the deepest datasource table in
the report.
For example, if you want to create a report from
SalesTable & SalesLine, but you want to move all
information to one line. So, if the datasource
structure is:
SalesTable
|
+-- SalesLine
Then, create body that hold SalesLine table.
If the datasource structure is:
SalesLine
|
+-- SalesTable
Then, create body that hold SalesTable table.
So, if your report's datasource structure is: (I
guess)
InventTable
|
+-- InventTrans
|
+-- InventTransPosting
Then, create body that hold InventTransPosting table.
Please consider the join type property and table
relations. If it's inner join and relations are okay,
then the filter will be working with no problem.
Regards,
Sonny Wibawa Adi, MBSCP, MCAD.NET, MCSD.NET, MCP
--- Hemant Kumthekar <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 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! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
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.
