Jaa

Autotext in CALC columns (CU8 feature)

  • Artikkeli

There may be situations where you have reports that require calculated periods or where you need to perform some calculations to get to your final report format. With CU8 of Management Reporter, you can now apply autotext codes such as @CalMonthLong and @FiscalPeriod to print the period name, period description, and other date related autotext codes in calculated column headers.

The following autotext codes are now available within a CALC column.

  • Month name (@CalMonthLong)
  • Abbreviated month name (@CalMonthShort)
  • Period number (@FiscalPeriod)
  • Period description (@FiscalPeriodName)
  • Fiscal year (@FiscalYear)
  • Calendar year (@CalYear)
  • Start date (@StartDate)
  • End date (@EndDate)

This was a highly requested feature on the Connect site with over 55 votes. Thank you for all of those who took the time to vote on this suggestion.

Watch the video below for more information on how to use this feature.

[embed]https://www.youtube.com/watch?v=EEQ690kRM3Q&feature=youtu.be[/embed]

Comments

  • Anonymous
    February 14, 2014
    Even in full screen, it's difficult to see the details in the video.  Please consider recording future videos with a higher resolution.

  • Anonymous
    July 09, 2014
    Dear Microsoft what happened to @txtdate autotext? I have a customer that misses the Month, day year layout for example As of April, 30 2014. Right now we are handling manually by entering on report generation which is a pain.