Report with Chart & Grid

Rick Kushner
Rick Kushner
in AppWorks #1

I think it should be a simple report. It is simple in MS Reporting Services, but MSRS doesn't allow you to click thru a row in a grid to the underlying folder.

 

The grid gives a detail view of the underlying business object: mainly folder names and a status field. The pie chart gives a summary view: count by status. However, the first thing is that I don't see how to do a row count in the chart. It forces me to choose one field for the x- and one for the y-axis. So I create a sceond BO, a summary view on the first which gives two columns, status & count.

 

Neither the chart, nor the grid, lets me choose the business object. When I have two BOs in the report, all of the fields in both the grid and the chart come from the same BO!!! I need to populate the grid from the detail BO and the chart from the summary BO.

Tagged:

Comments

  • Jerome_Pearce
    Jerome_Pearce
    #2

    I agree, and it has already been suggested, that you should be able to have more than one Business Object per report. A separate one for the report and for a chart, or header may be better, would seem suitable.

     

    In the mean time, a good e-workaround is to use the ability to summarise BO fields. You could probably just use summary fields for the chart.

     

     

     

    [edit:

     

    RKushner wrote:

    the first thing is that I don't see how to do a row count in the chart. It forces me to choose one field for the x- and one for the y-axis.

     

     

    I see you were asking how - just select the series, check the 'summary function' property, and select 'count' in the 'function' property dropdown. You can also selct min, max, sum & average.]

  • Rick Kushner
    Rick Kushner
    #3

    I don't have a  'summary function' property. Maybe that came out in SR2 or SR3...

  • Rick Kushner
    Rick Kushner
    #4

    I just saw the "Summary Function" property of the Chart Series Control on pg 267 of the designer user guide for v9.0.1!!!

     

    But I am clicking on everything, everywhere and I can't find it. In the Charts menu bar, the Series block of three icon/buttons, I click the little square, pop-out button at the lower right. I get name, scale type, x values, y date, show as %, explode pie chart, use top N, and notes, and that's all!

  • Jerome_Pearce
    Jerome_Pearce
    #5

    Add a chart and select the BO, select the X axis, then Y axis, and the 'summary function' property then appears.

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform