|
-
March 8th, 2012, 03:54 PM
#1
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.
-
March 8th, 2012, 03:55 PM
#2
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.
-
March 16th, 2012, 03:58 PM
#3
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}
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|