How to Print blank line when value changes

[lorirobn]

Hi,

Lots of report q's for tek-tips today!

I have a report with a subreport that prints a detail line for every record read. I would like to skip a line (print a blank line) when the room number (the main sort field) changes. How can I do this?

I'm not sure if I would check in the main report (I suspect so) or the subreport, but once I know how to do it, perhaps I can play around with where to put it.

My sorts are in the query that I use as record source (main report uses a query, subreport uses another query). I do not use sorting and grouping within the report.

Thanks in advance for any help.
Lori

 

[lorirobn]

Oops, I got it - by adding some space below the subreport's control on the main report's detail section. That was easy - not sure if it's the only way, but it worked.

 

[TheAceMan1]

How are ya lorirobn . . .

Instead of wasting the lines have you considered [blue]Group By[/blue]?

I don't know how the report looks now but here's an example using and indent for the rest of the fields:

[blue]NewRoom#
The rest of the fields & records for NewRoom# above
.
.
NewRoom#
The rest of the fields & records for NewRoom# above
.
.
.
NewRoom#
The rest of the fields & records for NewRoom# above
.
.[/blue]

There are a number of ways to setup the view.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .