How to take 3 parameters at the same time.
I'm developing an application using C#. One of it's features is that it can generate monthly invoices to be sent to the customers.
So what I need is to take in 3 parameters - CustomerId, FromDate and ToDate
The program will later generate a report showing the invoices of that particular customer, from a certain date, to a certain date.
I know how to get CustomerId in as a parameter.
{tblInvoice.invCustId} = {?CustomerId}
But further from that I need to take in From and To dates, which will further help in filtering the records. And I have no clue how to do that.
I tried searching the internet but failed to find a solution, mostly because I wasn't sure what to search for on Google.
Any help would be appreciated.
Thanks in advance.
Re: How to take 3 parameters at the same time.
Sorry, I forgot to mention (though it's implied), the monthly invoices being generated are Crystal Reports.
Re: How to take 3 parameters at the same time.
I may be over simple but you need to create 2 date parameters, and just like you did with customer id you add to your criteria
{tblInvoice.invCustId} = {?CustomerId}
AND
{tblInvoice.AN_INVOICE_DATE} >= {?STARTING_DATE_PARAMTER}
AND
{tblInvoice.AN_INVOICE_DATE} <= {?ENDING_DATE_PARAMTER}