Reports with the filter tab

Yahoo Archive
1
I got it. Thank you!



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Nigel Kerley
Sent: Wednesday, February 04, 2009 12:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reports with the filter tab



Looking at this report and the related RDD, I see that the BuyerID
field is not included by default. Did you duplicate the RDD and add
it in?

After adding this field (and refreshing the Crystal layout), I added
a new Parameter {?Buyer} and set the select statement to
"{POHeader.BuyerID} = {?Buyer}".

That seems to have worked - though the user will have to enter the
BuyerID, not the name.

Nigel.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Brad
Ebright" <bebright@...> wrote:
>
> Well I talked to the person that wanted this and they said your
suggestion
> would be ok. I tried it and it only works if you select all the
buyers and
> sort by supplier? Do you know why this would be?
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> Nigel Kerley
> Sent: Tuesday, February 03, 2009 10:24 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Reports with the filter tab
>
>
>
>
> This may not be what you're looking for, but you could add a
> Parameter to the Crystal Report asking for the additional filter.
>
> If you make it a dynamic parameter, you could even display a list
of
> Buysers so the user can select the correct one, instead of them
> entering the buyer code.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "brad.ebright" <bebright@> wrote:
> >
> > I have had several requests for additional filter functions on
> these
> > types of reports. The one that i most recently got was to add a
> buyer
> > filter to the Open Purchase Orders report.
> >
> > I can recreate the report, but it sure would be easier and nicer
> for
> > the users to add a tab to the filters for this report.
> >
> > Can it be done?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I have had several requests for additional filter functions on these
types of reports. The one that i most recently got was to add a buyer
filter to the Open Purchase Orders report.

I can recreate the report, but it sure would be easier and nicer for
the users to add a tab to the filters for this report.

Can it be done?
3
This may not be what you're looking for, but you could add a
Parameter to the Crystal Report asking for the additional filter.

If you make it a dynamic parameter, you could even display a list of
Buysers so the user can select the correct one, instead of them
entering the buyer code.

HTH,

Nigel.

--- In vantage@yahoogroups.com, "brad.ebright" <bebright@...> wrote:
>
> I have had several requests for additional filter functions on
these
> types of reports. The one that i most recently got was to add a
buyer
> filter to the Open Purchase Orders report.
>
> I can recreate the report, but it sure would be easier and nicer
for
> the users to add a tab to the filters for this report.
>
> Can it be done?
>
4
That would work, except they don't always wanna filter using the buyer, just
sometimes.



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Nigel Kerley
Sent: Tuesday, February 03, 2009 10:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reports with the filter tab




This may not be what you're looking for, but you could add a
Parameter to the Crystal Report asking for the additional filter.

If you make it a dynamic parameter, you could even display a list of
Buysers so the user can select the correct one, instead of them
entering the buyer code.

HTH,

Nigel.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"brad.ebright" <bebright@...> wrote:
>
> I have had several requests for additional filter functions on
these
> types of reports. The one that i most recently got was to add a
buyer
> filter to the Open Purchase Orders report.
>
> I can recreate the report, but it sure would be easier and nicer
for
> the users to add a tab to the filters for this report.
>
> Can it be done?
>





[Non-text portions of this message have been removed]
5
Well I talked to the person that wanted this and they said your suggestion
would be ok. I tried it and it only works if you select all the buyers and
sort by supplier? Do you know why this would be?



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Nigel Kerley
Sent: Tuesday, February 03, 2009 10:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reports with the filter tab




This may not be what you're looking for, but you could add a
Parameter to the Crystal Report asking for the additional filter.

If you make it a dynamic parameter, you could even display a list of
Buysers so the user can select the correct one, instead of them
entering the buyer code.

HTH,

Nigel.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"brad.ebright" <bebright@...> wrote:
>
> I have had several requests for additional filter functions on
these
> types of reports. The one that i most recently got was to add a
buyer
> filter to the Open Purchase Orders report.
>
> I can recreate the report, but it sure would be easier and nicer
for
> the users to add a tab to the filters for this report.
>
> Can it be done?
>





[Non-text portions of this message have been removed]
6
Looking at this report and the related RDD, I see that the BuyerID
field is not included by default. Did you duplicate the RDD and add
it in?

After adding this field (and refreshing the Crystal layout), I added
a new Parameter {?Buyer} and set the select statement to
"{POHeader.BuyerID} = {?Buyer}".

That seems to have worked - though the user will have to enter the
BuyerID, not the name.

Nigel.


--- In vantage@yahoogroups.com, "Brad Ebright" <bebright@...> wrote:
>
> Well I talked to the person that wanted this and they said your
suggestion
> would be ok. I tried it and it only works if you select all the
buyers and
> sort by supplier? Do you know why this would be?
>
>
>
> Thank You,
>
>
>
> Brad Ebright
> MGS Inc.
> 178 Muddy Creek Church Rd.
> Denver, PA 17517
> (717)336-7528
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Nigel Kerley
> Sent: Tuesday, February 03, 2009 10:24 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Reports with the filter tab
>
>
>
>
> This may not be what you're looking for, but you could add a
> Parameter to the Crystal Report asking for the additional filter.
>
> If you make it a dynamic parameter, you could even display a list
of
> Buysers so the user can select the correct one, instead of them
> entering the buyer code.
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "brad.ebright" <bebright@> wrote:
> >
> > I have had several requests for additional filter functions on
> these
> > types of reports. The one that i most recently got was to add a
> buyer
> > filter to the Open Purchase Orders report.
> >
> > I can recreate the report, but it sure would be easier and nicer
> for
> > the users to add a tab to the filters for this report.
> >
> > Can it be done?
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>