Solved

Access Report:  Sub-report layout

Posted on 2009-04-14
9
218 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
  • 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
 
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now