Talk with the Author: Creating Overall % and Graphs

Creating Overall % and Graphs

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11112
Printed Date: 19 Apr 2025 at 1:18am

Topic: Creating Overall % and Graphs

Posted By: fyoung10
Subject: Creating Overall % and Graphs
Date Posted: 14 Sep 2010 at 6:07pm

Hi I am new to Crystal Reports and need help.

I am trying to create a report that has multiple totals on it. Each total has a different criteria that i am counting. For Example We have plans within a system, and I want to know how many plans are in the system and print that total. Then on another line I want to know, how many of those plans are critical and print that total, on another line, how many of the critical plans have tested..etc. So each one (total) will have a different criteria. i was able to create the formulas to achieve all of the totals that I needed. The problem is when i try to put them all on the main report all the numbers change. Which lead me to believe that i can't put them all on the main report i have to create separate sub reports with the different totals i need.

My question is on the main report i have to have a summary of all of the numbers for instance I will need to know out of all of the critical plans in the system, what is the percentage that have tested? Well if i do the separate sub reports those numbers will be in two separate reports. Is there a way that I can have the system look at both of those numbers and create my percentage on the main report?

Also, I will need to be able to depict the overall totals on main report graphically.

Hopefully this can be done, and someone can help me. Also, if i was not clear or you didn't understand what i was writing please let me know.

Thanks for any help i can get

-------------
Thanks

Replies:

Posted By: DBlank
Date Posted: 16 Sep 2010 at 11:24am

you will have to explain your data a little more, maybe some sample rows

and also give some samples of what kind of formulas you ended up with.

I am guessing you can do what you want without using an sub-reports but can't really tell until I see some data and how youa re counting it.

FYI- this is the wrong spot for this type of question so it was hard to find your post. Brian may move it into the correct location but future posts you may want to put in the ' default.asp?C=3 - Crystal Reports 9, X, XI, 2008 ' section and choose a sub forum there.