Trying to create a report-formatting issues

[sarahkay1]

Hi everyone,
I will try to explain this the best way I can. I have knowledge in Access but obviously still learning the program. I have a project I need to do for work. They want a document transferred to Access. I have all the data into access now.The problem is they want the data in access to be laid out the same way the original document is. I need the format/layout to be like this:

Header Header Header Header
Data Data Data Data

Header Header Header Header
Data Data Data Data

The first two rows, header and data I can get it to work just fine and want it the way I want it. The first row of data I don't want repeated. I have that figured out how to not repeat....this is my issue.
The secon set of Header & Data information Ihave tried to get in the report and its not working the way I want it too. I put it in using a subreport, the data shows up but its not in the order I need it to be in. I have been racking my brain and reading thru an access book the company has to see how to do it. Below I will give a mini example version of what I am trying to do so it might make more sense.

Type of Fruit Store Price
Orange Walmart $1.25

Color Vendor Quanity
Green Sam's Fruit Stand 2 crates
Orange Tim's Market 5 crates
Purple Sue's Corner Store 10 crates

Type of Fruit Store Price
Watermelon K-Mart $4.23

Color Vendor Quanity
Red George's Store 5 crates
White Kip's Grocery 20 crates

Ok this is totally made up information but you get the drift of what I am trying to do. I can get the "type of fruit, store, price" headers on the report, the data pulls and doesn't repeat. But I can't figure out how to pull "color, vendor, quanity" and its data and have it in order. When I tried to use a subreport it pulls the data but it doesn't put it under the correct columns. Like for instance the first header about oranges, it will pull the data from watermelons when I need it to pull the data for hte oranges.

Hope this makes sense, if you need please ask me or I can even send you a copy of the report so you understand what I am trying to do. Thanks in advance.
If you want to email me my email address is Sarah.Williams@c-a-m.com


Sarah

 

[HiTechCoach]

Are you setting the master/child linking properties for the sub report?

I would suggest that you attach a sample for the report and your database with some sample data (nothing confidential) to a post here. This way you will gt the most help since more people can see it.

TIP: What makes forums like this one so great is that everything is done in posts, not by email. This way this grows into a great search able knowledge base. By taking the time to help you, we can also help many others if all communication is done in posts/replies.

 

[gemma-the-husky]

i'm not sure how the

header header
data data

lines fit in this concept


but in this block

Type of Fruit Store Price
Orange Walmart $1.25

Color Vendor Quanity
Green Sam's Fruit Stand 2 crates
Orange Tim's Market 5 crates
Purple Sue's Corner Store 10 crates

Type of Fruit Store Price
Watermelon K-Mart $4.23

Color Vendor Quanity
Red George's Store 5 crates
White Kip's Grocery 20 crates

what you really have is a single report with all these fields
Type of Fruit Store Price Color Vendor Quanity

sorted by
Type of Fruit / Store / price

ie the values for typeoffruit/store/price will (should) repeat in each row of the query for the appropriate grouping


this should give you the format layout/you want - then all you need is to add groupheaders etc, to give you the field description lines.

you shouldnt need any subreports to do this - just a query with all this data in it.

Note that a report ignores any sorting in the query - you have to specify the sorting and grouping for the report itself.