none
Subreport in report manger does not show

    Question

  • i have a main report..and this main report has 2 subreports.. wheni run this on bids it just works great.. i then deployed it in report manger and tried to run ...the part of the report where subreport is located throws error saying
    Error: Subreport could not be shown.  scren shoot below.. (But this report works just fine on bids))

    suggest please
    • Edited by Dkuud Monday, March 18, 2013 10:05 PM
    Monday, March 18, 2013 10:05 PM

Answers

All replies

  • can you try to run the subreport by itself first in report manager please
    Monday, March 18, 2013 10:25 PM
  • OK two things here.. i have a subreport by itself this runs good.. but this report is pulled in as subreport into another main report it throws me an error..


    • Edited by Dkuud Tuesday, March 19, 2013 2:07 PM
    Tuesday, March 19, 2013 2:01 PM
  • are you passing any parameters from the main report to the subreport? check if correct data is being passed and check parameter data type

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

    Tuesday, March 19, 2013 2:16 PM
  • yes i am passing parameter..everything runs fine when i run it on Bids(i am able to see the subreport data in main report)..but when deployed to report manger and when you try to run on report manger it throws an error

    • Edited by Dkuud Tuesday, March 19, 2013 2:31 PM
    Tuesday, March 19, 2013 2:31 PM
  • use report manager goto design, and check properties of your subreport. It maybe still be pointing to your custom dataset used in BIDS and not the shared dataset in SSRS.

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

    Tuesday, March 19, 2013 3:06 PM
  • it is so weird..

    i just deleted the sub report and re deployed them back...worked fine..

    Tuesday, March 19, 2013 3:51 PM