SQL Server 2008, SSRS 2008 R2
I'm creating a report that shows 12 rolling months with rows of:
Beginning Bal
Receipts
Outflows
Ending Bal
This will be exported to Excel.
What they would like to be able to do is, in Excel, click on the Receipts cell
and hyperlink to a xls tab in the same workbook that would list the receipts detail for the 12 months.
Same with outflows.
I think the way to do in SSRS is with a subreport or two, but I'm not sure how it will export.
Has anyone done or attempted something like this?
I'm creating a report that shows 12 rolling months with rows of:
Beginning Bal
Receipts
Outflows
Ending Bal
This will be exported to Excel.
What they would like to be able to do is, in Excel, click on the Receipts cell
and hyperlink to a xls tab in the same workbook that would list the receipts detail for the 12 months.
Same with outflows.
I think the way to do in SSRS is with a subreport or two, but I'm not sure how it will export.
Has anyone done or attempted something like this?