jculkincys
asked on
Report question
Hello
This is probably a simple question but I have not worked with visual basic reports all that much
I am listing information about a customer on each page detail section with a logo as the page header
To populate the information I am using a datasource and datafields for text boxes
My problem is that I want to list comments for each customer
but the comments are in a different table then the customer information
so my sql for the comments goes something like thist
select top 8 * from comments where custid = rsreport.fields("Custid")
and then I try to applied the 8 comments to labels that are on the datareport
however when I go through the different pages of the report ( which show different customers )
they all have the same comments
FYI the comment labels are on the detail section as well
Thanks in advance for any and all help
Jculkincys
This is probably a simple question but I have not worked with visual basic reports all that much
I am listing information about a customer on each page detail section with a logo as the page header
To populate the information I am using a datasource and datafields for text boxes
My problem is that I want to list comments for each customer
but the comments are in a different table then the customer information
so my sql for the comments goes something like thist
select top 8 * from comments where custid = rsreport.fields("Custid")
and then I try to applied the 8 comments to labels that are on the datareport
however when I go through the different pages of the report ( which show different customers )
they all have the same comments
FYI the comment labels are on the detail section as well
Thanks in advance for any and all help
Jculkincys
The simplest way to do this is to group on Custid
and have it start a new page (force page break after each Custid)
and have it start a new page (force page break after each Custid)
ASKER
I am not sure I understand
so the top would be
Select * from customers
and then that would give them customer informtion for each customer (name, address, etc)
and the bottom would be
Select * from comments
group by custid
this doesn't seem right though
so the top would be
Select * from customers
and then that would give them customer informtion for each customer (name, address, etc)
and the bottom would be
Select * from comments
group by custid
this doesn't seem right though
No add a Command grouping in the DataReport itself. Will explain later -- got to go buy some ethernet switches for work right now before it gets too late.
ASKER
Ok just let me know - it would be a big help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER