473,320 Members | 1,974 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,320 software developers and data experts.

How to split report on Group data.....

Hi,

I have a report for which each record is a product.

I have the fields: ProductName and GroupCode

There may be several variants on each ProductName, BUT, with the same
group code

i.e.

Product A + Label, GROUP 1
Product A + Box, GROUP 1
Product A + Logo, GROUP 1

Product B + Label, GROUP 2
Product B + Box, GROUP 2
I want to print a report as follows:

List the records by ProductName as in 'A' above for example and then
place a line division after that group code, i.e. between Group 1
records & group 2 records.

I would also like to separate the groups via white and grey shading if
possible.

How do I do this

Thanks
David

Nov 14 '05 #1
3 3662
David wrote:
Hi,

I have a report for which each record is a product.

I have the fields: ProductName and GroupCode

There may be several variants on each ProductName, BUT, with the same
group code

i.e.

Product A + Label, GROUP 1
Product A + Box, GROUP 1
Product A + Logo, GROUP 1

Product B + Label, GROUP 2
Product B + Box, GROUP 2
I want to print a report as follows:

List the records by ProductName as in 'A' above for example and then
place a line division after that group code, i.e. between Group 1
records & group 2 records.

I would also like to separate the groups via white and grey shading if
possible.

How do I do this

Thanks
David

Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

Now create the report. Click on the Edit menu item and select Grouping
and Sorting.

As far as shading, there is some discussion on that in the Access
Developers Handbook. If you don't have it, check GoogleGroups.
Nov 14 '05 #2
Hi,

Re:
Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

What does uniqueValue do ?

All I want to do is add a horizontal rule accross the report page when
the GROUP changes, so that all the same grouped products are together.
There must be some simple VBA to do this in one of the headers ?

Thanks again

David
*** Sent via Developersdex http://www.developersdex.com ***
Nov 15 '05 #3
David Gordon wrote:
Hi,

Re:
Create a query. Drop the Group and ProductName. Right click in some
white space near a table and set the properties to UniqueValues = Yes.

What does uniqueValue do ?
If you have 10 GroupA's, it only returns 1 record, not all 10. I
misunderstood your question.
All I want to do is add a horizontal rule accross the report page when
the GROUP changes, so that all the same grouped products are together.
There must be some simple VBA to do this in one of the headers ?
As I mentioned in my first post, go to Google Groups. I entered the
following
shading report lines group:*access*
into the search box.

Thanks again

David
*** Sent via Developersdex http://www.developersdex.com ***

Nov 15 '05 #4

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

Similar topics

0
by: David Elliott | last post by:
I am trying to group data. I have a daily record that contains multiple projects and multiple items in the project. I would like to roll the daily data into project 1 and all the items that go...
1
by: Mojca | last post by:
I have a problem with a report of data entered on the current day. Data are enter in a continous form. In this form I have field named Current_date_entered_data – text box which has default value...
7
by: SueB | last post by:
Greetings. I have a report based on the following query (hang in there ... it's quite long): SELECT Year(.) AS Yr, tblEvents.eventID, tblEvents.eventname, tblEvents.eventhost,...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
1
by: Maria | last post by:
Hello! I am new to Crystal reports an I have problems passing parameters form outside to Crystal report an creating a report with data from more than one table This is the problem: I have to...
2
by: develguy | last post by:
I am having trouble figuring this one out... Hopefully someone can help! I have a table ("tbl1") It has five (5) fields: 1- "Item1" 2- "Item2" 3- "Item3" 4- "ScanImage" (stores scan...
4
by: nachu | last post by:
I Would Like To Know The Basics Of Data Report And Data Environment As, How To Use Them Or For What Are They Used For,
5
by: HowHow | last post by:
First time using crosstab query because tired of creating queries and put them together in one query (such a stupid thing to do :D). Not sure how it works still. I have link table called...
2
by: fpimentel | last post by:
I need to know if an especific report has Data, becouse i have an application which communicates with Reporting Services through a web Services and on some occasions the web services run a report and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.