Just a thought:
A while ago someone
posted a workaround to cell-freezing (like MSExcel). You could use that
approach to face such problem without having to combine WS results. Just place
one grid in one side of the other, and set their container’s margins to 0, in order for them to
appear that both grids are part of one whole. That way you reduce overhead, and
stick to a modular approach.
Best regards.
J.
Tracy,
Thanks for your help. Now I have to add other
fields from other
dataproviders but I think I can handle it.
I know this is probably AS 101, but how do I
create an object in the
new array that is a product of a math function
between 2 other
objects in the new array?
Example: I need to create a column in the datagrid
called GROWTH
that is simply the difference between TOTALBAL for
today and
TOTALBAL for yesterday (TODAY - YESTERDAY).
Everything I try results
in NaN.
Thanks for your patience.
-Dave
--- In [email protected],
"Tracy Spratt" <[EMAIL PROTECTED]>
wrote:
> The example is attached, along with the
sample xml files I created
to
> test it.
>
> Your array exists at
result.diffgram.PulseLoansToday. In the
example I
> left the diffgram node out of my test xml.
>
> Basically, you assign the today and yesterday
arrays to variables,
> iterate through the today items, get the
matching yesterday item,
build
> a combined item object, and add it to the
combined dataProvider
array,
> which is bound to the DataGrid DataProvider.
>
> Tracy
>
> -----Original Message-----
> From: [email protected]
[mailto:[email protected]]
On
> Behalf Of Dave
> Sent: Thursday, April 28, 2005 6:24 PM
> To: [email protected]
> Subject: [flexcoders] Re: Multiple
dataProviders for 1 dataGrid??
>
> OK. Let me backup. Below is a sample of the
data returned (an
array
> of objects?) from the WS with the date
specified as 1/10/2005. The
> dataProvider for the datagrid
>
is "{service1.PulseLoansToday.result.diffgram.PulseLoansToday.PulseLo
> ansToday}"
>
> Binding to the dataProvider as specified
produces the desired
> results within the datagrid (using
"CATEGORY", "TOTALBAL", etc. as
> the column names).
>
> Here's the rub; within the SAME datagrid, I
need to display one
> column of TOTALBAL for the selected
date(1/10/2005 in this case),
> and another column of TOTALBAL for
yesterday's date (thisDate
> request is empty so default is previous day's
date). Since I can
> only bind a datagrid to one dataProvider, I
need a way to combine
> the results into a new dataProvider that I
can bind to the
datagrid.
>
> Thanks for your help,
>
> -Dave
>
> SAMPLE DATA RETURNED FROM WEB SERVICE
> <?xml version="1.0" encoding="UTF-8"?>
> <soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
> <soap:Body>
>
<PulseLoansTodayResponse xmlns="http://srv-corp-
> sql/XmlWebServices/">
>
<PulseLoansTodayResult>
>
<xs:schema xmlns:msdata="urn:schemas-microsoft-com:xml-
> msdata" xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns=""
> id="PulseLoansToday">
>
<xs:element name="PulseLoansToday"
> msdata:IsDataSet="true">
>
<xs:complexType>
>
<xs:choice maxOccurs="unbounded">
>
<xs:element name="PulseLoansToday">
>
<xs:complexType>
>
<xs:sequence>
>
<xs:element name="SCHEDDATE"
> type="xs:string"
minOccurs="0"/>
>
<xs:element name="CATEGORY"
> type="xs:string"
minOccurs="0"/>
>
<xs:element name="TOTALBAL"
> type="xs:decimal"
minOccurs="0"/>
>
<xs:element name="TOTALCNT"
> type="xs:decimal"
minOccurs="0"/>
>
<xs:element name="SORTBY"
> type="xs:int"
minOccurs="0"/>
>
</xs:sequence>
>
</xs:complexType>
>
</xs:element>
>
</xs:choice>
>
</xs:complexType>
>
</xs:element>
>
</xs:schema>
>
<diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-
> com:xml-diffgram-v1"
xmlns:msdata="urn:schemas-microsoft-com:xml-
> msdata">
>
<PulseLoansToday xmlns="">
>
<PulseLoansToday diffgr:id="PulseLoansToday1"
> msdata:rowOrder="0">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>1-NEW VEHICLE</CATEGORY>
>
<TOTALBAL>61427820.1900</TOTALBAL>
>
<TOTALCNT>3177</TOTALCNT>
>
<SORTBY>1</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday2"
> msdata:rowOrder="1">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>2-USED VEHICLE</CATEGORY>
>
<TOTALBAL>51179669.7000</TOTALBAL>
>
<TOTALCNT>4322</TOTALCNT>
>
<SORTBY>2</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday3"
> msdata:rowOrder="2">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>3-UNSECURED</CATEGORY>
>
<TOTALBAL>997362.0700</TOTALBAL>
>
<TOTALCNT>761</TOTALCNT>
>
<SORTBY>3</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday4"
> msdata:rowOrder="3">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>4-EQUITY MORTGAGES</CATEGORY>
>
<TOTALBAL>11356456.8100</TOTALBAL>
>
<TOTALCNT>545</TOTALCNT>
>
<SORTBY>4</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday5"
> msdata:rowOrder="4">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>5-HELOC FIXED</CATEGORY>
>
<TOTALBAL>2665131.6800</TOTALBAL>
>
<TOTALCNT>94</TOTALCNT>
>
<SORTBY>5</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday6"
> msdata:rowOrder="5">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>6-HELOC VARIABLE</CATEGORY>
>
<TOTALBAL>1452584.3100</TOTALBAL>
>
<TOTALCNT>152</TOTALCNT>
>
<SORTBY>6</SORTBY>
>
</PulseLoansToday>
>
<PulseLoansToday diffgr:id="PulseLoansToday7"
> msdata:rowOrder="6">
>
<SCHEDDATE>01/10/2005</SCHEDDATE>
>
<CATEGORY>7-FIXED</CATEGORY>
>
<TOTALBAL>6617278.6300</TOTALBAL>
>
<TOTALCNT>255</TOTALCNT>
>
<SORTBY>7</SORTBY>
>
</PulseLoansToday>
>
</PulseLoansToday>
>
</diffgr:diffgram>
>
</PulseLoansTodayResult>
>
</PulseLoansTodayResponse>
> </soap:Body>
> </soap:Envelope>
>
>
> --- In [email protected],
"Tracy Spratt" <[EMAIL PROTECTED]>
> wrote:
> > Well, this is definitely on topic, so
lets keep it here.
Besides,
> > someone else might be able to help.
> >
> > An Object is NOT the same as an array of
Objects, at least from
a
> list
> > dataProvider standpoint. But there has
to be an array in there
> > somewhere! Sometimes the array is
at result[0], and not at
result.
> >
> > What are you using to debug? Flex
Builder? Can you examine the
> result
> > object?
> > Did you try the for loop? If you
have an object, that might not
> work.
> > But it might with result[0].
> > Also try:
> > for (var key in result){
> > trace(key
+ ":" + result[key]);
> > }
> >
> > We can also try specifying the result to
be in xml.
> >
> > We need to know exactly what our data
looks like.
> >
> > Do the current results display in the
datagrid? If so, how are
you
> > specifying the dataProvider and the
column sources?
> >
> > Tracy
> >
> > -----Original Message-----
> > From: [email protected]
> [mailto:[email protected]]
On
> > Behalf Of Dave
> > Sent: Thursday, April 28, 2005 3:14 PM
> > To: [email protected]
> > Subject: [flexcoders] Re: Multiple
dataProviders for 1 dataGrid??
> >
> > Thanks for helping on this - my butt is
on the line! YES - the
WS
> is
> > sending back result type of Object.
> >
> > You can respond to [EMAIL PROTECTED] if you
prefer.
> >
> >
> > Thanks,
> >
> > -Dave
> >
> > --- In [email protected],
"Tracy Spratt" <[EMAIL PROTECTED]>
> > wrote:
> > > What is your result type?
Object(default), xml
> > (resultFormat="xml"). If
> > > you think it is an array of objects
(the best case), then in
> your
> > result
> > > handler, run a test like this:
> > >
> > > for (
i:Number=0;i<result.length;i++){
> > >
trace(result[i].someObjectpropertyName)
> > > }
> > > Do you see what you expect?
If so, I'll write a quick example
> > that will
> > > use two such arrays of objects to
build a third suitable for a
> > > dataProvider.
> > > Tracy
> > >
> > > -----Original Message-----
> > > From: [email protected]
> > [mailto:[email protected]]
On
> > > Behalf Of Dave
> > > Sent: Thursday, April 28, 2005
10:03 AM
> > > To: [email protected]
> > > Subject: [flexcoders] Re: Multiple
dataProviders for 1
dataGrid??
> > >
> > > Sorry but I'm not very familiar
with AS - can you give me an
> > example
> > > and/or pointers?
> > >
> > > Thanks,
> > >
> > > -Dave
> > >
> > >
> > > --- In [email protected],
"Tracy Spratt"
<[EMAIL PROTECTED]>
> > > wrote:
> > > > I think you will need to
programmatically combine the two
> > results
> > > into a
> > > > new dataProvider.
> > > >
> > > > This is not difficult in AS,
but the details depend on the
> > result
> > > type.
> > > >
> > > > Tracy
> > > >
> > > > -----Original Message-----
> > > > From: [email protected]
> > > [mailto:[email protected]]
On
> > > > Behalf Of Dave
> > > > Sent: Tuesday, April 26, 2005
4:13 PM
> > > > To: [email protected]
> > > > Subject: [flexcoders] Multiple
dataProviders for 1 dataGrid??
> > > >
> > > >
> > > >
> > > > Accessing a web service, in
one dataGrid I have a column
that
> > > displays
> > > > the account balance (TOTALBAL)
per product.as of current
date.
> > > Another
> > > > column in the same dataGrid
displays the account balance
> > > (TOTALBAL)
> > > > but for the date 12/31/2004. I
can't figure out a solution
> since
> > > > column names can't be
identical.
> > > >
> > > > I duplicate the web service so
that I have service1 and
> > service2 -
> > > > where I pass the 12/31/2004
date to service2. So TOTALBAL
for
> > > service1
> > > > corresponds with current day
and TOTALBAL for service2
> > corresponds
> > > > with 12/31/2004.
> > > >
> > > > Any ideas on how to render
this data within the same
dataGrid?
> > > Please
> > > > help ASAP.
> > > >
> > > > Thanks,
> > > >
> > > > -Dave
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
>
>
>
>
>
>
> Yahoo! Groups Links
Yahoo! Groups Links
