S
straver
Guest
Greetings,
I'm having a very difficult time getting a PARAMETER value from an SQL query to show up in the "header section" of a report that contains a bar-chart (I'm getting a #Name error). When I use the same SQL query below for a basic vanilla report, it works fine.
Here is my SQL code:
PARAMETERS [Last Name] Text;
SELECT Date, Invoice, Sum(Amount * Rate * .01) AS Commission
FROM MyDatabase
WHERE Last = [Last Name] AND Status="C"
GROUP BY Date, Invoice, Status
ORDER BY Date;
All I'm doing in both cases is including the following text in a text-box:
=[Last Name]
Any help will be greatly appreciated.
I'm having a very difficult time getting a PARAMETER value from an SQL query to show up in the "header section" of a report that contains a bar-chart (I'm getting a #Name error). When I use the same SQL query below for a basic vanilla report, it works fine.
Here is my SQL code:
PARAMETERS [Last Name] Text;
SELECT Date, Invoice, Sum(Amount * Rate * .01) AS Commission
FROM MyDatabase
WHERE Last = [Last Name] AND Status="C"
GROUP BY Date, Invoice, Status
ORDER BY Date;
All I'm doing in both cases is including the following text in a text-box:
=[Last Name]
Any help will be greatly appreciated.