I created a dashboard but I got to a dead end as I have a field CustID on the dashboard tracker where users enter CustID. I had looked at your earlier reply and oddly enough I couldn't choose 'dashboard browse' for my CustID field. It is not available in the combo.
I then redesigned, got rid of the tracker, created a text field on the sheet for CustID. Users enter that I get the CustNum for this ID from Customer table.
Now in the script I need to make the dashboard use this CustNum to get the data. And I don't know how to call the dashboard from the script using this CustNum as the key.
I have spent so much time on this project already and am getting to a block either way, embedded dashboard OR embedded BAQ in the grid.
Hope someone can understand to present a solution!
Thanks,
Uzma.
I then redesigned, got rid of the tracker, created a text field on the sheet for CustID. Users enter that I get the CustNum for this ID from Customer table.
Now in the script I need to make the dashboard use this CustNum to get the data. And I don't know how to call the dashboard from the script using this CustNum as the key.
I have spent so much time on this project already and am getting to a block either way, embedded dashboard OR embedded BAQ in the grid.
Hope someone can understand to present a solution!
Thanks,
Uzma.
--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdaniel@...> wrote:
>
> Why can't you create a dashboard and then embed the dashboard in your sheet then you don't have to code anything. Set up the publish and subscribe between the dashboard and your form and you're all set.
>
> ________________________________
>
> From: vantage@yahoogroups.com on behalf of unackvi
> Sent: Wed 3/9/2011 12:24 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Can Grid on a Custom Sheet be bound to a BAQ?
>
>
>
>
> Hi Jose,
> I have a question as I am trying your solution out.
>
> 1) I have this code on a button click in the Script editor but I am getting an error
> 'Error: BC30002 - line 91 (504) - Type 'BAQDataView' is not defined'.
> Do I need to add something to the references for the code to compile and accept this as a type or something else?
>
> Thanks and I emailed you as well,
> Uzma
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose Gomez <jose@> wrote:
> >
> > See below let me know if you don't understand something
> >
> >
> > BAQDataView baqView = new BAQDataView("ZBI-CustomerContact");
> > oTrans.Add("BAQView", baqView);
> > // create the parent / child relationship using the CustNum as Pub & Sub
> > oTrans.PublishColumnChange("Customer.CustNum", "myCustID");
> > //myCustID is the Label I gave to Customer.CustNum on my BAQ.
> >
> > baqView.SubscribeToPublisher("myCustID", "CustCnt.CustNum");
> > // set the Binding on the Grid and set the Transaction to wire the events
> > epiUltraGridC1.EpiBinding = "BAQView"; epiUltraGridC1.EpiTransaction =
> > oTrans;
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com <http://www.josecgomez.com/>
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Wed, Feb 23, 2011 at 10:34 AM, unackvi <unackvi@> wrote:
> >
> > >
> > >
> > > Hi Jose,
> > > Can you please explain a little more how I bind it, where I call the BAQ
> > > from and run it from and how I attach the results? I will appreciate it.
> > >
> > > Sean, I do understand that my other option is to use a dashboard but
> > > dashboards are very limited in what they can do. Thanx.
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose Gomez <jose@> wrote:
> > > >
> > > > You can bind it to a BAQ using a customization, by calling the BAQ Object
> > > > and running it then attaching the result as the data set of the Grid.
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com <http://www.josecgomez.com/>
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > >
> > > >
> > > >
> > > >
> > > > On Tue, Feb 22, 2011 at 12:45 PM, Sean McDaniel <
> > > > smcdaniel@> wrote:
> > > >
> > > > >
> > > > >
> > > > > You can create a dashboard and then embed that dashboard in the new
> > > sheet.
> > > > >
> > > > > ________________________________
> > > > >
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> on behalf of unackvi
> > > > > Sent: Tue 2/22/2011 12:41 PM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] Can Grid on a Custom Sheet be bound to a BAQ?
> > > > >
> > > > >
> > > > > Hi all,
> > > > > I am adding a customized sheet to Customer Tracker and when I add a new
> > > > > Grid to one of the docking sheets, I only see the way to get data is to
> > > Bind
> > > > > it to a DataSource.
> > > > > Is it possible that I can get data for this grid from a BAQ i.e. bind
> > > the
> > > > > Grid to a BAQ?
> > > > > Please let me know.
> > > > > Thanks in advance for any help!
> > > > > Uzma
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>