Vb.net 2008 and Crystal Reports

I'm creating a report in vb.nt 2008 using crystal reports that comes with Visual Studio.  I'm going to simplify what I need.  I have a column with random numbers that's 100 rows.  So I load my dataset with:
select Numbers from tablea.....so in crystal reports I only want to display the sum of the numbers and the user has the ability to click to drill down.   Or would I be better off making two tables, one that has the values summed?  Thanks
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Are you summing all the numbers?
If so you should be able to simply right click the field in the report
Set it up for a sum

If you need to use only some of the values then you can use a running total

bergertimeAuthor Commented:
I'm sorry for the delay on my response.  I am not summing all the numbers.  Say I have a table.

seq#          clnt            amount
1                 100           30.00
2                  200          45.00
3                 100           55.00
4                  200          25.00
5                  300          15.00

I want my report to look like:

Client 100          total=90.00
client200            total= 70.00
client300            total=15.00
But I only want to load one table,  also the user needs to have the ability to click on the total to drill down and see what made up his total.  Again this is a simplified version of what I'm trying to do.  

Add a group to the report on Client Number
Insert summaries into the group footer

Hide the detail section with the fields you want displayed on drill down.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

bergertimeAuthor Commented:

Ok, I think I'm almost there.  I have one more point to make more clear.  The first two steps worked great, but the third is what I'm having a problem with.  Do I add the fields to the details area?  I just get a blank page on drill down.  If I add my fields to the group footer, I only get the last result.  What I am looking for is on drill down a page that displays the fields I want that make up that grouping.  Thanks again.  
bergertimeAuthor Commented:
Got it.  I'm not sure what I was doing wrong on that last step, but it's working now.  Thanks for you help.  Not sure if I would have ever figured that out.
Yes you add the fields to the detail section.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.