Home > Forum > General > Linking two reports via URL parameter

Linking two reports via URL parameter
0

MVP

Hey everyone,

I have two reports — one for Vessels and another for Shipments.
On the Shipments report, I’ve set a URL filter like this:
VESSEL_CODE = vesselCode

Now I’d like to link these two together.
Basically, I want to add a column on the Vessels report that links directly to the Shipments report, automatically filtered by the vessel’s code (using the URL parameter).

Ideally, the solution should also work when exporting/importing the process between test and production environments.

Has anyone done something similar or found a neat way to pass parameters between reports like this?

Thanks in advance!
Martin

MVP

Hi Martin,

there's an ugly workaround for the transport issue.

I've defined constants for each required id. In my case it was application and dashboard.
Then I used a calculated column to fetch the value from the constant using the GUID.


https://daniels-notes.de/posts/2021/deploying-database-scripts#getting-constant-values-in-reports

This blog post is already four years old and we are still limited to the existing variables..

Best regards,
Daniel