Grouping in a report

Georges Heinesch

Hi.

I would like to apply some grouping in a report, but I don't know
whether this here is possible. Best I describe it with an example:

Here some records:

Apples green 12 USD
Apples green 12 USD
Apples green 12 USD
Bananas green 12 USD
Bananas green 12 USD
Oranges green 12 USD
Oranges green 12 USD
Oranges green 12 USD

What I would like to have (grouped according the first column, first
record completely in one row):

Apples green 12 USD
green 12 USD
green 12 USD
Bananas green 12 USD
green 12 USD
Oranges green 12 USD
green 12 USD
green 12 USD

All I get is (first record splitted on 2 rows):

Apples
green 12 USD
green 12 USD
green 12 USD
Bananas
green 12 USD
green 12 USD
Oranges
green 12 USD
green 12 USD
green 12 USD

Is it possible that the fields of the first record in the detail section
gets displayed at the same line?

TIA

--
Georges

Nov 12 '05 #1

Subscribe Post Reply

1195

Bernard Peek

In message <40********@news.vo.lu>, Georges Heinesch <ne**@geohei.lu>
writes

Hi.

I would like to apply some grouping in a report, but I don't know
whether this here is possible. Best I describe it with an example:

Here some records:

Apples green 12 USD
Apples green 12 USD
Apples green 12 USD
Bananas green 12 USD
Bananas green 12 USD
Oranges green 12 USD
Oranges green 12 USD
Oranges green 12 USD

What I would like to have (grouped according the first column,
first record completely in one row):

Put all of the fields in the detail section. Sort by name, colour and
price. Set the "Hide Duplicates" property on the name field to true.

You will see:

Apples green 12 USD
green 12 USD
green 12 USD
Bananas green 12 USD
green 12 USD
Oranges green 12 USD
green 12 USD
green 12 USD

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #2

Georges Heinesch

Bernard Peek wrote:

In message <40********@news.vo.lu>, Georges Heinesch <ne**@geohei.lu>
What I would like to have (grouped according the first column,
first record completely in one row):

Put all of the fields in the detail section. Sort by name, colour and
price. Set the "Hide Duplicates" property on the name field to true.

Worked!
Thanks a lot!

--
Georges

Nov 12 '05 #3

by: amber | last post by:

Hello, I have a report in VB.NET/Crystal Reports. I have a criteria form that users select between 2 different types of grouping (group by category or group by year). Can I programmatically...

.NET Framework

xml with multiple grouping

by: Stephen | last post by:

I have the following xslt and I am trying to use two levels of grouping. I am first grouping on the report category, then on the report type. The problem is I am sure I have to apply some sort of...

.NET Framework

Empty report grouping

by: Brian Coy | last post by:

I am creating a database to track scrap on a daily basis at my plant. I have to provide a weekly scrap report with the amount of each part scrapped per day. I have the basic database set up, and...

Microsoft Access / VBA

A2K: Report formatting issue grouping on "Fld<>'Value'"

by: ahaque38 | last post by:

Hello. Using A2K SP3, I am having the following problem with a report using "Sorting and Grouping". I have recently added a grouping in the reports for "Category2<>'CONTRACTS'". I have...

Microsoft Access / VBA

Formatting within Access report text controls - OR - sorting and grouping in Word

by: Mike MacSween | last post by:

tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...

Microsoft Access / VBA

report viewer tables and grouping

by: mafandon | last post by:

This seems easy, but can't seem to get past it. Using VB 2005. In my report viewer for a windows forms app not using sql 2005 reporting services. I can get the grouping to work just fine and...

.NET Framework

problem with crystal report 9 for dynamic multilevel grouping in postback of page

by: virendra | last post by:

hi, I am working on crystal report 9 in asp.net. I created multilevel dynamic grouping in CR. if page is load firsttime. and i am giving firstlevel of grouping or whatever it's working fine. but...

ASP.NET

Access Not Grouping Records

by: craig.buchinski | last post by:

Ok, i have a Access Database (which is used with my ESRI Arcmap) and i have written a query for a report to pull out our streetlights and group them by billing wattage. The problem is that it is...

Microsoft Access / VBA

Sorting/Grouping report on column(1) of combo box

by: Jimmy | last post by:

Is there a way to sort/group a report based on the second column of a combo box, i.e. the text associated with the primary key number?

Microsoft Access / VBA

Obtaining sub-totals within a report grouping

by: patjones | last post by:

Good afternoon: This seems like it shouldn't be hard, and then again this is how so many problems seem at the outset. My situation is this: I have a report called rptMain319, which is based...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

Similar topics