In an existing ssrs 2008 r2 report, I have 49 rdls that can be clicked and there is an action link to the report. There is one particular link called 'archived' that takes longer to obtain data from than the other links do.
The main query behind the archived report is not very long. However I do not have any idea why that particular link would take such a long time to run.
Thus can you tell me what I can look at to determine why that particular link takes so long to produce the report?