Hi All,

I have design report using cross table in CR and i want to display qty, number of visit and division of qty and number of visit. I have success display qty and number of visit in cross table, but i fail to display correct value for division of qty and number of visit. So how can i display the value for division of qty and number of visit?

For ilustration, please see this image or visit this link:



Thank You for your enlightenment,

Kurniawan

This is pretty tricky and I dedicated quite a few pages in the new book detailing how it all works. I'll try to give you the quick version here. First off, you can override any value in a cross-tab cell using the Display String property on the Format Editor. Click the Formula button to enter a new formula to be displayed in the cell. This is where you would put the division calculation.

Now, the next question is, how do you create the division calculation. For this, you have to create a Shared variable for both the numerator and divisor. Use the conditional formatting of any property for each cell and assign the CurrentValue function to the shared variable. That way, both the numerator and denominator variables will have values in them so that your division calculation will be accurate.

Again, this is pretty tricky stuff and its tough to explain in a simple forum post. If you decide to pick up a copy of the book, read pages 510-518 for in-depth coverage and examples.