Ingnoring lines and values in report

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

I have a report that produces a commission for our customers.

Each row has details of a sale plus commission paid.
In addition, each sale may have any number of notes. Each not on a new line.

The notes are stored in separate table that is indexed by the sale id.

In order to show the data I join the commissions table to the notes table
(Outer join).

So, in my report I get at least one line per sale but may get more than
one - if there are a number of notes.

What I need to know is how I:

1. Hide ALL the fields in the line except the notes field on any but the
first line in each sale.

2. Prevent the duplicated line (due to the join) being counted towards the
total commission.

Any ideas how to do this?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Have you tried placing the notes in a subreport? You should then be able to
drop the join in the query feeding the main report and instead set the
Child/Master Link fields of the 2 reports to the join fields you currently
have in the query.
 
The simplest way to do this would be to create a report based on the Sale
table only. Use a subreport to display any notes under each sale.

Since the source query for the main report contains only one line per sale,
the totals in the Report Footer will be correct.
 
Not sure how to do a subreport.
Is it the same as sub-forms?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Got it working in a way.

The thing is that to make it work I had to put the sub-report below the data
line. I this case it does wondeful and shows the lines when needed and
closes up when there is nothing to show.

However, I would prefer to put it at the end of the line so that the first
line of the subreport will be level with the data line of the main report.
This works but then it doesn't shrink when there are no lines and always
uses up 3 lines in the report. How can I make it shrink even when it is in
parralel to the details line?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
It's OK.
Found the problem.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Back
Top