locked
Report missing rows when exporting to PDF after expanding collapsible data RRS feed

  • Question

  • Hi All,

    We're having an issue in a report whereby the report contains collapsible/expandible rows, and should you expand all rows on the report, totals calculated at the bottom will not be displayed when exported out in a PDF.

    If you leave all rows collapsed then the totals are displayed correctly but if you expand one row then the non-expanded row's figure is displayed as the page/running total, very frustrating.

    This has been done in Report Builder 2016 and is using SQL Server 2016 and SSRS 2016. Please excuse any ignorance on my part, i'm relatively new on the report building process.

    Thanks,

    Sean

    *Tried adding images to which "Body text cannot contain images or links until we are able to verify your account" despite it being an Office365 account... Excuse the tangent*

    Friday, August 3, 2018 2:12 PM

All replies

  • Hi Sean Swindell

    According to your description , it was by design that if you expand one row then the non-expanded row's figure is displayed as the page/running total.

    According to the official document , Dynamic show and hide elements are not supported in PDF. So the pdf would just displayed as what the current report like.

    As for “totals calculated at the bottom will not be displayed when exported out in a PDF” , could you please offer the detailed report structure ,the preview snapshot and the pdf snapshot for use ?(you could post your file into cloud disk like :one drive , google drive , then paste the url as text here. The rdl file with data sample is best)

    The above scenario would be occurred when you set the expression for your total’s row visibility as : =Iif(Globals!RenderFormat.Name="PDF",True,False)

    So when you export your report to pdf , the total row would be disappeared.

    Does the total displayed in the report too ( in preview mode)? Does the total for the whole table or each group ?

    More information about the export pdf render at:Exporting to a PDF File (Report Builder and SSRS)

    Looking forward to your reply.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Monday, August 6, 2018 6:20 AM
  • Hi Eric,

    It's not that we're expecting the PDF to be able to expand the rows, it's that if you expand the rows in report builder or when published and then export that view to PDF, figures in two rows at the bottom of the same page disappear.

    https://imgur. com/Cu8Z05w

    As you can see when the rows are expanded the page total and running total disappear. If you expand only one row, export to PDF, the page total and running total display but are incorrect.

    https://imgur. com/Cy683tn

    The rows visibility does not contain the display statement, this was the first thing checked.

    Thanks,


    Sean

    Monday, August 6, 2018 1:44 PM
  • Hi

    According to your reply and the image , lucky to get what the exactly issue like.  Unfortunately, we still couldn’t judge the reason why the issue caused.

    Per my understanding ,if your report works fine , then the pdf should be ok too.  how is the report render under the preview mode or in report manager.

    How is the report structure like ? does the “page total” ,”running total ”,”grand total” locate at the bottom of the table or locate at the report footer?

    And what the expression used for the “page total” ,”running total ”,”grand total”? what the expected result should be displayed in this total group?

    Do you have expression return blank manually kike :=iif(xxxx,””,xx)?

    and does the date influence the report total result ? I see you use

    datefrom: 01/01/2018     dateto:28/12/2018  in first iamge,

    dat from :01/01/2018     date to:04/11/2018  in second image

    Seems that your issue is so special . It is best to offer the detailed rdl file with the data sample for us. so that we could go on further research about the issue more conveniently.

    BR,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    Tuesday, August 7, 2018 6:51 AM