QUESTION ABOUT HYPERLINKS

[IncredibleVolk]

I currently run a DTS package where the results are pushed into Excel using an ActiveX script. The results are a summary (or count) of fields in a table. I'd like to create a hyperlink that will allow the user to click on the cell to get more detailed, drill-down information. I was wondering if it's possible to substitute the address field in this hyperlink for an sql query that will display the drill-down results when the user clicks on the cell. The value is already stored in the cell, I'd just like the user to get detailed account information about that value.

oSheet.Hyperlinks.Add oSheet.Cell(iRow,iColumn), "

http://XXX/XXX/",

, , ""

 

[ookete]

Is this a Reporting Services question? If it's an Excel question you may want to try another forum. As far as Reporting Services goes... yes, you can create drill-downs on fields to other reports or graphs as you see fit.

 

[IncredibleVolk]

How? I'd like to create a stored procedure that points to a website that retrieves that information when I click on the hyperlink. How's it done?

 

[ookete]

Well, I don't know if you can put hyperlinks to external websites inside of a data table, but you can make it so the drill-through fields go to another Reporting Services Report. You wouldn't do this in a stored procedure, but in the Report Designer interface when you create your report.

In Report Designer, click on the text box that contains the field you want as your link. Then go to Properties and select the Navigation tab. You will see a little radio button labeled "Jump to Report". Select your second report (the one they link to) in the provided pull-down. Then you pass along any parameters needed by clicking the Parameters button.

For example, say your first report shows sales for all employees in a company. You want them to be able to click on a salesperson's name and open a second report that shows employment details for that person only. So in Report Designer, you go to the properties of the Employee field, select "Jump to Report" and fill in the 2nd report name. In parameters, you would put something like

[b]Parameter Name   Parameter Value[/b]
EmployeeName     =Fields!Employee.Value

I hope this helps.

 

[xlbo]

How exactly is this related to the SQL Server REPORTING SERVICES product ??

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question