?
Solved

Vb.net 2008 and Crystal Reports

Posted on 2008-11-05
6
Medium Priority
?
214 Views
Last Modified: 2013-11-15
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
0
Comment
Question by:bergertime
  • 3
  • 3
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 22888434
Are you summing all the numbers?
If so you should be able to simply right click the field in the report
Click INSERT --> SUMMARY
Set it up for a sum

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

mlmcc
0
 
LVL 2

Author Comment

by:bergertime
ID: 23038261
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.  

Thanks
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 23044103
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.

mlmcc
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 2

Author Comment

by:bergertime
ID: 23057405
mlmcc,

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.  
0
 
LVL 2

Author Closing Comment

by:bergertime
ID: 31513607
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.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 23062092
Yes you add the fields to the detail section.

mlmcc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question