Open Form with filters on multiple datasources Via Hyperlink in SSRS Report

(0) Share

Report

Posted on by Community member

Hello all,

I need the hyperlinks in my ssrs report to open a form with filters on multiple datasources. For instance, if I click on account number in my ssrs report, it should open the Voucher transactions (LedgerTransVoucher) form with filter on Ledger account (GeneralJournalAccountEntry.LedgerAccount) and Date (GeneralJournalEntry.TransDate) fields using report tmp table (for account) and parameter data (for date).

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

Open Form with filters on multiple datasources Via Hyperlink in SSRS Report

Hi,

The voucher transactions do not support a direct deep link. It is possible to add custom URL parameters and read these additional parameters to set a range when opening the form.

Suppose you have the next URL for opening the voucher transactions:

https://myfno.operations.dynamics.com/?cmp=usmf&mi=LedgerTransVoucherQuery

You can then add custom parameters, like the example below:

https://myfno.operations.dynamics.com/?cmp=usmf&mi=LedgerTransVoucherQuery&account=102010&date=08012024

There are some examples in the application of how to read and work with the additional parameters. You can also download a free utility from my blog site which is also reading and changing the URL: New option to change the user default or session language - Dynamicspedia

When you find out how to read the parameters from the URL, you can apply ranges on the voucher transaction form using a form extension class.