Thank you for your help, I have tried to do this simple report, but the lines don´t match, something I don´t knowdoes not work well. I used the wizard and put all the conditions, then in the body left the deepest line, the report is horrible.
Since I have been trying to make it work for so long, I have an idea and it is to save the query in a temptable and in this temptable do the report, as you said the information is ok because the query works, what seems to damage the report is the report itself, I don´t know if it was intended to work the way I want.
Do you think this is a good idea. The question is how do I do this ? Have no idea.
Thank you
Hilda
Sonny Wibawa Adi <[EMAIL PROTECTED]> wrote:
Hi hilda cabrejos,
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.
---------------------------------
---------------------------------
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
[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.
