Unanswered: CRS 2008: Publication Distribution Problem.
I have created a Publication in CRS 2008 to report burst content to a bunch of CR Users (Enterprise method used with single query per user ), based on profile values created.
The bursting works great. Each filtered report is placed into each CR users inbox.
My problem is that the report I am 'bursting' contains a sub-report, and when the sub-report is accessed during report viewing, the user is prompted to enter the Database User and Password.
I don't understand why this is happening, as these credentials are saved with the report and the publication. Also, when the report is run/scheduled independently and viewed (with sub-report), the user is never prompted.
Could this be a bug? Can someone help me fix this ASAP. Spent a lot of time on it.