Discussion:
add new relation on report.
(too old to reply)
David Park
2007-06-12 22:20:28 UTC
Permalink
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.

In my report I need one more relation field which is AccountNum between two
tables.

I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.

is there any way to do this

thank you

-david
Mathias
2007-06-13 06:21:00 UTC
Permalink
Hi David,

set the autorelation on ledgertrans to no. to do so you go to the table
ledgertrans in your report query, go to properties and set property Relation
to No.
after that you can/have to create the relation by yourself.

i hope this helps

Regards
--
Mathias Füßler
my blog: http://starside.eu
Post by David Park
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.
In my report I need one more relation field which is AccountNum between two
tables.
I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.
is there any way to do this
thank you
-david
David Park
2007-06-13 13:53:16 UTC
Permalink
it works.
thank you very much Mathias.

now i know what the relation means :)..
Post by Mathias
Hi David,
set the autorelation on ledgertrans to no. to do so you go to the table
ledgertrans in your report query, go to properties and set property Relation
to No.
after that you can/have to create the relation by yourself.
i hope this helps
Regards
--
Mathias Fu©¬ler
my blog: http://starside.eu
Post by David Park
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.
In my report I need one more relation field which is AccountNum between two
tables.
I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.
is there any way to do this
thank you
-david
yassine dinari
2010-08-10 12:20:41 UTC
Permalink
i really did not get the answer.
my supervisor asked me to add a new field in ledgerjournaltrans so when i valid it gets stored in ledgerjournaltrans but not in ledgertrans.i need something so that the value which got before validating it should be stored in ledgertrans too.
thanks.
Post by David Park
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.
In my report I need one more relation field which is AccountNum between two
tables.
I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.
is there any way to do this
thank you
-david
Post by Mathias
Hi David,
set the autorelation on ledgertrans to no. to do so you go to the table
ledgertrans in your report query, go to properties and set property Relation
to No.
after that you can/have to create the relation by yourself.
i hope this helps
Regards
--
Mathias F????ler
my blog: http://starside.eu
Post by David Park
it works.
thank you very much Mathias.
now i know what the relation means :)..
Submitted via EggHeadCafe - Software Developer Portal of Choice
AJAX Web Service Driven Customers Table With Customer Details
http://www.eggheadcafe.com/tutorials/aspnet/4c3d2726-d99e-4f83-9e49-0d4867b6271a/ajax-web-service-driven-customers-table-with-customer-details.aspx
yassine dinari
2010-08-10 12:22:34 UTC
Permalink
i really did not get the answer.
my supervisor asked me to add a new field in ledgerjournaltrans so when i valid it gets stored in ledgerjournaltrans but not in ledgertrans.i need something so that the value which got before validating it should be stored in ledgertrans too.
thanks.
Post by David Park
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.
In my report I need one more relation field which is AccountNum between two
tables.
I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.
is there any way to do this
thank you
-david
Post by Mathias
Hi David,
set the autorelation on ledgertrans to no. to do so you go to the table
ledgertrans in your report query, go to properties and set property Relation
to No.
after that you can/have to create the relation by yourself.
i hope this helps
Regards
--
Mathias F????ler
my blog: http://starside.eu
Post by David Park
it works.
thank you very much Mathias.
now i know what the relation means :)..
Post by yassine dinari
i really did not get the answer.
my supervisor asked me to add a new field in ledgerjournaltrans so when i valid it gets stored in ledgerjournaltrans but not in ledgertrans.i need something so that the value which got before validating it should be stored in ledgertrans too.
thanks.
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Control?s Default Style or Template by Extending the WPF Designer in Visual Studio 2010
http://www.eggheadcafe.com/tutorials/aspnet/d1ad0a33-d815-4083-8e97-c234fd661095/wpf-controls-default-style-or-template-by-extending-the-wpf-designer-in-visual-studio-2010.aspx
julierta
2010-10-03 16:18:58 UTC
Permalink
Post by yassine dinari
i really did not get the answer.
my supervisor asked me to add a new field in ledgerjournaltrans so when i
valid it gets stored in ledgerjournaltrans but not in ledgertrans.i need
something so that the value which got before validating it should be
stored in ledgertrans too.
thanks.
Post by David Park
What I am going to do is making new report consists of LedgerTrans and
LedgerJournalTrans.
LedgerTrans has a relation with LedgerJournalTrans by
LedgerTrans.TransDate == LedgerJournalTrans.TransDate &&
LedgerTrans.Voucher == LedgerJournalTrans.Voucher.
In my report I need one more relation field which is AccountNum between two
tables.
I want to do this without any changes on tables itself.
when I added relation field on report\datasource, it didn't work.
is there any way to do this
thank you
-david
Post by Mathias
Hi David,
set the autorelation on ledgertrans to no. to do so you go to the table
ledgertrans in your report query, go to properties and set property Relation
to No.
after that you can/have to create the relation by yourself.
i hope this helps
Regards
--
Mathias F????ler
my blog: http://starside.eu
Post by David Park
it works.
thank you very much Mathias.
now i know what the relation means :)..
Post by yassine dinari
i really did not get the answer.
my supervisor asked me to add a new field in ledgerjournaltrans so
when i valid it gets stored in ledgerjournaltrans but not in
ledgertrans.i need something so that the value which got before
validating it should be stored in ledgertrans too.
thanks.
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Control?s Default Style or Template by Extending the WPF Designer
in Visual Studio 2010
http://www.eggheadcafe.com/tutorials/aspnet/d1ad0a33-d815-4083-8e97-c234fd661095/wpf-controls-default-style-or-template-by-extending-the-wpf-designer-in-visual-studio-2010.aspx
Loading...