E9 Portal.... possiblilities for reading multiple records

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