Question about datareports - Visual Basic 4 / 5 / 6

Ok i have a data enviroment and datareport in my project which are working fine ( in the sence that they connect and the info is showing up)

The question is, how do i list records and show all the info associated with it.

Hes a pic of my report
http://img155.imageshack.us/img155/292/drss1hc5.jpg

what i meen is i want the customer info (title, First name, Surname etc) to be displayed and then all the invoices for that customer and there info to be displayed under it. Rather than

Mr Bob John Customer ID (1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Description Sale_Price

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3142)
Load Product_Code Product_Description Sale_Price

etc

But instead

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Description Sale_Price

Invoice ID (3142)
Load Product_Code Product_Description Sale_Price

Invoice ID (3143)
Load Product_Code Product_Description Sale_Price

Invoice ID (3144)
Load Product_Code Product_Description Sale_Price

I hope this is easy to understand :)

Dec 13 '07 #1

Subscribe Post Reply

1235

lotus18

866

512MB

Hi

Can you post your query?

Rey Sean

Dec 13 '07 #2

metalheadstorm

im guessing u meen the SQL, so here it is

SELECT Invoice.Invoice_ID, Invoice.Customer_ID, Invoice.Product_Code, Invoice.Load, Product.Product_Description, Product.Sale_Price, Customer.Title, Customer.First_Name, Customer.Surname, Customer.Address_Line_1, Customer.Address_Line_2, Customer.Post_Code
FROM Product INNER JOIN (Customer INNER JOIN Invoice ON Customer.Customer_ID = Invoice.Customer_ID) ON Product.Product_Code = Invoice.Product_Code;

Dec 13 '07 #3

Dököll

2,364

Expert 2GB

Ok i have a data enviroment and datareport in my project which are working fine ( in the sence that they connect and the info is showing up)

The question is, how do i list records and show all the info associated with it.

Hes a pic of my report
http://img155.imageshack.us/img155/292/drss1hc5.jpg

what i meen is i want the customer info (title, First name, Surname etc) to be displayed and then all the invoices for that customer and there info to be displayed under it. Rather than

Mr Bob John Customer ID (1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Description Sale_Price

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3142)
Load Product_Code Product_Description Sale_Price

etc

But instead

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Description Sale_Price

Invoice ID (3142)
Load Product_Code Product_Description Sale_Price

Invoice ID (3143)
Load Product_Code Product_Description Sale_Price

Invoice ID (3144)
Load Product_Code Product_Description Sale_Price

I hope this is easy to understand :)

Have you tried adding to the page header?

Dec 16 '07 #4

metalheadstorm

Have you tried adding to the page header?

it now says:

"Control 'text1' cannot be placed in this section"

Jan 7 '08 #5

CyberSoftHari

487

Expert 256MB

You have to group your records in report.

Jan 7 '08 #6

metalheadstorm

You have to group your records in report.

and how do i do that ?

Jan 9 '08 #7

Similar topics

Simple Java/XML question

by: Stevey | last post by:

I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>

.NET Framework

ASP.NET 2.0 question on Partial Types with J.I.T.

by: nospam | last post by:

Ok, 3rd or is it the 4th time I have asked this question on Partial Types, so, since it seems to me that Partial Types is still in the design or development stages at Microsoft, I am going to ask...

.NET Framework

Migration of VB 6 MS datareports to 2003 Net Crystal reports

by: Colby | last post by:

The 2003 net upgrade wizard can not handle migration of MS datareports (VB version 6 DSR) to crystal reports version 9.x RPT. How do you migrate MS datareports to crystal reports? Thanks for...

.NET Framework

Filling question ID automatically by using query or VBA

by: Ekqvist Marko | last post by:

Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...

Microsoft Access / VBA

asp question about post vars

by: glenn | last post by:

I am use to programming in php and the way session and post vars are past from fields on one page through to the post page automatically where I can get to their values easily to write to a...

ASP.NET

Question about "Configuration Error" Message

by: Rider | last post by:

Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server...

ASP.NET

Question about the clc string lib

by: Jeff | last post by:

In the function below, can size ever be 0 (zero)? char *clc_strdup(const char * CLC_RESTRICT s) { size_t size; char *p; clc_assert_not_null(clc_strdup, s); size = strlen(s) + 1;

C / C++

Question about the *= (and similar) operator

by: spibou | last post by:

In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?

C / C++

datareports error on dif pc

by: metalheadstorm | last post by:

Ok, I've been working on datareports for my project whilst at college but when I got home and open my project it says it can't load my dataenvironment. Here's what the log says: Line 2: Class...

Visual Basic 4 / 5 / 6

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

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