SSRS subfolders in Visual Studio Report Server Project

Question

I am using SSRS 2008. Currently everything works find so long as I put all reports in the Reports folder of the Report Server Project in Visual Studio.

I attempted a work-around, which is to have multiple Report Server projects, each pointing to a different folder on the report server. This has the side effect of not letting me reference the sub report from another project.

So, is there a way of referencing a sub-report from another project and still have the ability to preview?

Is there a way to get sub-folders in Report Server project?

Answer 1

it's not built-in to SSRS; but there is a workaround. Simply keep the reports under one project (to allow the reference) and manualy control the deployment location per report.

If you go this route, you may want to look automating this by creating a deployment script using rs.exe

rs.exe

There are also some attempts at solving this on codeplex; but I haven't had a chance to take a look at this yet: rsbuild

Answer 2

I know it's a long time since the question was first asked but, if anyone is looking for an answer these days like me here's what I was able to do.

Move all your reports into whatever folder structure you want. Then edit your .rptproj file and find where your report item group is. It will look something like:

  <ItemGroup>
    <Report Include="Report1.rdl" />
    <Report Include="Report2.rdl" />
  </ItemGroup>

Just update those file names to be the full path like this:

  <ItemGroup>
    <Report Include="Folder1/Report1.rdl" />
    <Report Include="Folder2/Report2.rdl" />
  </ItemGroup>

Reload your report project and it works.... (well it does for me!) So far everything seems to work for me.