CODEWITHSUNDEEP
.netvb.netformsreporting-services
Yadder Aceituno
Yadder Aceituno

Reputation: 83

Open form from SSRS Report

I don't know if is it possible, but could I click a row and then open a form from my project and use the row clicked as parameters to the form.

Is that possible to do?

Thank's in advance.

Upvotes: 0

Views: 162

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

Assuming your form can take parameters on the URL then you can do this.

You need to set up the url as a navigation link. Let's say you want to pass the customer details to your form. So your field expression will simply be Fields!CustomerName.Value like normal. To turn the field into a navigatable link, right-click the cell, select Text Box Properties... then Action. Select the Go to URL radiobutton and enter your URL for your form:

="http://myserver/myform?CustomerID=" & Fields!CustomerID.Value & "&Name=" & Fields!CustomerName.Value

This will turn the displayed field in the cell into a clickable link that passes the customer id and name to the form on the URL.

I also change the Font.Color to Blue to indicate it is a link.

Upvotes: 1

Related Questions