Share via

ssrs drill thru to a report in a different folder

db042190 1,516 Reputation points
2021-02-04T12:27:19.063+00:00

hi we run 2014 developer in our dev environment and we use vs 2017 to develop reports.

I want to drill thru from my report A to a report B in a different folder. right now i have my report drilling thru to itself. and have deployed it to our dev server RM path datawarehouse/folder1. B is on that server already in differentparentfolder. differentparentfolder is at the same level in rm as datawarehouse.

i dont care a whole lot if this drill thru works in vs preview mode . I'd be content deploying A and trying the drill thru there a couple of times till i get it right.

I looked at the xml code where the drill code is . i'm also looking at the action user interface for "go to report". it isnt obvious if perhaps using slashes in one of those 2 places i can get this set up correctly. or if perhaps i have to resort to using a url which as i recall has challenged me before in this environment. if i use slashes, ssrs would have to understand that relatively speaking, i'm going up one folder , then "over" to another folder at the same level as datawarehousereports, and finding the drill thru report there.

i tried this in the action's function but got the error you see below.

"\differentparentfolder\B"

does the community have any recommendations?

Error [rsInvalidReportNameCharacters] The DrillthroughReportName for the text box 'textbox8' is not valid. Item names cannot contain the following reserved characters ;?:@&=+$,*<>|".

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
Accepted answer
  1. db042190 1,516 Reputation points
    2021-02-05T22:19:07.58+00:00

    i found the answer. By putting the = sign before the value in double quotes (see below) in the report name function, the linkage across folders worked after i deployed the master report. I didn't have the = sign previously.

    I didn't need to use report builder to do this. I don't know if backward slashes would have been just as good.

    ="/differentparentfolder/B"

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-02-05T06:31:21.657+00:00

    Hi @db042190 ,
    According to your description, I suggest you use Report Builder. The report builder can directly connect to the RS server, and design reports in different folders as the object of drill through.Unfortunately we cannot do same operation in SSDT. This is kind of limitation of SSDT.
    For report operations, the drill-through report must be located on the same report server as the main report. For more information, see Add a Drillthrough Action on a Report (Report Builder and SSRS) and Specifying Paths to External Items (Report Builder and SSRS).
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.