Problems with report

  • Thread starter Thread starter jln via AccessMonster.com
  • Start date Start date
J

jln via AccessMonster.com

Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is
pulling all bill for each inv and grouping by investor. But the report is
place each bill on a new page and not grouping them with the inv # . I need
all the bills for each investor to be on one page.
 
Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!
 
Thabks Jeff I was able to get it to seprate by inv with your help. But how do
i get it to create a new page when the investor number changes?

Jeff said:
Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!
Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is
Click to expand...
[quoted text clipped - 5 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
 
Put a Group Footer for inv # and look at the properties. Under the
Format tab, there is a setting called Force New Page. Change that to
After and you should get a new page.

Thabks Jeff I was able to get it to seprate by inv with your help. But how do
i get it to create a new page when the investor number changes?

Jeff said:
Check your sorting and groupings in the design of the report. If Name
is listed first then inv #, that is one problem that you have. You
should have the data sort by inv #, then name. You will also need a
group header for Inv # and put your investor info in the header. Your
bills should then be listed in the detail section.

Hope that helps!
Here is what im having a problem with.
Im have the report genrate off of a query that is going by Name, and it is
Click to expand...
[quoted text clipped - 5 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
Click to expand...
 
Back
Top