473,503 Members | 2,150 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need help making multiple groupings in a Crystal report

I'm try to create a report will group one date field several times
based on criteria. First group I'm making is a grouping by Client #,
second grouping I need to have it give me a count of the date field
only if the date is between the current date and 10 days ago. Then the
next field I need it to give me the count of the date field if it
contains a date more than 10 days ago and less than 20 days ago, and so
on till I get to 100 days. I just cant figure out how to get my report
to give me the count for that specific client #. Below is how I
picture it looking like...

Client 0-10 10-20 20-30 30-40

05INS 100 2 11 15
99REC 44 33 22 12
08RET 22 11 11 66

And so on, maybe even including the balance of the account associated
with the 0-10 accounts. Any help would be appreciated. thanks

Nov 2 '06 #1
0 822

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
24714
by: mitmed | last post by:
Hi, I hope someone here can help me. We have a product table which has a many-to-many relation to a category table (joined through a third "ProductCategory" table): ---< >--- --------- ...
0
1625
by: Himanshu Saxena | last post by:
hi, this is regarding the Problem in Including Crystal Reports Decision while making a setup project. when i make a new setup project to make the setup kit for my c# exe then due to its...
1
1309
by: tristant | last post by:
Hi All, We want to develope Windows and Web .NET application on Oracle 9i on AIX. Also we will use Crystal Report for reporting. I have question about the what Visual Studio.NET edition do we...
0
1620
by: Benny Ng | last post by:
Dear ALl, Now I want to export the crystal report to Excel file. But actually don't know how to export it with multiple sheet. Because sometime in some particular cases. It needs us to provided an...
1
7494
by: monskie | last post by:
Hello to all, I have a problem which could be trivial to you guys. This concerns opening several crystal reports on the a crystal viewer on an ASPX page by calling window.open. My...
3
8426
by: ian_jacobsen | last post by:
First let me start by saying that this problem is not consistently reproducible. I have a windows service that creates reports for a group of entities. This service can process multiple groups at...
0
2782
by: lrobo01 | last post by:
I'm having a problem with Crystal report.net with ASP.NET. The problem occurs when exporting the report. The report uses a discrete parameter with multiple values. When the report is loaded into...
1
2168
by: mike11d11 | last post by:
For some reason I'm getting no data populating in my crystal report. I built my crystal report off my dataset in my project, and I fill the dataset when opening the main form, and count the...
1
1727
by: pintoo | last post by:
Hi, I have 2 sites (Site A, B) running on same windows 2003 server pointing to different home directories. User logs into site A and is shown a.aspx page and user credentials are saved in...
0
7093
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
7008
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5594
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5022
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4688
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3177
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3168
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
399
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.