• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

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
0
jculkincys
Asked:
jculkincys
  • 3
  • 3
1 Solution
 
jculkincysAuthor Commented:
Do I need a data environoment to do grouping?
0
 
rdwillettCommented:
The simplest way to do this is to group on Custid
and have it start a new page (force page break after each Custid)
0
 
jculkincysAuthor Commented:
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
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
rdwillettCommented:
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.
0
 
jculkincysAuthor Commented:
Ok just let me know - it would be a big help
0
 
rdwillettCommented:
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now