How to add/enable view details for SSRS Report Parameter

(2) Share

Report

Posted on by Ramkishor reddy

244

Hi All,

I’m working on a SSRS report how do I enable View Details functionality for a report parameter when we right click on the parameter . I want to achieve when right click on the parameter it should show 'view details' , when click on view details it should navigate to a form.

Thanks in Advance!!.

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (8)

Answers (1)

Martin Dráb 236,570 Most Valuable Professional on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

The EDT used for the parameter must have a reference to a table.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,191 Super User 2025 Season 2 on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

Hi Ramkishor,

To answer the first question View details through report parameter, you can add a link through the prepromptModifyContract() method in the controller class. Martin has given a resolution to the same.
References:

https://community.dynamics.com/forums/thread/details/?threadid=e7273ec0-003c-45f0-8ece-0e498411efdf

The other option is if you want to navigate to a form through a field on the screen then you can use an expression like this on a Text box property you can choose Go to URL, after adding a text field to the report.
="https://<organization-url>-operations.dynamics.com" & <optionally can add field values too>

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
Martin Dráb 236,570 Most Valuable Professional on at

Like (1)

Report
How to add/enable view details for SSRS Report Parameter

That's incorrect.

Adding the relation for View details in prePromptModifyContract() isn't possible. You could use that to set a value of the field, which is a different topic.

The linked thread is about something else.

The Action inside a report is also unrelated to View details on report parameters.

Was this reply helpful? Yes No
Ramkishor reddy 244 on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

Thanks for the reply Martin.

I set the EDT Reference table property to 'Target form data source table, still i am not able to get the view details.

Was this reply helpful? Yes No
Martin Dráb 236,570 Most Valuable Professional on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

Please tell us more about what you did.

A good idea may be trying it with existing EDTs first to see if and how it works and only then designing a custom solution. For example, you can try CalendarId (which has a reference to WorkCalendarTable.CalendarId).

Was this reply helpful? Yes No
Ramkishor reddy 244 on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

Hi Martin,

I developed a new SSRS Report, In that I added a custom parameter. The user requirement is when right click on that parameter it should show 'View Details' option when click on that it should navigate to master form.

For this what I did I created custom form and table , I added "Reference Table" property to my custom EDT(which I used in my report parameter) with the table which I used in my above custom form which I used in my report parameter.

Here, my doubt is should I create primary Index for the field in that table which is extends with my custom EDT and should I create relation as well . Could you please clarify my doubts !!.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,570 Most Valuable Professional on at

Like (1)

Report

How to add/enable view details for SSRS Report Parameter

The field must be unique, otherwise the reference wouldn't make a good sense. You want to uniquelly identify the record by the value of the parameter. Therefore the table should have a unique index for the field, but it doesn't have to a primary one. Typically it's the ReplacementKey.

Note that you should have decisions like what will the primary key when you designed the table.

You can't create new table relations; table references are used instead. Refer to the example I gave you - CalendarId:

Was this reply helpful? Yes No
Ramkishor reddy 244 on at

Like (0)

Report

How to add/enable view details for SSRS Report Parameter

Thanks Martin!!.

I am able to get 'view details' for my report parameter.

Was this reply helpful? Yes No