Report with Chart & Grid

Rick Kushner

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.

Jerome_Pearce

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.]