My ssrs subreports working fine in visual studio where failing in ssrs manager with rrRenderingError

MSBI_Developer_1990 41 Reputation points
2023-07-05T20:31:13.7733333+00:00

Hi Friends,

i am having Main ssrs report with 5 sub reports in it.

Ex: 1. HR, 2.Sales,3.Accounts, 4.Marketing 5.Customers.

Based on user selection in the parameter they run the reports.

Its working fine in visual studio locally with test credentials. then i have uploaded to test server.

There one strange error i am facing . if i run HR and other Reports individually in ssrs manager it is working fine.

When i run through Main report its showing below error.

Can you please help me in this

SIT

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.
3,063 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2023-07-06T01:28:46.28+00:00

    Hi @MSBI_Developer_1990

    There are many situations that can cause this error.

    I found this thread for you that has the same error as you: https://stackoverflow.com/questions/27393151/ssrs-object-reference-not-set-to-an-instance-of-an-object, maybe you can refer to the discussion there.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.