[cutiemae08]

I placed an unbound object frame on my report to link a graph i made in excel onto my access report.


i placed the unbound object on the detail section, right below the tabular fields that are on my report.


i was hoping to display a graph below my table in order to for the client to have a visual representation of the data in the table.



but instead, when i click on the report view. My graph is repeated after each row of my table.how do i avoid that and display a full table with a graph underneath it?



pls. help.

thank you

[slurpee55]

Can you post a zipped copy of your db with dummy data? No need to also upload the Excel file - just need to see the layout of your report.

[OBP]

You need to put the Graph in the Form's Page or Group Footer.

[jimr381]

Originally Posted by OBP

You need to put the Graph in the Form's Page or Group Footer.

Actually I usually put them in the Report Footer so it is at the end of the report and not at the end of each group or page.

[cutiemae08]

i dont have winzip on this computer though, so for the meantime i tried placing it on the page footer. and it looks good for now since its only a single page report.thanks guys! although my whole access project for my office is still not complete. looking forward to posting up more questions. pls bear with me!

[jimr381]

Originally Posted by cutiemae08

i dont have winzip on this computer though, so for the meantime i tried placing it on the page footer. and it looks good for now since its only a single page report.thanks guys! although my whole access project for my office is still not complete. looking forward to posting up more questions. pls bear with me!

Be aware that when that report becomes 2 pages that that graph will be on both pages.

[slurpee55]

cutiemae, if you have XP, you have the ability to zip files built in - you don't need winzip

[cutiemae08]

X) woops.. that was embarrassing! Ok…here’s a zipped sample of my db. The first trial table shows my initial problem. And the first trial table(footer) is what happened when I placed it on the page footer. The only problem is that when I have a smaller graph it goes way down to the footer section which is too far from my table, and it doesn’t look presentable.


...also in the attachment instead of linking an unbound object I just copied and pasted the graph as a link to save time.



thanks again for all your help...