Hi
I've published paginated report to the portal. They're obviously on premium capacity and all that. But the problem is with report crashing when parameter is changed. The report consists of several pages which are implemented as subreports. All the pages work fine unless there's need to change portfolio-parameter.
The report is about financial data and it has parameters: Start date, End date and Portfolio. These are inserted in the portal. When I view a Portfolio, e.g. AAA01, the report works fine. But when I change the portfolio to AAA02 the report crashes. The report works again when I refresh by using F5. But I can't leave it at that, now can I?
Start, End date and Portfolio are all parameters send to SQL DB with the query.
The text displayed as error message reads: "Data retrieval failed for the subreport. "Name goes here". locat at: "The name of the report again". Pleace check the log files for more information." The funny part about this is that even this text doesn't render well it's missing its bottom half. Which log might this be referring to? Is it found on PBI admin portal or should I check the DB logs on-prem?
So any ideas? Thanks!
