How to launch a context sensitive report

[Former Member]

Hello experts,

I want to be able to launch a report from the Master Agreements page and use some data from the current Master Agreement to populate parameters of the report.

Everything I try *almost* works:

Try	Result
Adding the report to the "Reports" drop down	Works fine, but can't hard code my parameters.  Is there some way to pass them in dynamically like is used with query links?
Added a URL extension field. Write URL in on Validation script before saving so it gets the correct parameters.	Almost works, but if I don't hard code the server/port it opens in a new window. (I need it to be same window.)It opens in same window if I hard code the server/port, but that will mess things up when there are database write-backs to refresh the non-prod areas.  Is there some way to make it refer to the current server like a relative link AND open in the same window?

Any ideas would be very appreciated!

Thanks,

Mike

[Former Member · Accepted solution]

Hello Mike,

You don't need to have all parameters built-in to the report itself.

For reports within the "Report" dropdown (aka defined in Document Report Configuration) you can have only one parameter that will pick up the current document. Then you can build your query based on that by using joins.

If the parameter is named "CurrentDocument" it will automatically pick up the MA you are executing the report from.

Regards,

Bogdan Toma

[former_member207877]

Hello Michael,

You can aslo use as below.

Regards,

Raj