I have created a formula that works out a clients total portfolio value by taking each investment and multiplying the number of units that the client holds by the amount each unit is work and then sums all of these togethor. Each investment is on a seperate record in a sql table. When I drop this field into the report because this client has 50 investments it generated the 6 page report 50 times. How can I put the field into the report and only get it to only generate the report once. "Supress if duplicated" doesnt seem to work, it still generates the report 50 times (even if it did work I have a feeling that it would still generate the report 50 times but the field would only be visible in the first 6 pages). It is worth noting that the field is in the Details section and if at all possible that is where it needs to stay. I have tested puttin ghe field in the page header but it still results in the same thing. I have also messed around with join types and alike but nothing seems to work.
:o(
Any thoughts?
I hope that made some kind of sense.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I have attatched a screenshot of the links setup. The software vendor has confirmed that the relationships are setup correctly.
It is worth noting that they are all setup using inner join.
database links
Business Accounts
Answer for Membership
by: peter57rPosted on 2009-08-07 at 00:47:39ID: 25040580
This sounds like a problem with your table links - it sounds like you have included a table that is not linked to others in the report.