I'm in the same boat now. The current WIP report stinks and we are trying to re-create.
Has anyone had any luck with this?
Thanks in advance!
John
Has anyone had any luck with this?
Thanks in advance!
John
--- In vantage@yahoogroups.com, "pcivantage" <pcivantage@...> wrote:
>
> I would love to take a look at what you have created!
> Please e-mail it to: pcicrystal@...
>
> Thanks!
>
> George Hicks
>
>
> --- In vantage@yahoogroups.com, "whitenight922" <whitenight922@> wrote:
> >
> > We were able to create the report but there is too much data and it keeps crashing. Our big problem is that we want all jobs that have a WIP value, but if a job is closed, it doesn't mean it has no WIP. I filtered out jobs closed before the first of the previous month, but it still ended up too much data. I was able to create a report that can give us the current (for all open jobs and jobs closed after the first of the previous month,) but it isn't date sensitive at all. If you want a copy of that, let me know what e-mail address you would like it sent to. By the way, I tried using ODBC, and it still had too much data and it would crash my Crystal application. I've been struggling with this for a while too.
> >
> > --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> > >
> > > It's a progress-based report and that table is a temp table. The only
> > > way to recreate this report is via ODBC with multiple data-sets or
> > > within SQL. I cannot imagine trying to accurately recreate this with
> > > BAQs.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of brucewbrannan
> > > Sent: Tuesday, September 14, 2010 11:44 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Does anyone have a Crystal WIP Report for Vantage
> > > 8.03.40x to share?
> > >
> > >
> > >
> > >
> > >
> > > Same request here. We attempted to duplicate the report via the help
> > > file but it got too complex for my feeble brain.
> > >
> > > The help file says the WipRpt table is the temporary table where the
> > > data are stored but when you look at it, it's empty. If only there was a
> > > way to take a snapshot of it while it contains the data. All we really
> > > need is that data and pull it into Excel.
> > >
> > > Does anybody have a similar solution or insight?
> > >
> > > Thanks!
> > >
> > > Bruce
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > > "pcivantage" <pcivantage@> wrote:
> > > >
> > > > I am looking for a WIP Report in Crystal with associated BAQ's etc.
> > > that someone would like to share. We need to customize it a bit and
> > > don't want to start from scratch.
> > > > I searched the file repository, but only found one older setup that
> > > seems incomplete and was posted that it had links that did not work.
> > > >
> > > > Regards,
> > > > George Hicks
> > > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>