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
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]
>