Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have a wonderful report showing the quarterly sales per year.I wanted to convert this report to show the monthly sales per year.I am sending in the attachement the ooriginal report, called rptSummary and my new report called Rpt1.In doing so i got the following problems:
    In my report Rpt1 the year is not shown.
    I would like also to have the name of the month written beside the number of the month
    Can you help me ?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You shouldn't have changed the text box in the group header for the year.

    You should have changed the text box in the group footer for the month (which used to be the group footer for the quarter) instead.

    See the attached version.
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='772261' date='25-Apr-2009 13:18']You shouldn't have changed the text box in the group header for the year.

    You should have changed the text box in the group footer for the month (which used to be the group footer for the quarter) instead.

    See the attached version.[/quote]


    Thank you for your suggestion and wonderful report. Could you help me correct he following:
    at the end of the year on should read
    Totals for 2008 but it is written total for 12.3.2008 and
    Totals for 7.1.2009
    Can you help me change to show only the year ?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Change the control source of the text box to

    ="Totals for " & Year([InvoiceDate]) & ":"

  5. #5
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='772272' date='25-Apr-2009 17:24']Change the control source of the text box to

    ="Totals for " & Year([InvoiceDate]) & ":"[/quote]

    Thanks a lot for everything, i have a nice report now !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •