Maybe there is some other modifications in your
report. I tried my very simple report on DAT company
and it worked well. As you can see the report below,
the report shows the right information from each table
in InventTransPosting body.
The datasource structure is:
InventTable
|
+-- InventTrans
|
+-- InventTransPosting
The resulting report:
InventTable InventTrans InvTrans InvTrPost InvTrPost
Item number Item number Lot ID Lot ID Voucher
01-00001 01-00001 00235_059 00235_059 8024_062
01-00001 01-00001 00235_059 00235_059 8024_062
01-00001 01-00001 00230_059 00230_059 8021_062
01-00001 01-00001 00230_059 00230_059 8021_062
01-00001 01-00001 00232_059 00232_059 8022_062
01-00001 01-00001 00232_059 00232_059 8022_062
01-00001 01-00001 00233_059 00233_059 8023_062
01-00001 01-00001 00233_059 00233_059 8023_062
01-00001 01-00001 00234_059 00234_059 00020_042
01-00001 01-00001 00234_059 00234_059 00020_042
01-00001 01-00001 00236_059 00236_059 00003_043
01-00001 01-00001 00236_059 00236_059 00003_043
01-00001 01-00001 00234_059 00234_059 00020_042
01-00001 01-00001 00234_059 00234_059 00020_042
01-00001 01-00001 00237_059 00237_059 00021_042
01-00001 01-00001 00237_059 00237_059 00021_042
01-00001 01-00001 00240_059 00240_059 00011_041
01-00001 01-00001 00350_059 00350_059 00033_041
01-00001 01-00001 00350_059 00350_059 20016_046
01-00001 01-00001 00357_059 00357_059 00035_041
01-00001 01-00001 00357_059 00357_059 20018_046
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-00002 01-00002 00239_059 00239_059 00011_041
01-00002 01-00002 00241_059 00241_059 8025_062
01-00002 01-00002 00241_059 00241_059 8025_062
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-00002 01-00002 00243_059 00243_059 00022_042
01-00002 01-00002 00243_059 00243_059 00023_042
01-88 01-88 00299_059 00299_059 8037_062
01-88 01-88 00299_059 00299_059 8037_062
01-88 01-88 00298_059 00298_059 110020_056
01-88 01-88 00298_059 00298_059 110020_056
01-88 01-88 00299_059 00299_059 8037_062
01-88 01-88 00299_059 00299_059 8037_062
01-88 01-88 00300_059 00300_059 110021_056
01-88 01-88 00300_059 00300_059 110021_056
01-88 01-88 00301_059 00301_059 00012_041
Regards,
Sonny Wibawa Adi, MBSCP, MCAD.NET, MCSD.NET, MCP
--- hilda cabrejos <[EMAIL PROTECTED]> wrote:
> Hello Sonny
>
> 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!
=== message truncated ===
____________________________________________________
Sell on Yahoo! Auctions no fees. Bid on great items.
http://auctions.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.
