Skip to content

Aus800

IT technologies, especially open source tools

Menu

  • Services
  • About

Reporting

Jasper report two subreports in one section

I was putting two subreports together however noticed the title of the 2nd subreport didn’t “float”, checked its property, “float” was ticked, see screen shot below.                 After 20 minutes of search, it

wangts October 26, 2015 Programming, Reporting No Comments Read more

Microstrategy metric

I have to admit I’m not a fan of Microstrategy, the main reason is its rich features are buried in various places at the corner of tiny configuration items. For example I created a metric using CaseV CaseV(mtrFYear, 2013, 16.33,

wangts May 29, 2015 Programming, Reporting 1 Comment Read more

Jasper report server

I was developing a telecommunication bill using Jasper Studio (V6.0.4) on Windows and Jasper Server (V6.0.1) which was remotely hosted on an Ubuntu server. Jasper Studio was used to design layout while Jasper Server was in charge of generating final

wangts May 12, 2015 Programming, Reporting No Comments Read more

Microstrategy metrics relationship

Today I had a Microstrategy reporting problem: on my report there are two metrics, one is total number of  incidents and attribute month; the other is total amount of payments received.They come from two different tables and have no relationship

wangts May 12, 2014 Reporting 2 Comments Read more

Microstrategy derived metrics

I’ve been using Microstrategy for more than a year by now, never used derived metric before until recently discovered the beauty of derived metric. Derived metric, a Microstrategy’s term, I’d rather call it report function. Basically it’s a function that

wangts May 7, 2014 Reporting 2 Comments Read more

Microstrategy movingsum

Have been using Microstrategy 9 for a while, had a moving sum problem recently. The customer basically needs moving sum for the past 12 months for each state/branch. Of course the month is based on accounting period, i.e. 1 May

wangts May 6, 2014 Reporting 7 Comments Read more

Recent Posts

  • Postgresql identity column “no owned sequence”
  • PostgreSQL logical replication
  • Use Cloud function to start and stop Cloud sql
  • Bigquery parallel loading
  • Dates in SAP

Recent Comments

  • wangts on Use Cloud function to start and stop Cloud sql
  • Travis Spencer on Use Cloud function to start and stop Cloud sql
  • Lexie Gill on Use Cloud function to start and stop Cloud sql
  • wangts on Domain and email hosting
  • Leroy Brock on Domain and email hosting

Archives

  • July 2020
  • May 2020
  • March 2020
  • February 2020
  • December 2019
  • November 2019
  • June 2019
  • February 2019
  • December 2018
  • June 2018
  • May 2018
  • December 2017
  • November 2017
  • October 2017
  • June 2017
  • May 2017
  • March 2017
  • July 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • October 2015
  • September 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • September 2014
  • August 2014
  • May 2014
  • July 2013
  • April 2013
  • March 2013

Categories

  • Database
  • others
  • Programming
  • Reporting
  • Reviews
  • SAP
  • Telco billing
  • Uncategorized
  • virtualisation
Copyright © 2021 Aus800. Powered by WordPress. Theme: Spacious by ThemeGrill.