We are using Epicor 9.05 with the latest patch. But I can create a crystal report to do that as well, but again requires me to update it... I want to post it on our sharepoint site where a user will have access to live data. We are using Epicor Portal to attempt this, however not sure if this is powerful enough to do that.
--- In vantage@yahoogroups.com, Randall Weber <weber.randy@...> wrote:
>
> I misunderstood. I thought you wanted a report. You might be able to
> accomplish this with a custom form but it will be tricky to get the dates
> set-up the way you want. What version of Vantage do you have?
>
> Randy
>
> On Mon, Jun 21, 2010 at 7:25 AM, guyguy50 <guyguy50@...> wrote:
>
> >
> >
> > Thanks Randy,
> >
> > Next question then,
> > If I use excel is there a way that I don't have to manually update it? I'm
> > trying to keep it live data.
> >
> > Also as I'm unfamiliar with most ms programming(Sorry grew up in a Linux
> > environment in a programming sense...C++, PHP, etc..) so a lot of this is
> > unfortunately Greek to me but I can usually follow & at times find myself
> > really learning the in & outs of it as I need it.
> >
> >
> > --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, Randall Weber
> > <weber.randy@> wrote:
> > >
> > > Yes - dump the data to Excel and create a pivot table. IT will require
> > some
> > > VBA code to change the dates to Today, Day 1, etc.
> > >
> > > I can help you offline if you want with some sample code.
> > >
> > >
> > > --
> > > Randy Weber
> > > weber.randy@
> >
> > > (651) 263-1811
> > >
> > > http://randallweber.com/
> > >
> > >
> > >
> > > On Wed, Jun 16, 2010 at 10:29 AM, guyguy50 <guyguy50@> wrote:
> > >
> > > >
> > > >
> > > > I've something I'm not sure if it's possible so asking...
> > > > Can we loop through the records somehow?
> > > >
> > > > How can I accomplish this I have something like this being pulled in by
> > job
> > > > order then it is summarized by date... Giving me something like this
> > > >
> > > > Part # Date Req Qty Req
> > > > ------ -------- -------
> > > > xxx01 June 16 23
> > > > xxx01 June 18 100
> > > > xxx01 June 19 100
> > > > xxx02 June 17 22
> > > > xxx03 June 18 33
> > > > xxx03 June 19 103
> > > > xxx03 June 20 200
> > > >
> > > > But I want to be able to display it this way:
> > > > Part # Today 1 - Day 2 - Day 3 - Day 4 - Day
> > > > ------ ----- ------ ------ ------ -------
> > > > xxx01 23 0 100 100 100
> > > > xxx02 0 22 0 0 0
> > > > xxx03 0 0 33 103 200
> > > >
> > > > Or at any rate is there anyway to be able to pull all the data in to do
> > > > something like this?
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
>
> --
> Randy Weber
> weber.randy@...
> (651) 263-1811
>
> http://randallweber.com/
>
>
> [Non-text portions of this message have been removed]
>