CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Posts
    5

    Smile date range with From:field.........To: field

    Date range: I need to have my heading to look like this:

    From: 04/01/2007 To: 06/30/2007

    what would the whole thing need to be done including the space in the middle.
    I have selected the date range but I don't know how to display my heading like that!

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    Re: date range with From:field.........To: field

    How do you set the dates range?
    By Parameter?
    By Formula with fixed dates?
    Please explain

  3. #3
    Join Date
    Jul 2007
    Posts
    5

    Re: date range with From:field.........To: field

    I just selected my dates from the Select Expert and nothing else.
    I didn't set up any parameters nor formulas.
    I have my report ready with all the data. I need the heading to show the beginning date and the ending date. If I change the dates on the select expert, then the "heading" to change as I select the new date range.

  4. #4
    Join Date
    Apr 2007
    Location
    NY
    Posts
    89

    Re: date range with From:field.........To: field

    Create 2 parameters with the Date type:
    (in the field explorer, right click on the parameter field ->NEW)

    1st one - DateFrom
    2nd one - DateTo

    Then in your record selection formula print:

    {your_table.date_field}>={?DateFrom} and
    {your_table.date_field} <={?DateTo}

    To show the parameters in your report, insert them into your PH section (you can find them in your Field Explorer under the Parameter Fields section).
    Then insert a text object(s) into your Page Header to print the text
    'From: ' and 'To: '.
    I mean you can place these 2 parts of text in 2 separate text objects or you can print them in one and then insert parameters into it, which is more convenient if you need to move or format it.

  5. #5
    Join Date
    Dec 2008
    Posts
    5

    Re: date range with From:field.........To: field

    Hi, I have basically the same question.

    Is it possible to do this with only one parameter field?

    Do the parameter fields need to be date ranges, if I'm using the double parameter field method?

    Thanks!

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