Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access Report:  Sub-report layout

Posted on 2009-04-14
9
Medium Priority
?
267 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 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

610 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