Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhare
Starting Member
2 Posts |
 Posted - 2011-05-31 : 18:11:46
|
| Hello,So I have two stored procedures. One pulls a list of all invoice numbers and brief sales information during certain dates (date, employee, total $, etc....High Level Sales info)I'd like to then be able to treat the invoice number as a hyperlink, linking to another SSRS report / Stored Procedure.This would enable a manager to list all sales within a week for example, but then also to act as though they are 'drilling' down to look at an individual invoice.Anyone know if it's possible to hyperlink like that? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-01 : 02:10:09
|
What you do is to create a separate report that shows the details for an invoice with the invoice number as a report parameter. Then, in your original report, you add an Action to the column with the invoice number and in the Action dialog you have the option to Go to Report and also add parameters: - LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
rhare
Starting Member
2 Posts |
Posted - 2011-06-01 : 17:21:29
|
Thank you!!! That's exactly what I was after.Clearly I was just looking in the wrong place.Cheers!quote:
Originally posted by Lumbago
What you do is to create a separate report that shows the details for an invoice with the invoice number as a report parameter. Then, in your original report, you add an Action to the column with the invoice number and in the Action dialog you have the option to Go to Report and also add parameters:- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
|
|
|
|
|
|
|
Hyperlink to call another Stored Proc/Report