[solved] Dashboard kind of report

[BIsrik]

Hi,

I have a report which looks like a dashboard report. The output format of the report is attached. The data in the table are captured for every project and for every week. In the report i need to show the data as per the monthly information. The colurs in the bar represents the status of the project. like green means good, red mens danger.

I came to know that cubes can be in C8. if I create a cube and publish it in C8, can i get this report. Or is there any javascripts that can be used.

Please let me know any solution for doing this report.

Srik

[BIsrik]

presently i am trying with cross tab, will post the solution when i get it. Meanwhile you guys have any idea plz update..

Srik

[mikegreen]

A cube can be used in Report Studio in C8, yes.  However, I don't see how it would really help you here.  A cube is going to be even less flexible when trying to do the custom HTML/conditions to make the progress bar lines.

I've seen project status charts like this in Cognos demos.  It is thru the use of IF statements to determine a quantifiable status (1=green, 2=yellow, etc) and then display a dynamic image or conditional formatting attribute.

Regards,

Mike

[BIsrik]

I could achieve through cross tab itelf. Thanks for the feedback from you all.

Srik