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. Thank you Sabyasachi
you mean this is not an issue with IIS configuration..... cause locally its working perfect but when hosted on IIS server i am facing the drill down problem... thanks
mrbonny7
3 Posts
Cannot Drill Down more than group level 2 in crystal Reports when hosted as website in IIS 6.0
Dec 01, 2012 07:41 AM|LINK
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.
Thank you
Sabyasachi
Rovastar
3321 Posts
MVP
Moderator
Re: Cannot Drill Down more than group level 2 in crystal Reports when hosted as website in IIS 6....
Dec 01, 2012 10:07 AM|LINK
I think this is coding issue.
I would ask on a relevant forum like:
http://forums.asp.net
mrbonny7
3 Posts
Re: Cannot Drill Down more than group level 2 in crystal Reports when hosted as website in IIS 6....
Dec 01, 2012 10:34 AM|LINK
you mean this is not an issue with IIS configuration..... cause locally its working perfect but when hosted on IIS server i am facing the drill down problem... thanks