Hi - I give this exact example in my new book. I'm going to give you the overview here and you might be able to get it working. But to be honest, it's pretty complicated and there are a few pages of descriptions and explanations in the book. Also, I''m on vacation right now and didn't bring the book with me. So I'm going from memor yhere. If you can't get it working, then you should pick up a copy of the book.

Here's how it works: You have to have a formula that creates a global array for each column. Modify the cell in the cross-tab so that you attach a formula to one of the properties and that formula populates the array with the CurrentValue() function. Use the row/column value to determine which element in the array to populate.

Once you get to the last row, the first two columns in the array will be populated and then you can do the % calculation. Create a new formula doing the % calculation and attach it to the ToText property of the cell in the last column.

Again, this is a bit vague b/c I don't have my book with me to reference, but even if I did, it's too complicated to explain perfectly in a forum post. So hopefully, this will get you going in the right direction. If not, the book is a little more than $30 on Amazon and it will be the best $30 you spent. 

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.


Edited by BrianBischof - 28 Mar 2008 at 9:45am

Yes, Borders has it in stock at most of their stores and keeps it in their warehouse. The PROBLEM is that they have all the biblio info wrong (title, author, etc.) and I've been calling to get them to correct it in their computer's database. But it hasn't happened yet. I'm pretty upset about this. So in my Borders, I can pull it up on their computer, the title is wrong and it says "not published yet', but when I go to the CR section of the store (by databases), then there it is right next to my CR.NET 2003 book. That really sucks. So I suggest that you call the store and ask them to do a physical check for the book (look for the bright green binding - it's pretty obvious) and not rely upon what their computer says. 

Hi,

Hi,

Ok , so you calculate this field on a subreport right ?

Can you be more specific, about the way you link the subreport to the chart.