Re: Matrixed Display using WORep - looking for better idea.
Re: Matrixed Display using WORep - looking for better idea.
- Subject: Re: Matrixed Display using WORep - looking for better idea.
- From: Tanmoy Roy <email@hidden>
- Date: Wed, 5 Oct 2005 09:55:49 +0530
Hi Drew,
May I know which DB are you using. Your requirement can be best done
using a simple select statement which will give you an NSArray which
you can well bind to the WORep. Else you can have select all the
records in an NSArray iterate through it calculate the sum and create
and NSMutableArray of NSMutableDictionary where every
NSMutableDictionary will have some key value pairs where color of a
row will also be there. And most importantly DONT use WORep. Use
WOTable. It is highly enriched versions of WORep.
Let me know if you need anything more here.
Best
Tanmoy
On 10/5/05, Drew Thoeni <email@hidden> wrote:
> Hi all,
>
> I'm trying to display a pari of numbers (budget vs. actual) in a four
> x four matrix (four geographies x four products). So for each cell
> that is a cross of a product and a geography, there would be a budget
> number and an actual number in that table cell. Additionally, I'd
> like to have column and row totals, along with a grand total.
>
> I'd like to be able to use WOConditionals to compare budget to actual
> and flag with a color, image, etc. if actual is too far below budget.
>
> I can handle all this now, but I feel I'm doing it in a clumsy way.
> I'm creating four NSArrays (one for each column of geographies) and
> using a WORep to display the sales numbers.
>
> Totals are then calculated separately for each column and row and for
> the grand totals.
>
> Any ideas would be appreciated.
>
> Regards,
>
> Drew
>
>
> The file layout is simple:
>
> productCode
> geographyCode
> budgetedSales
> actualSales
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
--
Best,
Tanmoy
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden