Friday, March 23, 2012

list's visibility dependable on expression doesn't pagebreak

The report has a "first page".
After this comes a list element with a subreport.
This list is grouped and each group element should be printed on a new page
(43 pages).
This works perfectly in HTML and PDF
We introduced a boolean parameter to express, if we want to see only the
first page or the first page AND also the 43 pages from the list.
So the list's visibility was made dependable on the boolean parameter.
If the user checks to NOT to see the 43 pages, the list is hidden and only
the first page shows up, ok, good.
But the moment the user wants to see the list, there occur NO pagebreaks in
HTML.
And in PDF the first pagebreak does not occur.
I tried for hours a lot of things, but no chance.
The moment the list's visibility is made dependable on an expression, the
pagebreaks do not work anymore.
Things I tried that did not work:
- insert a rectangle in various ways in the list and break before or after it
- insert a table with pagebreak before or after it
- insert a table and inside it a rectangle in a group and pagebreak on the
rectangle
What shall we do?Hi,
This is a quick note to let you know that I am performing research on this
issue. I will let you know the response as soon as possible.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Henry,
I understand that when you try to use the expression to control the
visability of your list, the page break inside the list will disappear.
This is confirmed to be a by design issue and did not have any workaround
yet.
However, in SQL 2008, product team is considering add the expression to
control the page break and this will may resolve your issue.
Hope this helps.
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.|||Thank you very much Wei Lu for this concise sentence,
it is the expected answer after so much research I did.
Good news:
This is NOT an issue In SSRS 2008 CTP November 2007
I tried it one hour ago and there it works.
Sincerely, Henry|||Hello Henry,
Thanks for your update.
If you have any questions, please feel free to let me know.
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.sql

No comments:

Post a Comment