Displaying multiple records in a report.

[CammRobb]

Hey all,



I'm having a hellish time trying to get my report to display properly.

Here's what it should look like



Here's what mine looks like



What the problem is - the report is only putting one item on each invoice, and I have NO idea how to resolve this. The class for this was a while ago, and I had a lot of stuff go on between then and now, so it's kinda slipped my mind.

If you need the database emailed to you or whatever, then I can do that.

Please help!

[khalid]

How you store the Invoice data to your tables? do you have invoice table (main table) and a table (sub table) with one to many relationship, where related records will be saved to that table with the foreign key:

Invoice table
Invoice ID: (Primary Key)
1
2
3
======
Second Table
Invoice ID (Foreign Key)
1
1
1
2
2
2
3
==========
If you normalize your data in such a way that your Invoice ID (PK) is the (FK) in another table (the related record table) the it will be easy for you to get the desire report.
Just you need to create a table and call the desired field in the report detail portion.
Report detail portion will show all the detailed record you want to show in detail. you can use report header for the field you want to show as a header data.
In the report footer you can use formula (sum, avg, etc) to calculate your data accordingly.

hth.

[alansidman]

Look at this video. It may give you a clue on how to fix. Difficult to analyze without seeing the db. You may want to post a sanitized copy. Make sure to do a compact and repair before attaching here.

http://www.datapigtechnologies.com/f...ccessrpts.html

Alan

[CammRobb]

Look at this video. It may give you a clue on how to fix. Difficult to analyze without seeing the db. You may want to post a sanitized copy. Make sure to do a compact and repair before attaching here.

http://www.datapigtechnologies.com/f...ccessrpts.html

Alan

Where should I upload it to? Do you have a dropbox, I could put it in there.

[khalid]

Go to Advance below the post below the editing panel, go to manage attachments and upload your sample db.

[CammRobb]

Go to Advance below the post below the editing panel, go to manage attachments and upload your sample db.

Right, I had to delete the report to get it under 500kb, uploaded (hopefully!)

Thanks for the help guys

[khalid]

Hi, you did not attached the report, however I am attaching the sample report based on your requirement with a query. you need to format the report with your logo and desire.

Data has been removed from the report in order to upload it back in addition with the generated report and query. please add some data to the tables to analyze the report.

[CammRobb]

Hi, you did not attached the report, however I am attaching the sample report based on your requirement with a query. you need to format the report with your logo and desire.

Data has been removed from the report in order to upload it back in addition with the generated report and query. please add some data to the tables to analyze the report.

A million thank yous my friend! You've saved me so much time!

[khalid]

A million thank yous my friend! You've saved me so much time!

Glad to hear that you got some help

[taiba]

thank you very much, i got a gud idea after viewing your report

[khalid]

thank you very much, i got a gud idea after viewing your report

You are welcome taiba. I am glad that you got some idea viewing my post.

Replied via samsung galaxy sii