[RESOLVED] Simple CRXI question

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)

I use CR9, but there Under Reports >> Selection Method >> Record is where you would set this, I would assume it is the same in XI

You would also want to set up your subreport links as well

That did the trick. Working pretty good now - thanks!

Now I'd like this parameter to be used FROM my ms-access application... maybe can you help me out on that thread:
http://www.vbforums.com/showthread.p...69#post2501169

Thanks