Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I have a matrix with totals and hyperlinks - the hyperlinks are wrong Expand / Collapse
Author
Message
Posted Wednesday, September 11, 2013 3:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:06 PM
Points: 1,068, Visits: 416
I have a matrix report that i added customer hyperlinks to jump to a url with specific parameters. It seems that the report is automatically creating the hyperlinks for the total columns and the urls are wrong. How can I customize the links?

I have attached what the matrix looks like. There are actually 3 matrices. Is it possible to edit the url for the subtotal?






  Post Attachments 
Matix.png (5 views, 57.05 KB)
Post #1493918
Posted Wednesday, September 25, 2013 6:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hi

I think you can do this with the InScope() function.
Sorry, but I don't remember well how to use it.

In 2008, you can edit the total cells.
Post #1498297
Posted Wednesday, September 25, 2013 5:12 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:06 PM
Points: 1,068, Visits: 416
I was able to figure it out with the inscope function
Post #1498628
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse