Solved

Access Report:  Sub-report layout

Posted on 2009-04-14
9
260 Views
Last Modified: 2012-05-06
Dear Experts:

I would like to learn how to customize Access sub report layout.

First of all,
I would like to see a layout as the follows:

Income                $1,240,000
Expense               $ 800,000

Instead of

Income                Expense
$1,240,000         $800,000

In addition, I would like to place both labels and textbox in the details section.  By default,  labels are placed in the header and textbox in the details.

Finally, I would like to learn how to incorporate sub reports into the main report.

Thanks a lot!
0
Comment
Question by:duta
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 6

Accepted Solution

by:
BALMUKUND KESHAV earned 500 total points
ID: 24144769
Put two lables in detail sectioin of the report , income and expense like this :
Incode : place income field from table
Expense : place expense field from table
Reg.Sub report, select subform/subreport from toolbox in access report form and follow the wizard.

regards,

bm keshav


0
 

Author Comment

by:duta
ID: 24144851
Thank you so much for your kind, prompt tip.

By the way, should I start from "Report" or "Blank Report" or "Report Design"?

Can I place a query, instead of a field from a table, on the report?

Thanks!
0
 

Author Comment

by:duta
ID: 24144856
I created tons of queries to create a report.  I need to place queries, instead of table, on the report.

Thanks!
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 6

Expert Comment

by:BALMUKUND KESHAV
ID: 24144907
Its on you, if you are expert you can start with blank report, if novice, use wizard, but both tables and queries can be used in report/sub reports in access, if blank reports , select report properties, then data source, click on .... and crate your query here.

regards,

bm Keshav
0
 

Author Comment

by:duta
ID: 24144926
Thanks again!

By the way, do you any idea how to change the by-default layout (text value being placed under the label)?
________________ This is the layout I want ____________________
ncome                $1,240,000
Expense               $ 800,000

Instead of
_______________  This is the by-default layout _________________
Income                Expense
$1,240,000         $800,000t
0
 

Author Comment

by:duta
ID: 24144952
When I clicked "Sub Report Button" ( as seen in the screen shot below), nothing happened.
I didn't see any initiation from Report Wizard.
Sub-Report-Button.png
0
 

Author Comment

by:duta
ID: 24144968
After  clicking the Sub Report button, I clicked on the Report, and then Report Wizard showed up.  Then I chose a query. When  I clicked Report View, all I can see from the imported query was the title of the query, not labels and text values.
0
 
LVL 6

Expert Comment

by:BALMUKUND KESHAV
ID: 24145160
create a seperate report and then select in subreport that report and link with primary key id .

thanks,
bm Keshav

0
 

Author Comment

by:duta
ID: 24148817
Should a main report and a sub-report share an attribute that may serve as a link?

I plan to put three sub-reports that do not share a link.

For instance, one report is an expense report, and the other is an income report. They do not share an attribute. But they need to be displayed on a report.

Thanks!
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

689 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