?
Solved

Access Report:  Sub-report layout

Posted on 2009-04-14
9
Medium Priority
?
265 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

777 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