RDD Table Criteria

Thanks, I have resolved the issue.

--- In vantage@yahoogroups.com, Roel Martinez <rmartinez@...> wrote:
>
> Good afternoon.
>
> Mike, check your string to compare as I got different results typing SCC versus 'SCC' in the constant RValue.
>
> Regards.
>
> Roel Martinez
> ERP Analyst
>
> SABRE TUBULAR STRUCTURES (tm)
> www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
> 8653 E. Hwy 67 | Alvarado, TX 76009
> Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
>
> [cid:image001.jpg@...]
>
> Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
> The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the recipient.
>
>
>
> [Non-text portions of this message have been removed]
>
We are on 8.03.409a, trying to add criteria to the Part table in RDD that will only pull a ProdCode of 'ACC' or 'FAST' or 'SEAL'. After criteria is set and I rerun the report I am still receiving all records. The report I am working on is a duplicate of Sales Order Pick List so the Part table is one that I've added.
I'm not aware of any way to add criteria like that in a RDD. Usually you
can only add the table and add a relationship.
Then, in the crystal, you can limit the data.

How are you adding criteria to limit the rows of a table?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike
Sent: Monday, July 26, 2010 1:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RDD Table Criteria





We are on 8.03.409a, trying to add criteria to the Part table in RDD
that will only pull a ProdCode of 'ACC' or 'FAST' or 'SEAL'. After
criteria is set and I rerun the report I am still receiving all records.
The report I am working on is a duplicate of Sales Order Pick List so
the Part table is one that I've added.





[Non-text portions of this message have been removed]
Selecting the Criteria subtab under the Report Table tab.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdaniel@...> wrote:
>
> I'm not aware of any way to add criteria like that in a RDD. Usually you
> can only add the table and add a relationship.
> Then, in the crystal, you can limit the data.
>
> How are you adding criteria to limit the rows of a table?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Mike
> Sent: Monday, July 26, 2010 1:58 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] RDD Table Criteria
>
>
>
>
>
> We are on 8.03.409a, trying to add criteria to the Part table in RDD
> that will only pull a ProdCode of 'ACC' or 'FAST' or 'SEAL'. After
> criteria is set and I rerun the report I am still receiving all records.
> The report I am working on is a duplicate of Sales Order Pick List so
> the Part table is one that I've added.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Good afternoon.

Mike, check your string to compare as I got different results typing SCC versus 'SCC' in the constant RValue.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

[cid:image001.jpg@01CB2CE4.17CC4620]

Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the recipient.



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