BAQ report with stored procedure

Yahoo Archive
1
Add the XML from BAQ to your crystal report and link it to your procedure
using the Parameters from the BAQ. That should do the filtering you need.
And should get rd of the crystal prompts, don't make them prompts, simply
use a link between the XML and the Procedre.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Sat, Mar 24, 2012 at 8:52 PM, Jennifer <Jennifer.Lisser@...>wrote:

> **
>
>
> Hi Jose!
> The crystal report with stored procedure works fine. The problem is the
> shop floor are going to scan off job travelers for the prompts. The crystal
> parameter screen is too clucky (3 required fields, 5 optional fields that
> would have to be set to null).
>
> I created a BAQ report to get the pretty prompt page they are used to and
> added my stored procedure to that report.
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> > I am not sure I understand what you are trying to do?
> > You have a crystal report that uses a stored procedure and then you need
> a BAQ for what?
> >
> >
>
>
>


[Non-text portions of this message have been removed]
2
Anyone ever create a BAQ report that was tied into a stored procedure?

I need to have a BAQ front end in Epicor 9 rather than using the crystal parameter screen. When I add the stored procedure in the report I set the stored procedure parameters to the BAQ report parameter values but I'm still getting the crystal reports prompt when I preview the report, after filling in all the data in the BAQ report form.

Anyone know how to set the report up so the crystal parameter screen is bypassed? I'm using Crystal 2008 SP4 and Epicor 9.05.607

Thanks!
Jenn
3
I am not sure I understand what you are trying to do?


You have a crystal report that uses a stored procedure and then you need a
BAQ for what?


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Sat, Mar 24, 2012 at 8:41 PM, Jennifer <Jennifer.Lisser@...>wrote:

> **
>
>
> Anyone ever create a BAQ report that was tied into a stored procedure?
>
> I need to have a BAQ front end in Epicor 9 rather than using the crystal
> parameter screen. When I add the stored procedure in the report I set the
> stored procedure parameters to the BAQ report parameter values but I'm
> still getting the crystal reports prompt when I preview the report, after
> filling in all the data in the BAQ report form.
>
> Anyone know how to set the report up so the crystal parameter screen is
> bypassed? I'm using Crystal 2008 SP4 and Epicor 9.05.607
>
> Thanks!
> Jenn
>
>
>


[Non-text portions of this message have been removed]
4
Hi Jose!
The crystal report with stored procedure works fine. The problem is the shop floor are going to scan off job travelers for the prompts. The crystal parameter screen is too clucky (3 required fields, 5 optional fields that would have to be set to null).

I created a BAQ report to get the pretty prompt page they are used to and added my stored procedure to that report.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> I am not sure I understand what you are trying to do?
> You have a crystal report that uses a stored procedure and then you need a BAQ for what?
>
>