By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Question about datareports

P: 84
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
Share this Question
Share on Google+
6 Replies


lotus18
100+
P: 866
Hi

Can you post your query?

Rey Sean
Dec 13 '07 #2

P: 84
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
Expert 100+
P: 2,364
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

P: 84
Have you tried adding to the page header?
it now says:

"Control 'text1' cannot be placed in this section"
Jan 7 '08 #5

Expert 100+
P: 487
You have to group your records in report.
Jan 7 '08 #6

P: 84
You have to group your records in report.
and how do i do that ?
Jan 9 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.