[RESOLVED] Simple CRXI question

[Krass]

Hi people. First post in the Crystal Reports. This program looks nice. I think I'm gonna forget about Access XP Report module since it has been giving me some headaches.

So, to get acquainted with the program, I am doing some basic reports/tests with CR. I have a connection to an ACCESS DB and my basic report is working pretty good.

My question is: All my INVOICES are shown on the report. What if I want only the INVOICE_NO = 2500 to appear? To test my report (and the subreports I will be adding) ONLY on that particular invoice?

I believe there's some SQL place where I can input "WHERE INVOICE_NO = 2500" or something similar. This will of course be removed later since I will want the report to be openned from ACCESS with the invoice number will be sent as an argument.

Thanks (please be a little more specific than usual since I'm new with the app)