hide duplicates.. another pdf bug?

I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

sql

Hidden columns/blank PDF page(s)

I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail...

Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after?

Thanks.

Oh well, guess there is no way to do it. I have seen many other posts of people trying to do the same thing. I wish someone from Microsoft would just say it's impossible so I could forget about trying to come up with a workaround... Doesn't seem like the functionality I am after is asking too much. Actually, I pretty much consider the PDF rendering the blank space to extra pages to be a rendering bug... Seems the renderer could be capable of clipping blank space... My 0.02 rant.|||I'm having the same issue so if anyone, especially someone from MSFT, has any ideas I'd be very eager to hear them.|||

Hello Iago,

I have found a work around for this problem. It’s a bit hacky, but does work.

1.Collapse all table columns to the smallest they can go so width = .125

2.Resize the DESIGN gird to the smallest it can go

3.Set the CanGrow property = FALSE for each cell that has text.This will suppress the vertical size of the text to the row height that you have specified

4.Create a new report in the same project.

5.Create a dummy dataset in the sub report.I usually use: SELECT NULL

6.Pull a table onto the grid and delete all but one cell

7. Set the cell = “”

8.Set the column width to the column width you had in the original report say .625

9.Return to your original report and create an additional header on the report

10. Drag a sub report into each column of the new header cell and set it equal to the new report

11. Run the report.Hidden columns now only take up the .125 space.

HELP: How to do batch PDF printing using reporting services?

HELP: How to do batch PDF printing using reporting services?
Any advice greatly appreciated.
cheers,
jordan.WHat a subscription to push out the Report as a report PDF File or write
your own program to trigger the WEBAPI to write the Report in a configurable
(in your application) folder.
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Jordan Tan" <jordantan@.msn.com> schrieb im Newsbeitrag
news:urdQHFjRFHA.204@.TK2MSFTNGP15.phx.gbl...
> HELP: How to do batch PDF printing using reporting services?
> Any advice greatly appreciated.
> cheers,
> jordan.
>