How to Pull data from ONE purchase order, NOT 9,000 of them in C

Yahoo Archive
1
It sounds to me like you made the parameter but did not put it in the select expert.

--- In vantage@yahoogroups.com, "jckinneman" <jckinneman@...> wrote:
>
> Can you go into a bit more details on what you built? Did you build a BAQ based report that uses Crystal? Or is this just a crystal report that goes directly to the database? Or?
>
> If a BAQ report you can put filters on the report so that it only pulls the related PO.
>
> Jim Kinneman
> Encompass Solutions, Inc.
>
> --- In vantage@yahoogroups.com, "clederer@" <clederer@> wrote:
> >
> > I created a Crystal Report that prints shipping labels. I have this set up on a tab in Purchase Order Entry. There are 5 custom text boxes that link to a Crystal Report. When you pull up the Crystal Report it prompts you to enter the "Purchase Order Number" then it lets you into the report. Right now it pulls from EVERY SINGLE purchase order in the system, so I end up with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm working on. Why does Crystal Reports still pull from the entire database even when I prompt it to pull from ONE purchase order? How do I ONLY get information from that purchase order I'm prompting Crystal prior to it opening the report?
> >
>
2
I created a Crystal Report that prints shipping labels. I have this set up on a tab in Purchase Order Entry. There are 5 custom text boxes that link to a Crystal Report. When you pull up the Crystal Report it prompts you to enter the "Purchase Order Number" then it lets you into the report. Right now it pulls from EVERY SINGLE purchase order in the system, so I end up with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm working on. Why does Crystal Reports still pull from the entire database even when I prompt it to pull from ONE purchase order? How do I ONLY get information from that purchase order I'm prompting Crystal prior to it opening the report?
3
Have you tried using a BAQ Report instead of a Straight to SQL Report?


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jul 29, 2013 at 12:51 PM, clederer@... <
clederer@...> wrote:

> **
>
>
> I created a Crystal Report that prints shipping labels. I have this set up
> on a tab in Purchase Order Entry. There are 5 custom text boxes that link
> to a Crystal Report. When you pull up the Crystal Report it prompts you to
> enter the "Purchase Order Number" then it lets you into the report. Right
> now it pulls from EVERY SINGLE purchase order in the system, so I end up
> with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm
> working on. Why does Crystal Reports still pull from the entire database
> even when I prompt it to pull from ONE purchase order? How do I ONLY get
> information from that purchase order I'm prompting Crystal prior to it
> opening the report?
>
>
>


[Non-text portions of this message have been removed]
4
Can you go into a bit more details on what you built? Did you build a BAQ based report that uses Crystal? Or is this just a crystal report that goes directly to the database? Or?

If a BAQ report you can put filters on the report so that it only pulls the related PO.

Jim Kinneman
Encompass Solutions, Inc.

--- In vantage@yahoogroups.com, "clederer@..." <clederer@...> wrote:
>
> I created a Crystal Report that prints shipping labels. I have this set up on a tab in Purchase Order Entry. There are 5 custom text boxes that link to a Crystal Report. When you pull up the Crystal Report it prompts you to enter the "Purchase Order Number" then it lets you into the report. Right now it pulls from EVERY SINGLE purchase order in the system, so I end up with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm working on. Why does Crystal Reports still pull from the entire database even when I prompt it to pull from ONE purchase order? How do I ONLY get information from that purchase order I'm prompting Crystal prior to it opening the report?
>
5
I have not tried using a BAQ Report. Do you have information on how to set that up? I've never set up a BAQ Report

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Have you tried using a BAQ Report instead of a Straight to SQL Report?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jul 29, 2013 at 12:51 PM, clederer@... <
> clederer@...> wrote:
>
> > **
> >
> >
> > I created a Crystal Report that prints shipping labels. I have this set up
> > on a tab in Purchase Order Entry. There are 5 custom text boxes that link
> > to a Crystal Report. When you pull up the Crystal Report it prompts you to
> > enter the "Purchase Order Number" then it lets you into the report. Right
> > now it pulls from EVERY SINGLE purchase order in the system, so I end up
> > with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm
> > working on. Why does Crystal Reports still pull from the entire database
> > even when I prompt it to pull from ONE purchase order? How do I ONLY get
> > information from that purchase order I'm prompting Crystal prior to it
> > opening the report?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
6
Summary:BAQ Instructions for creating a Crystal Report from a BAQ in BAQ Report Designer

Page: 7905MPS



You should be able to find something on MyEpicWeb...I have something with the above title passed on to me.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of clederer@...
Sent: Monday, July 29, 2013 12:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: How to Pull data from ONE purchase order, NOT 9,000 of them in Crystal Reports?



I have not tried using a BAQ Report. Do you have information on how to set that up? I've never set up a BAQ Report

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...<mailto:jose@...>> wrote:
>
> Have you tried using a BAQ Report instead of a Straight to SQL Report?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jul 29, 2013 at 12:51 PM, clederer@... <
> clederer@...> wrote:
>
> > **
> >
> >
> > I created a Crystal Report that prints shipping labels. I have this set up
> > on a tab in Purchase Order Entry. There are 5 custom text boxes that link
> > to a Crystal Report. When you pull up the Crystal Report it prompts you to
> > enter the "Purchase Order Number" then it lets you into the report. Right
> > now it pulls from EVERY SINGLE purchase order in the system, so I end up
> > with 9,000 pages of labels. Ideally, I want 1 label for the PO Number I'm
> > working on. Why does Crystal Reports still pull from the entire database
> > even when I prompt it to pull from ONE purchase order? How do I ONLY get
> > information from that purchase order I'm prompting Crystal prior to it
> > opening the report?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
7
Have you tried using the Shipping label that comes with the system and
customizing for your requirements?



You can start from scratch and modify the RDD to print anything custom
fields you need.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karen Schoenung
Sent: Monday, July 29, 2013 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: How to Pull data from ONE purchase order, NOT
9,000 of them in Crystal Reports?





Summary:BAQ Instructions for creating a Crystal Report from a BAQ in BAQ
Report Designer

Page: 7905MPS

You should be able to find something on MyEpicWeb...I have something with
the above title passed on to me.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of clederer@... <mailto:clederer%40att.net>
Sent: Monday, July 29, 2013 12:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: How to Pull data from ONE purchase order, NOT 9,000
of them in Crystal Reports?

I have not tried using a BAQ Report. Do you have information on how to set
that up? I've never set up a BAQ Report

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...
<mailto:jose@...%3cmailto:jose@...> <mailto:jose@...>> wrote:
>
> Have you tried using a BAQ Report instead of a Straight to SQL Report?
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Mon, Jul 29, 2013 at 12:51 PM, clederer@... <
> clederer@...> wrote:
>
> > **
> >
> >
> > I created a Crystal Report that prints shipping labels. I have this set
up
> > on a tab in Purchase Order Entry. There are 5 custom text boxes that
link
> > to a Crystal Report. When you pull up the Crystal Report it prompts you
to
> > enter the "Purchase Order Number" then it lets you into the report.
Right
> > now it pulls from EVERY SINGLE purchase order in the system, so I end up
> > with 9,000 pages of labels. Ideally, I want 1 label for the PO Number
I'm
> > working on. Why does Crystal Reports still pull from the entire database
> > even when I prompt it to pull from ONE purchase order? How do I ONLY get
> > information from that purchase order I'm prompting Crystal prior to it
> > opening the report?
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

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





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