Method:Classic General Q&A

Re: Quick question: Formatting A Date Column in Report designer

MikeB — Wed, 24 Feb 2016 19:13:24 GMT

There are essentially 3 elements to this pivot grid, and I want the following:

FullName (rows) - Bottom-Left for values AND the column heading
Txn date (grouped by month) - Bottom-Middle for the column headings
Subtotal (from the Invoice table) - Bottom-Middle for the data and the column headings.

(I am unable to paste a picture on here, I have no idea why it worked in the first place)

TAnyway, this does not appear to be possible as you describe it.

Method_Morty — Wed, 24 Feb 2016 18:30:23 GMT

You will need to adjust with left side Appearence options to achieve the formatting you would like: (ie. text alilgnment).

-- Mortaza

MikeB — Wed, 24 Feb 2016 16:47:27 GMT

Thank you I was entering that in the "Cell Format" field instead. That's why it didn't work.

How about centering the Column Header (label) and the column values? Any options for that?

Method_Morty — Wed, 24 Feb 2016 15:59:03 GMT

Hey Mike,

You'll need to update the Format String as such:

-- Mortaza

MikeB — Tue, 23 Feb 2016 19:21:12 GMT

I have a pivot grid like the one below (below is the Method sample).

The TxnDate field is grouped by months. How do I get the months to display in MMM format?