How-To create Report Hot-links

[maevekcincy]

I have a report that I created from a view I created.
There are voucher-numbers on the report, and it would
be neat if the user could click on the voucher-number and
go to, say, the LedgerTrans form to see the voucher-info.
How can I make this link "happen"
on my report?

Thanks for your help!

- Maeve

[Luegisdorf]

Hi Maeve

Your data field (Voucher) needs a relation to a table, say LedgerTrans, then
it works.
But since you cannot create relations on views this will not work. You can
try to change the LedgerTrans.Voucher's EDT (assume your View is basing on
LedgerTrans). The new EDT should have an Relation to LedgerTrans.

But: I would not recommend this, because the voucher# is not unique, only
voucher# and voucherdate makes a proper bound.

Regards
Patrick

Post by maevekcincy
I have a report that I created from a view I created.
There are voucher-numbers on the report, and it would
be neat if the user could click on the voucher-number and
go to, say, the LedgerTrans form to see the voucher-info.
How can I make this link "happen"
on my report?
Thanks for your help!
- Maeve

[maevekcincy]

Thanks - that is helpful.
It turned out that I needed to link to the ProdCalcTrans Form/table,
from my created table (table only used for this report).
I created an extended datatype on the link-field,
that I then create a relationship for
that pointed to ProdCalcTrans.ProdId.

I had to modify the ProdCalcTrans form to be happy coming
from my new table - the form's init method and
the forms datasource findCaller method.
I did a mini-documentation on
this, if anyone is interested.

- Maeve

Post by Luegisdorf
Hi Maeve
Your data field (Voucher) needs a relation to a table, say LedgerTrans, then
it works.
But since you cannot create relations on views this will not work. You can
try to change the LedgerTrans.Voucher's EDT (assume your View is basing on
LedgerTrans). The new EDT should have an Relation to LedgerTrans.
But: I would not recommend this, because the voucher# is not unique, only
voucher# and voucherdate makes a proper bound.
Regards
Patrick

Post by maevekcincy
I have a report that I created from a view I created.
There are voucher-numbers on the report, and it would
be neat if the user could click on the voucher-number and
go to, say, the LedgerTrans form to see the voucher-info.
How can I make this link "happen"
on my report?
Thanks for your help!
- Maeve

[ashlesh patel]

can you please send that document which you have prepared.

thanks,
ashlesh



maevekcincy wrote:

Thanks - that is helpful.
25-Jun-10

Thanks - that is helpful
It turned out that I needed to link to the ProdCalcTrans Form/table
from my created table (table only used for this report)
I created an extended datatype on the link-field
that I then create a relationship fo
that pointed to ProdCalcTrans.ProdId

I had to modify the ProdCalcTrans form to be happy comin
from my new table - the form's init method an
the forms datasource findCaller method
I did a mini-documentation o
this, if anyone is interested

- Maev

"Luegisdorf" wrote:

Previous Posts In This Thread:

On Wednesday, June 16, 2010 4:52 PM
maevekcincy wrote:

How-To create Report Hot-links
I have a report that I created from a view I created
There are voucher-numbers on the report, and it woul
be neat if the user could click on the voucher-number an
go to, say, the LedgerTrans form to see the voucher-info
How can I make this link "happen
on my report

Thanks for your help

- Maeve

On Thursday, June 17, 2010 4:14 AM
Luegisdorf wrote:

Hi MaeveYour data field (Voucher) needs a relation to a table, say
Hi Maev

Your data field (Voucher) needs a relation to a table, say LedgerTrans, the
it works
But since you cannot create relations on views this will not work. You ca
try to change the LedgerTrans.Voucher's EDT (assume your View is basing o
LedgerTrans). The new EDT should have an Relation to LedgerTrans

But: I would not recommend this, because the voucher# is not unique, onl
voucher# and voucherdate makes a proper bound

Regard
Patric

"maevekcincy" wrote:

On Friday, June 25, 2010 4:42 PM
maevekcincy wrote:

Thanks - that is helpful.
Thanks - that is helpful
It turned out that I needed to link to the ProdCalcTrans Form/table
from my created table (table only used for this report)
I created an extended datatype on the link-field
that I then create a relationship fo
that pointed to ProdCalcTrans.ProdId

I had to modify the ProdCalcTrans form to be happy comin
from my new table - the form's init method an
the forms datasource findCaller method
I did a mini-documentation o
this, if anyone is interested

- Maev

"Luegisdorf" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Store ASP.NET Site Visitor Stats in MongoDb
http://www.eggheadcafe.com/tutorials/aspnet/3a73c6de-82a1-4690-a7aa-d0eda58203f7/store-aspnet-site-visitor-stats-in-mongodb.aspx

[ashlesh patel]

can you please send me that document.

Thanks,
Ashlesh



maevekcincy wrote:

Thanks - that is helpful.
25-Jun-10

Thanks - that is helpful
It turned out that I needed to link to the ProdCalcTrans Form/table
from my created table (table only used for this report)
I created an extended datatype on the link-field
that I then create a relationship fo
that pointed to ProdCalcTrans.ProdId

I had to modify the ProdCalcTrans form to be happy comin
from my new table - the form's init method an
the forms datasource findCaller method
I did a mini-documentation o
this, if anyone is interested

- Maev

"Luegisdorf" wrote:

Previous Posts In This Thread:

On Wednesday, June 16, 2010 4:52 PM
maevekcincy wrote:

How-To create Report Hot-links
I have a report that I created from a view I created
There are voucher-numbers on the report, and it woul
be neat if the user could click on the voucher-number an
go to, say, the LedgerTrans form to see the voucher-info
How can I make this link "happen
on my report

Thanks for your help

- Maeve

On Thursday, June 17, 2010 4:14 AM
Luegisdorf wrote:

Hi MaeveYour data field (Voucher) needs a relation to a table, say
Hi Maev

Your data field (Voucher) needs a relation to a table, say LedgerTrans, the
it works
But since you cannot create relations on views this will not work. You ca
try to change the LedgerTrans.Voucher's EDT (assume your View is basing o
LedgerTrans). The new EDT should have an Relation to LedgerTrans

But: I would not recommend this, because the voucher# is not unique, onl
voucher# and voucherdate makes a proper bound

Regard
Patric

"maevekcincy" wrote:

On Friday, June 25, 2010 4:42 PM
maevekcincy wrote:

Thanks - that is helpful.
Thanks - that is helpful
It turned out that I needed to link to the ProdCalcTrans Form/table
from my created table (table only used for this report)
I created an extended datatype on the link-field
that I then create a relationship fo
that pointed to ProdCalcTrans.ProdId

I had to modify the ProdCalcTrans form to be happy comin
from my new table - the form's init method an
the forms datasource findCaller method
I did a mini-documentation o
this, if anyone is interested

- Maev

"Luegisdorf" wrote:

On Tuesday, August 03, 2010 12:36 AM
ashlesh patel wrote:

document
can you please send that document which you have prepared.

thanks,
ashlesh


Submitted via EggHeadCafe - Software Developer Portal of Choice
Scrolling in WPF Toolkit?s Column Chart
http://www.eggheadcafe.com/tutorials/aspnet/0939d60c-8e17-4a27-b898-1fc772d2d6f6/scrolling-in-wpf-toolkits-column-chart.aspx