Adding blank lines to a report -2nd request

I am trying to add additional blank lines to a report based on how much room
is left on a page. If there are 6 lines of datarows, I need there to be 15
lines of blank lines. if there are 15 lines of datarows I need 6 blank lines
added.
I am currenly using a table object with a static number of header rows with
the bottom lined. Any suggestions would be appreciated.Hello Eric,
I would like to suggest you to add another table under your table.
Also, you need to add a dataset which contain 21 lines records. And you
could use a filter to control how many rows to show.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||That is how I am currently doing the extra lines I have now. I have a table
that is simply all header rows. But I havent figured out how to do a
'filter' when there is not a dataset attached to it.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:XQ4UvMzHHHA.1220@.TK2MSFTNGHUB02.phx.gbl...
> Hello Eric,
> I would like to suggest you to add another table under your table.
> Also, you need to add a dataset which contain 21 lines records. And you
> could use a filter to control how many rows to show.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Eric,
You could create a table with just one column "ID"
Then, you could insert just 21 rows in the table.
After that, you could use this statement to get the new dataset which
contain only 2 column:
SELECT id, ' ' as Text from <table name>
The filter could be setted like this:
ID <= 21-Rownumber('your first dataset name')
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||You don't even need a table. Have your dataset be on generic designer mode
(button is to the right of the ...) and use a Union statement
select 1 as ID, ' ' as Text union
select 2 as ID, ' ' as Text union
select 3 as ID, ' ' as Text union
select 4 as ID, ' ' as Text union
select 5 as ID, ' ' as Text union
select 6 as ID, ' ' as Text union
.
.
.
select 25 as ID,' ' as Text
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:oZZxARBIHHA.2024@.TK2MSFTNGHUB02.phx.gbl...
> Hello Eric,
> You could create a table with just one column "ID"
> Then, you could insert just 21 rows in the table.
> After that, you could use this statement to get the new dataset which
> contain only 2 column:
> SELECT id, ' ' as Text from <table name>
> The filter could be setted like this:
> ID <= 21-Rownumber('your first dataset name')
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Bruce,
Yes, you could use the union in the dataset.
The reason why I recommand the table is for some performance concern and
more efficant management.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.