0

Monthly Balances In Vertical Format

Jet Reports Historic Posts

February 06, 2016 11:28

None

Follow

I have managed to pull the monthly trial balance into Excel via Jet in the normal table format, ie. with headers as follows:

Account No, Account Name, Account Type, Month 1, Month 2, Month 3 …. etc

However for other reasons, I would like to get the data in the following format - any ideas please as I am new to Jet:

Account No - Accounts Name - Account Type - Month - Balance
01000 - Account 1 - Posting - Month 1 - £xxx
01000 - Account 1 - Posting - Month 2 - £xxx
01000 - Account 1 - Posting - Month 3 - £xxx

etc

Thanks

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts February 08, 2016 22:59

  I'm curious to see your report. Are you able to upload it for review? You can be in design mode so the data won't be shown but I'm curious how you got the months built out in Express.