Are you trying to drill down from an SSRS report to another more detailed report? Or are you trying to drill from a SSRS report to a specific place in CRM? I think there's already an answer for you posted to this page if you're wanting to drill to another report. If you want to drill down to a specific spot in CRM, here's some info for you:
What do you need to find out ahead of time in order to make this work?
The only things you really need are:
• Figure out what page you want to drill down to
• Once you have the page identified, determine the context data that you need in order to open the page (ie: a constituent ID, or a transaction ID, etc.)
EXAMPLE: you might want to let users click on the date of a transaction in a report, and have that action take them to the transaction detail page. The name of the page is Revenue Transaction Page, and the context you need to provide is a transaction ID. Now you're ready to add the hyperlink to your report.
STEP 1) In the query that pulls the data for your report, you need to add in a column that builds a specifically-formatted url. The column alias is SUPER IMPORTANT because it will be used in future steps so make it something that stands out to you.
http://www.blackbaud.com/<linkname>?<linkname>=' + convert(nvarchar(38),<yourIDcolumn>) as <linkname>
Here is how this looks in the query. We want to be able to drill down to the Revenue Transaction Page for a specific transaction ID. This query comes from our datamart, but you get the idea -- your query needs the financial transaction ID in order to link to the revenue detail page.
select top 15 rm.FTDate
,'http://www.blackbaud.com/FTlink?FTlink=' + CONVERT(nvarchar(38), rm.FTID) as FTlink
from RecognitionMart rm
where rm.ConstituentID = @ConstituentID
order by rm.FTDate desc, rm.RevRecAmount desc
- The FTID column in the RecognitionMart table is the FinancialTransactionID, which is the context id you need to pass to the Revenue Transaction Page.
The column alias FTLink is what determines what goes in the url after www.blackbaud.com/ . So if you called your column alias Bob, then the url would have been:
http://www.blackbaud.com/Bob?Bob=' + convert(nvarchar(38), rm.FTID) as Bob
Don't worry that the url doesn't make any sense with www.blackbaud.com -- it really isn't going to go to that url. CRM interprets that in such a way as to go to your current CRM app. SO, the link magic will only work within CRM if you use this specific url !
STEP 2) I deployed this report on a tab on the Constituent page, so I added an AlterExistingPages section to my Report specification. The bit that's related to getting the link working is the Action that I called "Goto transaction" -- notice it specifies a LinkFieldID = FTLink (the column name from Step 1), the target page you want to drill down to, and the action context is the SectionField which is also set to FTLink. Keeping the column name consistent is the key making this work!
<Tab Caption="Recognition Summary"
<Section Caption="UConn Recognition Summary"
<common:ParameterValue ID="ConstituentID" xmlns="bb_appfx_commontypes">
That should do it. :)