473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Report Help

Im trying to create a report for a purchase order very similar to the Northwind invoice report. I have everything figured out except how to repeat the entries in the detail section of the report. I have all the order information except all of the items. It will only list one of the items in the detail section, where in the Northwind report it repeats it as if it was a continuous form. Ive checked all the properties and they all seem to be the same. Does anyone know what i might be doing wrong here?
May 10 '06 #1
6 1299
Im trying to create a report for a purchase order very similar to the Northwind invoice report. I have everything figured out except how to repeat the entries in the detail section of the report. I have all the order information except all of the items. It will only list one of the items in the detail section, where in the Northwind report it repeats it as if it was a continuous form. Ive checked all the properties and they all seem to be the same. Does anyone know what i might be doing wrong here?
Have you checked the groups?
May 10 '06 #2
I have the grouping set up just like the northwind does

Grouped by
OrderID
ItemID

but it only displays one of the items from the orderdetails
May 10 '06 #3
I have the grouping set up just like the northwind does

Grouped by
OrderID
ItemID

but it only displays one of the items from the orderdetails
How is it displaying, if you have two groups one by order id and one my item id, with a page break between orders ids? it is giving you multiple pages? Are you only viewing one order number?

order ID 123456
Item 1 widget 1.99
Item 2 blue widge 2.49


Do you need to group Item ID or if you want it in order do it by sort AZ. That should keep all your items within your order id together.
May 10 '06 #4
I am viewing one order number with multiple items referenced by that order number. I have a pagebreak per order number. the item details are contained within the orderid break under the details break, its layed out just like northwinds is. grouping and everything is the same but it is only displaying one of many items that is associated with that order number. northwinds seems to repeat the detail section for each item record it is to display, mine is not repeating the detail section.
May 10 '06 #5
Anyone??? please help me out, this is the only thing not working in my project and then im done!
May 11 '06 #6
wlc04
70
I created a PO program for my company a couple of years ago and this is how I did it.

Try creating a sub form with the detail information.
May 11 '06 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: MGFoster | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've converted an ACC97 .mdb file to an ACC2K2 .adp. A report that worked in ACC97 doesn't work in ACC2K2. Report setup: ACC97 ...
3
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
3
by: Melissa | last post by:
What specifically causes the Format event of a report's section to fire? Thanks! Melissa
1
by: VBSponge | last post by:
Hi all. In A2K i have a report with a control bound to to calculate the page count for the report. I need to retrieve this page count from the report, and build it into a TOC containing this an...
12
by: Orchid | last post by:
Hello all, I have different version of reports which used for different months. For example, I am using report version 1 up to September, but we have some design changes on the report for October,...
3
by: DeanL | last post by:
Hi guys, I'm in need of a little help with a report I'm setting up on Access 2000. The report shows data depending on entries on a form that has 7 fields (Min and Max Cost, Fiscal Year, Min and...
6
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
3
by: jambonjamasb | last post by:
Hi I have two tables: email_tbl Data_table Data table is is used to create a Form Data_form
12
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...
10
by: sara | last post by:
Hi - I have a report that is 14 columnar sub-reports (Line up: Position- holders in each of our 14 locations - Manager, Assistant Manager, Receiving, Office, etc). I output directly to PDF...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.