Access Report: Sub-report layout

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!
dutaAsked:
Who is Participating?
 
BALMUKUND KESHAVCommented:
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
 
dutaAuthor Commented:
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
 
dutaAuthor Commented:
I created tons of queries to create a report.  I need to place queries, instead of table, on the report.

Thanks!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
BALMUKUND KESHAVCommented:
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
 
dutaAuthor Commented:
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
 
dutaAuthor Commented:
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
 
dutaAuthor Commented:
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
 
BALMUKUND KESHAVCommented:
create a seperate report and then select in subreport that report and link with primary key id .

thanks,
bm Keshav

0
 
dutaAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.