Add blank lines after end of data on group

I have a report that looks sort of like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Route: 456
Name: Monica
Name: Steve
which page breaks on "Route". What i need is to have blank lines to
fill to the end of the page like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Name:
Name:
Name:
Name:
Name:
Name:
Thank you in advance!
Cheers,
SteveOn Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
> I have a report that looks sort of like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Route: 456
> Name: Monica
> Name: Steve
> which page breaks on "Route". What i need is to have blank lines to
> fill to the end of the page like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Name:
> Name:
> Name:
> Name:
> Name:
> Name:
> Thank you in advance!
> Cheers,
> Steve
Unfortunately, this type of behavior is not supported; however, you
could try using a while loop and determining the number of records per
page in T-SQL (the stored procedure/query that is sourcing the report)
and then return (x - known records per Route) as null/blank rows,
where x is the number of records that will fit on a page when printed/
etc based on your desired export option. Another much less desirable
option would be to modify the report after the fact using a
custom .NET application that utilizes StreamReader, StreamWriter, etc.
With this option, you can control extra text down to the character;
however, this a good deal of work and most likely is not the best
option for you situation. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi
Heres another tip to do what you want , I assume you are using a
table. Place another column in your table and use =rownumber(nothing).
When you render the report, you'll see the number of rows which are
created prior to the page break. Lets say 10 rows are created. Now
write a stored proc or a query , something like this
Declare @.counter int
Declare @.Temp table (rowno int)
Set @.counter=0
While @.Counter<10
Begin
Insert into @.Temp
Select @.Counter
Set @.counter = @.Counter + 1
End
Select * from @.Temp
Now create another table object under the one you have created, with
one column , no header or footer and the above data source. Hardcode
the value "Name:" in the single column . That should do it. Please be
aware that I have not tested the code I have written.
Cheers
Shai
On Dec 5, 11:11 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
>
>
> > I have a report that looks sort of like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Route: 456
> > Name: Monica
> > Name: Steve
> > which page breaks on "Route". What i need is to have blank lines to
> > fill to the end of the page like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Thank you in advance!
> > Cheers,
> > Steve
> Unfortunately, this type of behavior is not supported; however, you
> could try using a while loop and determining the number of records per
> page in T-SQL (the stored procedure/query that is sourcing the report)
> and then return (x - known records per Route) as null/blank rows,
> where x is the number of records that will fit on a page when printed/
> etc based on your desired export option. Another much less desirable
> option would be to modify the report after the fact using a
> custom .NET application that utilizes StreamReader, StreamWriter, etc.
> With this option, you can control extra text down to the character;
> however, this a good deal of work and most likely is not the best
> option for you situation. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -