My application is on https. I have a button on asp.net page under this https site. On clicking this it opens SQL Server Reporting Services 2005 reports. The Repport server is on another machine but a http site. The report has many subreports in it. One sub report has pie chart and on clicking a slice of the pie chart it should reload the report with different parameters. So all the sub reports are refreshed with new parameters.
When I access this report from https site as mentioned above, I get following problems -
1. Some of the sub reports are not loading, shows as blank.
For this problem, I cached the reports. I set this property in report manager for each report. After chaching for the first time the reports are not coming but afterwards they are coming. But I dont find this problem to be good solution as we dont see the subreports first time. Also the reports we are seeing as not actual time data, just some minuted old.
2. Second problem is- When I click the slice of the pie chart, it was supposed to reload the report with different parameter. But it does not load on first click. It loads on second click.
Above problem dont occur if access the report server from another http application.
Not sure whether the problem is coming because I am trying to access from https to http site.
Please help . I have already spent 2 days on this problem, but no help.
Any help or direction is appreciated.