Solved

Access Reports - Create Column Comparison

Posted on 2011-03-24
6
524 Views
Last Modified: 2012-06-27
'm preparing a Profit and Loss in Access, and I have 2 questions.

#1 - Is there was any way to switch the detail section from being vertical to being horizontal?

For example:

Right now in Access reports it is always vertical

--------------------------------------------------Detail Section --------------------------------------------
                 Revenue            Expenses         Net Income
January    $5,000                $3,000               $2,000
February   $6,000               $8,000               $2,000
March
etc.


I want it to be horizontal:
--------------------------------------------------Detail Section --------------------------------------------
                January             February                 March            etc...
Revenue
Expenses
Net Income


Is this even possible?

#2 - Is there a way to create a field in the report that compares the values in that record to the value of the same field in the previous record?  To compare the revenue growth from one month to the next.

I'm trying to to make it look as much like a P&L from QuickBooks as possible.
0
Comment
Question by:rczuba
  • 3
  • 2
6 Comments
 
LVL 57
ID: 35213269
<<#1 - Is there was any way to switch the detail section from being vertical to being horizontal?>>

  Not in the sense you think; rows always go down the page and columns across.  Reason being is that horizontal space is limited, where vertical is not.

  However you can get what your looking for by basing the report on a cross-tab query.

JimD.
0
 

Author Comment

by:rczuba
ID: 35216674
Well, I don't think that will work, because if the query is able to expand horizontally, but the report isn't, then it really is of little use to the user.  
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35216774
QuickBooks uses Crystal Reports for its reporting.  Crystal has a cross tab report that can expand horizontally to add more columns as necessary.

Do you happen to have Crystal?

mlmcc
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:rczuba
ID: 35217690
I do not have Crystal Reports.  What would I need to download in order to get it?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35217824
It is a commercial product.  You would have to buy it.  

You can get it from
www.SAP.com

mlmcc
0
 

Author Closing Comment

by:rczuba
ID: 35244918
x
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question