I don't think I've ever tried that, but I'm not surprised it doesn't work.
If it was me, I would create 2 variables (I'm winging this, so syntax might not
be exactly right):
VpartlocA = partnum2 in mastervendors where part# = part# and PriSupplerL =
'Y'VpartlocB = partnum2 in mastervendors where part# = part# and PriSupplerD =
'Y'
Vpartnum2 = (ifeq(vpltaccess2,'L', .vpartlocA, .vpartlocB))
Karen
-----Original Message-----
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l@googlegroups.com <rbase-l@googlegroups.com>
Sent: Mon, Jul 25, 2022 3:06 pm
Subject: [RBASE-L] - using column name in report variables
<!--#yiv3006541153 _filtered {} _filtered {}#yiv3006541153 #yiv3006541153
p.yiv3006541153MsoNormal, #yiv3006541153 li.yiv3006541153MsoNormal,
#yiv3006541153 div.yiv3006541153MsoNormal
{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv3006541153
span.yiv3006541153EmailStyle17 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv3006541153 .yiv3006541153MsoChpDefault
{font-family:"Calibri", sans-serif;} _filtered {}#yiv3006541153
div.yiv3006541153WordSection1 {}-->I have a few variables in a report.
Vpartloc = (ifeq(vpltaccess2,'L','PriSupplerL','PriSupplerD')) I want to
create a lookup based on that column name in vpartloc Vpartnum2 = partnum2
in mastervendors where part# = part# and &vpartloc = 'Y' I usually use the &
symbol to substitute for the column name but it gives me an error when I try to
save the variable. Any ideas why it does not work? TIA Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014F0903AC%40EXCHANGE10.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1042612017.1545249.1658779907686%40mail.yahoo.com.
