Question about datareports

[metalheadstorm]

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_Descrip tion Sale_Price

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3142)
Load Product_Code Product_Descrip tion Sale_Price

etc


But instead

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3142)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3143)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3144)
Load Product_Code Product_Descrip tion Sale_Price



I hope this is easy to understand :)

[lotus18]

Hi

Can you post your query?

Rey Sean

[metalheadstorm]

im guessing u meen the SQL, so here it is

SELECT Invoice.Invoice _ID, Invoice.Custome r_ID, Invoice.Product _Code, Invoice.Load, Product.Product _Description, Product.Sale_Pr ice, Customer.Title, Customer.First_ Name, Customer.Surnam e, Customer.Addres s_Line_1, Customer.Addres s_Line_2, Customer.Post_C ode
FROM Product INNER JOIN (Customer INNER JOIN Invoice ON Customer.Custom er_ID = Invoice.Custome r_ID) ON Product.Product _Code = Invoice.Product _Code;

[Dököll]

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_Descrip tion Sale_Price

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3142)
Load Product_Code Product_Descrip tion Sale_Price

etc


But instead

Mr Bob John Customer ID(1)
Address1
Address2
PCode

Invoice ID (3141)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3142)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3143)
Load Product_Code Product_Descrip tion Sale_Price

Invoice ID (3144)
Load Product_Code Product_Descrip tion Sale_Price



I hope this is easy to understand :)

Have you tried adding to the page header?

[metalheadstorm]

Have you tried adding to the page header?

it now says:

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

[CyberSoftHari]

You have to group your records in report.

[metalheadstorm]

You have to group your records in report.

and how do i do that ?