Web portal and DotNet restricted Drilldown

[DavidQR]

We have to deliver a web based, drilldown graph (clickable barchart with an average line graph overlay), and it operates within a MS dotnet and Plumtree portal environment.

Furthermore, certain window specific features are disallowed (e.g. Crystal Report viewer) due to the possibility of end-user having a linux (or other nonwindows) OS.

So far we have been able to do by code, generating a graph programatically without use of report viewer, but we get stuck in making it clickable and have an overlay as well.

We cannot find any tutorial on graph creation, one book discuss the use of graph in crystal report viewer, but as said above it is disallowed.

We do not know how to progress this further, anyone got suggestions or specifics that can help us?

 

[synapsevampire]

You might use the Crystal DHTML or Java viewer.

I would have tried to help with a charting tool for your code based method, had you shared what type of code you're using.

-k

 

[DavidQR]

Kai,

Thanks for taking interest in our problem. Right now all we have done is passed one dataset to Crystal, to be outputed as a PDF file which the Plumtree portal can show to the enduser.

We actually have 3 datasets, besides the bar graph we would like two separate line graphs to be overlayed in the same Crystal output graph. But we do not have the expertise to set up Crystal in a way that all three sets of data can be passed together to Crystal.

And the additional need by the user is to have a means for him to click on the appropriate bar so he can get a drill down to exposing the composition of the selected bar.

Without Crystal viewer, due to its Microsoft dependency, we do not have a solution. Also solutions that require installation of code on client workstations are out.

For your information, we are restricted in what can be used in the portal environment, due to security considerations. Use of specialised tools may mean an extended period of compliance testing, even if we meet the requirement of obtaining an approved "business case" for its use.

As to using DHTML, it may work, but we need to get security clearance again. Is it easy to overcome/solve the above restrictions/problem if DHTML is approved?

Thanks again for your sharing your insights and expertise.

David