A few question on the Grid

[rtibmx]

I have a three main questions about using the Grid that I'm hoping someone can shed some light on please:

 

 

 

1) I am using a 3D pie chart followed by a grid. The purpose of the grid is to display all the labels and values in a tabular fashion, as shown in the documentation.

 

 

 

However I have done some custom grouping when creating the pie chart and therefore wondering how to compensate for this in the grid.

 

 

 

In summary I do my query from the database and usually wind up with what would be over 20 slices for the piece chart. However only the first 10 slices are significant - the other slices would just be "noise".

 

 

 

So I have logic that adds the top ten largest items to the pie chart, and then for all other items counts the totals and makes one entry in the pie under a slice called "Other". This works great. (BTW I assume there is no automatic way to tell FusionCharts to group insignificant data values all together, but if there is please let me know!).

 

 

 

However when it comes to the grid, I want to show ALL the items and values, instead of the lump some under Other. I have accomplished this by making two sets of the XML. The first set has the values grouped into Other, and the second set does not do the grouping.

 

 

 

This is working great. However the Grid assumes there are colors assigned to the insignificant values, when in fact there are none displayed on the pie chart. So when the grid lists these items out that don't appear on the pie chart it has a color code key next to it that doesn't match anything in the pie chart.

 

 

 

What I've done now is that I've assigned a color of FFFFFF to the items that don't appear in the pie chart. So now the items that have been grouped in the pie chart display in the grid with white next to them. However I'd rather it not display any color there or somehow make the color transparent for just these lines so it didn't display. Is there any way to do this or a different approach I can take to get the same or similar result?

 

 

 

EDIT: I believe I solved this particular issue. What I did was assign a specific color to the Other group. Then in my grid I assign that same color to all the items that make up the Other group. This works out very nice!

 

 

 

2) I want to make the Grid height large enough so that it will fit all the elements in the list on one page. However if I make it bigger than the number of elements, the Grid adds large space between each item so that they evenly fill out the remaining space. This is undesirable. And the various controls for the margins and padding don't seem to apply in this case.

 

 

 

So in other words I want to set the itemstoshowonpage to x, where x is all the items there are in total, and then have the Grid create the chart to the proper height accordingly to accommodate that. How can this be done?

 

 

 

3) In a few cases I do want to have paging in the grid. However I noticed that at least on Firefox (haven't tested IE yet) when I put the mouse over the "next page" triangle icon in the grid it does not turn into a hand icon. And when I click on it, instead of it going to the next page, it turns into the hand icon. Then when I click again, then it finally goes to the next page. Is this a bug? How can I resolve this?

 

 

 

4) The documentation for the Grid shows a few samples where the grid starts immediately after the pie chart, without any space of line break. This is the same behavior I would like.

 

 

 

However when I try this I wind up with a small break between the bottom of the pie chart background and the top of the grid. How can I close this gap. I am using back to back DIVs, one for the pie chart and one for the grid, yet this space still appears.

 

 

 

Thanks!

Edited March 1, 2009 by Guest

[Guest Basundhara Ghosal]

Hi,

Could you please send us the sample code for the same.

Awaiting your reply.