472,808 Members | 1,937 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,808 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 23498
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.