
Hello,
I have a requirement to implement a SSRS report and to have a drill through link action on a textBox containing "MainAccount" that gets you to transactions of that account in a specific date period.
To do that, I'm aware I have to use GenerateDrillThroughLink and pass the mainAccount + Date Period
As I searched in the internet, I understood that this method supports multiple values but must be on the same TableName. My values are from GeneralJournalAccountEntry (to pass value to MainAccountRecId)
and GeneralJournalEntry (to pass values to the AccountingDate field).
Can anyone confirm that the method GenerateDrillThroughLink supports only one TableName, and is there a workaround to this ?
Thank you in advance.