?
Solved

Report question

Posted on 2005-03-22
7
Medium Priority
?
136 Views
Last Modified: 2010-05-02
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
Comment
Question by:jculkincys
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 2

Author Comment

by:jculkincys
ID: 13605369
Do I need a data environoment to do grouping?
0
 
LVL 4

Expert Comment

by:rdwillett
ID: 13607586
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
 
LVL 2

Author Comment

by:jculkincys
ID: 13612064
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 4

Expert Comment

by:rdwillett
ID: 13617740
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
 
LVL 2

Author Comment

by:jculkincys
ID: 13624512
Ok just let me know - it would be a big help
0
 
LVL 4

Accepted Solution

by:
rdwillett earned 2000 total points
ID: 13627086
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month15 days, 10 hours left to enroll

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question