Avatar of Simone B
Simone B
Flag for Canada asked on

Can't reach subreport through url sent by email

I have an SSRS report, containing a subreport, that's posted and works properly in Report Manager. When I send the report url via email, the main report opens correctly, but the subreport throws an error when I attempt to drill into it. Below is the error. The error log does not have any further details.

Thanks in advance for any help you can provide.



Reporting Services Error
________________________________________
•      An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
o      The URL-encoded form data is not valid.
¿      Operation is not valid due to the current state of the object.
________________________________________
SQL Server Reporting Services
Microsoft SQL Server 2005SSRS

Avatar of undefined
Last Comment
Simone B

8/22/2022 - Mon
santhimurthyd

Navigate to the Path to get more details on the error as whether it's due to Insuffecient Privileage error in Data

C:\Program Files\Microsoft SQL Server\<<Your SQL Instance>>\Reporting Services\LogFiles
Simone B

ASKER
Thank you. I found the error in the log, and it's not due to insufficient privileges. My group all has admin access to the server, in any case. This is the error in the log file (same as the one originally posted):

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Web.HttpException: The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object.
ASKER CERTIFIED SOLUTION
santhimurthyd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Simone B

ASKER
Thank you. We actually tried that earlier today, but it hasn't made any difference. This is really stumping our team.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Howard Cantrell

One \thing you might try is to run report export as a pdf then email the report.
Simone B

ASKER
Thanks for your suggestion. But this is an audit report sent as a finalstep in SQL Agent jobs. It wouldn't work very well as a subscription. The report is designed so that we can drill down to problem areas.
Simone B

ASKER
It turns out that we had to move the location of the MaxCollectionKeys line in the config file, although your response pointed us in the right direction. Thank you.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.