467,911 Members | 1,354 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,911 developers. It's quick & easy.

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
  • viewed: 22984
Share:
3 Replies
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Stefanos | last post: by
2 posts views Thread by John J. Hughes II | last post: by
3 posts views Thread by Parasyke | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.