Customized Ultra Grid

Here's what I did to show labor detail in a grid. In this case I made a text box for the employee number so it could be filtered by that employee. The tricky part was filtering out the columns I didn't want. I put only one column at the bottom. That would have to be repeated for each column you want to hide. As you can see it isn't very intuitive. I worked on this for weeks (off and on,) and was very frustrated before my co-worker and I found all the pieces! I look at it now and think, is this all there is to it? I thought there were hundreds of more lines of code! (I must be thinking of the columns I hid.)

Dim strEmpNum as string = txtEmpNum.Text
Dim aLaborList As LaborAdapter = New LaborAdapter([UD22Form])
Dim strWhereClause as string
aLaborList.BOConnect()
Dim MorePages as Boolean
strWhereClause = "EmployeeNum = '" & strEmpNum & "'"
Dim opts As SearchOptions = New SearchOptions(SearchMode.AutoSearch)
opts.NamedSearch.WhereClauses.Add("LaborHed",strWhereClause)
Dim LaborRec As Data.DataSet = aLaborList.GetRows(opts,MorePages)
ugdAttend.DataSource = LaborRec
ugdAttend.DisplayLayout.Bands(0).Columns("ShiftDescription").Hidden = True


--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> I would be interested in see the sample code.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of whitenight922
> Sent: Thursday, May 13, 2010 3:23 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customized Ultra Grid
>
>
>
>
>
> If you have your heart set on an ultragrid, that can be done too. If you
> want sample code I can find what we did and post it. All the data would
> be coming from one table, right? I haven't dealt with DMR activity yet.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Brian W. Spolarich " <bspolarich@> wrote:
> >
> > What I would do is make a Dashboard using your query. You can then add
> a new sheet to the PO Tracker using the Sheet Wizard, and select the
> Dashboard to be the content of that sheet.
> >
> > -bws
> >
> > --
> > Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
> / Picometrix
> > bspolarich@ ~ 734-864-5618 ~ www.advancedphotonix.com
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
> jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
>
>
>
> -----Original Message-----
>
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of aimee.grebe
> > Sent: Thursday, May 13, 2010 3:06 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Customized Ultra Grid
> >
> > Is there a way to set the datasource of a new ultragrid (added through
> embedded customization) to a custom query? I want to add a new grid to
> the PO Tracker that shows DMR Activity but none of the datasources that
> are in the list to choose from will give me the information I need.
> >
> > Thanks,
> > Aimee
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Is there a way to set the datasource of a new ultragrid (added through embedded customization) to a custom query? I want to add a new grid to the PO Tracker that shows DMR Activity but none of the datasources that are in the list to choose from will give me the information I need.

Thanks,
Aimee
What I would do is make a Dashboard using your query. You can then add a new sheet to the PO Tracker using the Sheet Wizard, and select the Dashboard to be the content of that sheet.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of aimee.grebe
Sent: Thursday, May 13, 2010 3:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Customized Ultra Grid

Is there a way to set the datasource of a new ultragrid (added through embedded customization) to a custom query? I want to add a new grid to the PO Tracker that shows DMR Activity but none of the datasources that are in the list to choose from will give me the information I need.

Thanks,
Aimee



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
If you have your heart set on an ultragrid, that can be done too. If you want sample code I can find what we did and post it. All the data would be coming from one table, right? I haven't dealt with DMR activity yet.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> What I would do is make a Dashboard using your query. You can then add a new sheet to the PO Tracker using the Sheet Wizard, and select the Dashboard to be the content of that sheet.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of aimee.grebe
> Sent: Thursday, May 13, 2010 3:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Customized Ultra Grid
>
> Is there a way to set the datasource of a new ultragrid (added through embedded customization) to a custom query? I want to add a new grid to the PO Tracker that shows DMR Activity but none of the datasources that are in the list to choose from will give me the information I need.
>
> Thanks,
> Aimee
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
I would be interested in see the sample code.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of whitenight922
Sent: Thursday, May 13, 2010 3:23 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customized Ultra Grid





If you have your heart set on an ultragrid, that can be done too. If you
want sample code I can find what we did and post it. All the data would
be coming from one table, right? I haven't dealt with DMR activity yet.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian W. Spolarich " <bspolarich@...> wrote:
>
> What I would do is make a Dashboard using your query. You can then add
a new sheet to the PO Tracker using the Sheet Wizard, and select the
Dashboard to be the content of that sheet.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
/ Picometrix
> bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
>










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of aimee.grebe
> Sent: Thursday, May 13, 2010 3:06 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Customized Ultra Grid
>
> Is there a way to set the datasource of a new ultragrid (added through
embedded customization) to a custom query? I want to add a new grid to
the PO Tracker that shows DMR Activity but none of the datasources that
are in the list to choose from will give me the information I need.
>
> Thanks,
> Aimee
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>




[Non-text portions of this message have been removed]