Reports With Charts (1 Viewer)

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.
 

Users who are viewing this thread

Top Bottom