Layout of Report

[Jacob Frankham]

Hi

Is it possible to have report detail starting on the same line as the group
header eg

Books Book Name
Book Name
Book Name
Book Name

DVDs DVD Name
DVD Name
DVD Name
etc etc

?

I prefer this than the 'stepping' because many of the items I am grouping by
may only have 1 object assigned to it so it looks messy ie

Books
BookName
DVDs
DVD Name
etc etc

Thanks

Jake

 

[Allen Browne]

Place the heading field into the detail section, and set its Hide Duplicates
property to prevent it showing up on every line.

 

[Jacob Frankham]

BRILLIANT !!!

How easy is that !!!! Thanks v much Allen

On the same thread then, would you be able to do the following?

Say I have a textbox on my report which is summing a fields values by a
group eg

CustomerName Invoice1Value
Invoice2Value
Invoice3Value
Invoice4Value

TotalInvoiceValue

Would it be possible to have TotalInvoiceValue on the same line as
Invoice4Value ie

CustomerName Invoice1Value
Invoice2Value
Invoice3Value
Invoice4Value
TotalInvoiceValue

Cheers mate

Jake

 

[Allen Browne]

Place another text box in the detail section, and give it these properties:
Control Source InvoiceValue (i.e. your field name)
Format Currency (assuming that's what you want).
Runnng Sum Over Group

The Access reporting is not bad, eh?

 

[Jacob Frankham]

Hi Allen

That doesn't appear to work

I have 3 grouping levels - maybe why?

It is putting a sum for each record (ie the same as each InvoiceXValue)

Maybe it is getting confused over which group to sum?

Jake

 

[Allen Browne]

Probably so.

If you can't achieve it with a running sum, you can use a DSum() expression,
though that would get messy when the report is opened with a filter.