Results 1 to 2 of 2

Thread: Parameter Values

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2005
    Posts
    95

    Parameter Values

    I have a report that is based on an underlying query.At the query level,I have defined parameters of date data type so that records to be displayed should fall between DateA and Date B.ie Between[Enter Date A:] And [Enter Date B:].How can I display these two parameter values on the report header???

  2. #2
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: Parameter Values

    hi kenone!!!

    In one of my applications, I used a form using two textboxes to send data to query as basis for my report using data report designer...

    One textbox for the beginning date(Date A) and one textbox for the ending date (Date B).

    here is the code:
    VB Code:
    1. 'to display the beginning date
    2. rptSalesReport.Sections("ReportHeader").Controls(2).Caption = frmSalesReport.txtStart.Text
    3.  
    4. 'to display the ending date
    5. rptSalesReport.Sections("ReportHeader").Controls(3).Caption = frmSalesReport.txtEnd.Text

    Controls(2) and Controls(3) are the controls on the report header section with the correct indexes..frmSalesReport is the form with the two textbox...Or you may substitute it with the control name...Hope this will help you....

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