I am trying to enable drilldowns to the journal entry within the Trial Balance Detail report. I am using the Action URL - dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=(Fields!JRNENTRY.Value)&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1
For example...in the report there is a journal entry 126 that I would like to drill back to get the detail for. When the report runs instead of evaluating the JRNENTRY.Value field as 126 (the Journal entry it represents) it just produces the link without evaluating the field.
This is what I am expecting:
dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=126&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1
Buth this is what is produced
dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=(Fields!JRNENTRY.Value)&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1
Additionally, if I manually override with the journal entry number and paste it into the URL. It appears as though this is invoking the Journal Entry window rather than the Journal Inquiry windows so I receive an error that the entry is already posted. Is there a method to open the Journal Entry inquiry window in the same manner.
Any help is greatly appreciated.
*This post is locked for comments
I have the same question (0)
