AnsweredAssumed Answered

Data Display question

Question asked by Lowell on Nov 8, 2011
Latest reply on Nov 8, 2011 by another_martink
Hi All,
I have a picky customer that wants data to "show" in a certain way on the screen. I have developed a NSQL "query" that pulls the data - modeled after the way I've been pulling it manually for 2 years. But, now they want a change to the format. Anyway....

The user wants to be able to select "multiple" charge codes and have the data display on the Portlet like this:

Notice how there is a "subtotal" for each "Charge Code" and the dates are in "columns" out. Do you have any idea of how to get the system to display values like this?

Charge Code ID
Charge Code Name
Project
Project ID
Task
Task ID
Resource Type
Resource ID
Resource (last, first)
Actuals




















Jan 11
Feb 11
Mar 11
Apr 11
May 11
Jun 11
Jul 11
Aug 11
Sep 11
Oct 11
Nov 11
Dec 11
296
P1100376-Impact Intelligence-CAP
00198 / Impact Intelligence Implementation
c20101111-0000000198
Meetings

Employee
r613581
Noell, Marcia
105.00
105.00
105.00
105.00
105.00
105.00
105.00
105.00
105.00
105.00
105.00
100.00
296
P1100376-Impact Intelligence-CAP
00198 / Impact Intelligence Implementation
c20101111-0000000198
Analytics

Employee
r620880
Singer, Wendy
20.00
20.00
20.00
20.00
20.00
20.00
20.00
100.00
100.00
100.00
79.41
100.00









125.00
125.00
125.00
125.00
125.00
125.00
125.00
205.00
205.00
205.00
184.41
200.00
297
P1100377-Impact Intelligence-Exp
00198 / Impact Intelligence Implementation
c20101111-0000000198
Meetings

Employee
r613581
Noell, Marcia
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
297
P1100377-Impact Intelligence-Exp
00198 / Impact Intelligence Implementation
c20101111-0000000198
Analytics

Employee
r620880
Singer, Wendy
0.00
0.00
17.39
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00









100.00
100.00
117.39
200.00
200.00
200.00
200.00
200.00
200.00
200.00
200.00
200.00
Actuals








350.00
350.00
367.39
450.00
450.00
450.00
450.00
610.00
610.00
610.00
568.82
600.00

Outcomes