No HTML page breaks and slow expanding rows

I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.

Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.

As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.

I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break? I've seen a lot of posts on this, but none that seem to have an answer.

Anyone? Can I programmatically add the soft page breaks? The report is useless as it is now.|||

Thanks to others, I found a solution. Use the query to calculate the count of headers using the dense_rank() function:

select ...

dense_rank() over ( order by cl.last_name, cl.first_name, cl.client_id ) AS ClientRank

Then add a top level grouping on the table set to "Page Break at End" with the formula:

=Ceiling(Fields!ClientRank.Value/15)

replace 15 with how many group headers you want per page.

-Dave

sql

NewLine and Carriage return issue in PDF format

If I insert the following expression in a textbox it will display
correctly in HTML format but not in PDF format. Can anyone show me how
to accomplish the same thing so that it will display correctly in both
HTML and and PDF format.
vbCrLf & vbCrLf & vbCrLf & "My Text"
In HTML format, it will display "My Text" on the 4th "row". Whereas in
PDF format, it displays "My Text" on the first row of the textbox.This has to be an issue (bug) with PDF and how it formats initial blank
space before the literal text. I am not sure if this is addressed in a
service pack for 2000 or in 2005 (I am using 2000 to test this) but here is
a workaround that I found that places an ASCII record seperator in the first
position before the CRLF's as:
=CHR(30)&vbCrLf & vbCrLf & vbCrLf & "My Text"
That should work.
Rodney Landrum
<Nergock@.gmail.com> wrote in message
news:1143588675.322590.215140@.u72g2000cwu.googlegroups.com...
> If I insert the following expression in a textbox it will display
> correctly in HTML format but not in PDF format. Can anyone show me how
> to accomplish the same thing so that it will display correctly in both
> HTML and and PDF format.
> vbCrLf & vbCrLf & vbCrLf & "My Text"
> In HTML format, it will display "My Text" on the 4th "row". Whereas in
> PDF format, it displays "My Text" on the first row of the textbox.
>

Newbie: printing question

Please (do not) confirm:
- To have a "print" button on report in order to print a report and not the
html page do I need to wait for sp2?
When could the sp2 be available?Yes, print functionality will be available in SP2 in the form of a
downloadable control. SP 2 is currently undergoing beta testing and it
should be out before the end of the year based on what I know. So, make a
wish to Santa if you've been a good boy :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Marko Linke" <mlinke@.inet.hr> wrote in message
news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
> Please (do not) confirm:
> - To have a "print" button on report in order to print a report and not
the
> html page do I need to wait for sp2?
> When could the sp2 be available?
>|||Sure it helps, thank you very much! So, then, first I'll start by helping
people cross the street and polishing my shoes for Santa's name day 6th
December in hope SP2 will fit my chimney later on. I'll also tip my boss to
do the same :-)
Best regards,
Marko
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:%23rZG7cZ0EHA.3156@.TK2MSFTNGP10.phx.gbl...
> Yes, print functionality will be available in SP2 in the form of a
> downloadable control. SP 2 is currently undergoing beta testing and it
> should be out before the end of the year based on what I know. So, make a
> wish to Santa if you've been a good boy :-)
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Marko Linke" <mlinke@.inet.hr> wrote in message
> news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
>> Please (do not) confirm:
>> - To have a "print" button on report in order to print a report and not
> the
>> html page do I need to wait for sp2?
>> When could the sp2 be available?
>>
>|||You never know what works :-)
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Marko Linke" <mlinke@.inet.hr> wrote in message
news:uhiv34e0EHA.3588@.TK2MSFTNGP14.phx.gbl...
> Sure it helps, thank you very much! So, then, first I'll start by helping
> people cross the street and polishing my shoes for Santa's name day 6th
> December in hope SP2 will fit my chimney later on. I'll also tip my boss
to
> do the same :-)
> Best regards,
> Marko
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:%23rZG7cZ0EHA.3156@.TK2MSFTNGP10.phx.gbl...
> > Yes, print functionality will be available in SP2 in the form of a
> > downloadable control. SP 2 is currently undergoing beta testing and it
> > should be out before the end of the year based on what I know. So, make
a
> > wish to Santa if you've been a good boy :-)
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> > "Marko Linke" <mlinke@.inet.hr> wrote in message
> > news:ufPVShU0EHA.4004@.tk2msftngp13.phx.gbl...
> >> Please (do not) confirm:
> >>
> >> - To have a "print" button on report in order to print a report and not
> > the
> >> html page do I need to wait for sp2?
> >>
> >> When could the sp2 be available?
> >>
> >>
> >
> >
>