CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009
    Posts
    109

    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.

  2. #2
    Join Date
    Dec 2009
    Posts
    109

    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.

  3. #3
    Join Date
    Aug 2007
    Posts
    180

    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
  •  





Click Here to Expand Forum to Full Width

Featured