Printing Salesman & Quoter in the same line - Report Builder

system · June 15, 2006, 12:12pm

Ah haaaa. I think I see the issue. Last time I looked a tquoting was in 5.2 and it used an array. In 6.1 I see the new QSalesRP table. I think I see where you are going with this.

Two get two seperate QSalesRP records on the same band line you may need to create an alias table for the QsalesRP table. In you linking link to that table again (using the desired alternate key value) and give it an "alias" table name (like QSalesRP2). Then in the report refer to the original and the alias for their respective values.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Eunice Corral
Sent: Thursday, June 15, 2006 10:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Printing Salesman & Quoter in the same line - Report Builder

Thank you Todd, but what I need to print is the SalesRepCode
itself,

Example: SalesRepCode = "boc" Quoter PrimeRep = No

SalesRepCode = '06" SalesPerson PrimeRep = Yes

This two ID's are in the Quote under "People" but both share the same
field for RB, SalesRepCode,

and I would like to print in one column "boc" and another column "06".
Could that be possible?

Thanks,

Eunice Corral

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Todd Caughey
Sent: Thursday, June 15, 2006 10:21 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Printing Salesman & Quoter in the same line -
Report Builder

Response based on 6.1.

SalesRepCode is an array type field which can hold up to 5 reps. The
values are seperated by the ~ (tilde) character. When dealing with it I
have always had to parse out the individual values (in RB using the
ENTRY function). If you only ever have one per quote you can pick out
the first X characters and ignore the rest. The tilde character is ASCII
126.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Eunice Corral
Sent: Thursday, June 15, 2006 10:14 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com <mailto:vantage%40yahoogroups.com>
Cc: Ken Kveton
Subject: RE:[Vantage] Printing Salesman & Quoter in the same line -
Report Builder

I am designing a report and I would like to have the Quote
number in one column, the Quoter in the second

column, and the Salesman in the third column. As everyone
knows the Quoter and Salesman are both

"SalesRepCode", all I need is to print the SalesRepCode.

I am trying the following: IIF(QSalesRep.PrimeRep = yes,
QSalesRep.SalesRepCode, "")

But it will not print the SalesRepCode at all. I appreciate
if anyone responds to this message with any

suggestions you may have.

Thanks,

Eunice Corral

Dudek & Bock Spring Mfg. Co.

773-379-4100

[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]

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

system · June 15, 2006, 11:15am

I am designing a report and I would like to have the Quote
number in one column, the Quoter in the second

column, and the Salesman in the third column. As everyone
knows the Quoter and Salesman are both

"SalesRepCode", all I need is to print the SalesRepCode.

I am trying the following: IIF(QSalesRep.PrimeRep = yes,
QSalesRep.SalesRepCode, "")

But it will not print the SalesRepCode at all. I appreciate
if anyone responds to this message with any

suggestions you may have.

Thanks,

Eunice Corral

Dudek & Bock Spring Mfg. Co.

773-379-4100

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

system · June 15, 2006, 11:22am

Response based on 6.1.

SalesRepCode is an array type field which can hold up to 5 reps. The values are seperated by the ~ (tilde) character. When dealing with it I have always had to parse out the individual values (in RB using the ENTRY function). If you only ever have one per quote you can pick out the first X characters and ignore the rest. The tilde character is ASCII 126.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Eunice Corral
Sent: Thursday, June 15, 2006 10:14 AM
To: vantage@yahoogroups.com
Cc: Ken Kveton
Subject: RE:[Vantage] Printing Salesman & Quoter in the same line - Report Builder

I am designing a report and I would like to have the Quote
number in one column, the Quoter in the second

column, and the Salesman in the third column. As everyone
knows the Quoter and Salesman are both

"SalesRepCode", all I need is to print the SalesRepCode.

I am trying the following: IIF(QSalesRep.PrimeRep = yes,
QSalesRep.SalesRepCode, "")

But it will not print the SalesRepCode at all. I appreciate
if anyone responds to this message with any

suggestions you may have.

Thanks,

Eunice Corral

Dudek & Bock Spring Mfg. Co.

773-379-4100

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

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

system · June 15, 2006, 11:55am

Thank you Todd, but what I need to print is the SalesRepCode
itself,

Example: SalesRepCode = "boc" Quoter PrimeRep = No

SalesRepCode = '06" SalesPerson PrimeRep = Yes

This two ID's are in the Quote under "People" but both share the same
field for RB, SalesRepCode,

and I would like to print in one column "boc" and another column "06".
Could that be possible?

Thanks,

Eunice Corral

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Thursday, June 15, 2006 10:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Printing Salesman & Quoter in the same line -
Report Builder

Response based on 6.1.

SalesRepCode is an array type field which can hold up to 5 reps. The
values are seperated by the ~ (tilde) character. When dealing with it I
have always had to parse out the individual values (in RB using the
ENTRY function). If you only ever have one per quote you can pick out
the first X characters and ignore the rest. The tilde character is ASCII
126.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Eunice Corral
Sent: Thursday, June 15, 2006 10:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc: Ken Kveton
Subject: RE:[Vantage] Printing Salesman & Quoter in the same line -
Report Builder

I am designing a report and I would like to have the Quote
number in one column, the Quoter in the second

column, and the Salesman in the third column. As everyone
knows the Quoter and Salesman are both

"SalesRepCode", all I need is to print the SalesRepCode.

I am trying the following: IIF(QSalesRep.PrimeRep = yes,
QSalesRep.SalesRepCode, "")

But it will not print the SalesRepCode at all. I appreciate
if anyone responds to this message with any

suggestions you may have.

Thanks,

Eunice Corral

Dudek & Bock Spring Mfg. Co.

773-379-4100

[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]