473,396 Members | 1,764 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Crystal Reports Grouping at the same hierarchy level - How?

I am using Visual Studio.NET 2002 Professional and am attempting to
create a report on Crystal Reports for .NET.

I know that Crystal Reports can group on anything, and when I add
multiple
groups, the groups are childs of the first group.

i.e.
Group 1
Group 2
Group 3
Details
Group 3
Group 2
Group 1

What I cannot figure out is how to have multiple groups at the same
level,
because this time, I do NOT want a parent-child type report. What I
want is something like this:

Details
Group 1
Group 1
Group 2
Group 2
Group 3
Group 3

Any ideas?
Jul 19 '05 #1
3 23580
You can try suppressing sections/group headers/footers
etc so that only the grouping you want appears. Details
are always dependent on groups though if you have them,
so showing details and then the groups would be a little
tricky... after all, showing the sum of sales for
instance after each detail would be a little confusing.
You can add sections at will...and suppress them, using
format section...adn then suppress. You can even
conditionally suppress which is often helpful.

Depending on your familiarity with crystal, suppressing
sections and groups may or may not sound like
gobblidygook...if so, let me know and I can explain a
little more in detail.

Good Luck,

Bill

W.G. Ryan
do********@comcast.nospam.net
www.knowdotnet.com
-----Original Message-----
I am using Visual Studio.NET 2002 Professional and am attempting tocreate a report on Crystal Reports for .NET.

I know that Crystal Reports can group on anything, and when I addmultiple
groups, the groups are childs of the first group.

i.e.
Group 1
Group 2
Group 3
Details
Group 3
Group 2
Group 1

What I cannot figure out is how to have multiple groups at the samelevel,
because this time, I do NOT want a parent-child type report. What Iwant is something like this:

Details
Group 1
Group 1
Group 2
Group 2
Group 3
Group 3

Any ideas?
.

Jul 19 '05 #2
Hi, thanks for replying. To be more specific in what I want to
accomplish,
I want to create a report that lists all projects, and one or more
related project elements but grouped together.

Therefore, I want a report to look like this:

Project 1 Number Project Name
Project Data
Project Data 1
Project Data 2
Project Data 3
Project People
Person 1
Person 2
Person 3
Project Task
Task 1
Task 2
Task 3
Project 2 Number Project Name
...

A report with sums would be something like:

Project 1 Number Project Name
Project Task Finished
Task 1 End Date Hours Spent
Task 2 End Date Hours Spent
Task 3 End Date Hours Spent
Total Hours Spent On Project Tasks
Project Task Incomplete
Task 1 Est. End Date Hours Spent
Task 2 Est. End Date Hours Spent
Task 3 Est. End Date Hours Spent
Total Hours Spent on Project Tasks
Project 2 Number Project Name
...

Another variation to both reports above would be to limit the Tasks to
a specific Task or Tasks, like "Data Analysis", and list each "Data
Analysis" task occurance in a specific Project, but still print out
the Projects
if they had "Data Analysis" or not.

I've managed to move "Details" attributes to the first group header,
which seems to work fine. Now, it is just a matter of separating
the other groups so they are not sub-sets of each other.
"William Ryan" <do********@comcast.nospam.net> wrote in message news:<08****************************@phx.gbl>...
You can try suppressing sections/group headers/footers
etc so that only the grouping you want appears. Details
are always dependent on groups though if you have them,
so showing details and then the groups would be a little
tricky... after all, showing the sum of sales for
instance after each detail would be a little confusing.
You can add sections at will...and suppress them, using
format section...adn then suppress. You can even
conditionally suppress which is often helpful.

Depending on your familiarity with crystal, suppressing
sections and groups may or may not sound like
gobblidygook...if so, let me know and I can explain a
little more in detail.

Good Luck,

Bill

W.G. Ryan
do********@comcast.nospam.net
www.knowdotnet.com
-----Original Message-----
I am using Visual Studio.NET 2002 Professional and am

attempting to
create a report on Crystal Reports for .NET.

I know that Crystal Reports can group on anything, and

when I add
multiple
groups, the groups are childs of the first group.

i.e.
Group 1
Group 2
Group 3
Details
Group 3
Group 2
Group 1

What I cannot figure out is how to have multiple groups

at the same
level,
because this time, I do NOT want a parent-child type

report. What I
want is something like this:

Details
Group 1
Group 1
Group 2
Group 2
Group 3
Group 3

Any ideas?
.

Jul 19 '05 #3
Dear member
I have the same problem with crystal report and though I can find the answer from your question, but could not!
What did you do finally to solve the problem?
I know it's a long time ago, but if you have any solution let me know please.
Thanks

I am using Visual Studio.NET 2002 Professional and am attempting to
create a report on Crystal Reports for .NET.

I know that Crystal Reports can group on anything, and when I add
multiple
groups, the groups are childs of the first group.

i.e.
Group 1
Group 2
Group 3
Details
Group 3
Group 2
Group 1

What I cannot figure out is how to have multiple groups at the same
level,
because this time, I do NOT want a parent-child type report. What I
want is something like this:

Details
Group 1
Group 1
Group 2
Group 2
Group 3
Group 3

Any ideas?
Jun 22 '06 #4

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

Similar topics

0
by: Sean G. | last post by:
Howdy, I have a series of crystal reports, some have subreports, that I need to put together in one file on one click form the user. So put I imported the separate rpt files as subreports into...
5
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
0
by: Stefanos | last post by:
Hi, I am using VS .NET 2003 and the included Crystal Reports .NET. I have built a windows form that displays a grouping report using the report viewer. I would like the end-user to be able to...
2
by: Alpha | last post by:
I have a C# program that user would select several search criteria and then outputs to the Crystal Report. A message is output to user if no matching record is found. In my code I also clear,...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
2
by: thefirstwml | last post by:
I am using Visual Studio.NET 2002 Professional and am attempting to create a report on Crystal Reports for .NET. I know that Crystal Reports can group on anything, and when I add multiple...
2
by: John J. Hughes II | last post by:
I have VS.2005 standard edition. I was reading the help and it says to insert a report use the report Crystal Reports grouping. I can't find either the item or the grouping. I have also tried...
3
by: Parasyke | last post by:
I see a lot of jobs advertized for people knowing Crystal Reports. I tried to use this platform 6 years ago and found it awkward and difficult. I find Access, using ODBC, to grab data and build...
0
by: akshaycjoshi | last post by:
Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR. It is very diff. for me to read an...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...

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.