I am creating a Website which shows reports based on data which is fetched from the database(MS SQL) using query and dataset.
The reports are crystal reports, and has charts with Drill Down enabled. There are 3 groups on which the drill down is created.
I am using Visual studio 2008 to do this.
Now when I debug and run it directly from VS2008, as the reports run locally I am able to Drill down the reports to its last level i.e. up to level 4.
But if I host this Website in a server using IIS 6, then I am only able to drill down up to level 2.
If I try to drill after level 2 then the report goes back to level 1. In level 2 if I click anywhere within the bar chart not specifically in the bars containing the data then also it takes me back to Level 1.
Please kindly give some suggestion or solutions.