0

I have a report which spans multiple pages and has repeating row headers. When I preview / export the PDF in BIDS, everything looks fine, the row headers repeat on each page.

However, after deploying the report to the report server and opening it via Internet Explorer, then exporting it to PDF as well, the row headers do not show up on all pages.

I don't know if this is a general issue or if it's dependent on the tablix, subreports, ... If it's not a general issue, I can provide some screenshots as well.

Screenshots:
BIDS Development: BIDS Development

BIDS PDF Page 3: BIDS PDF Page 3

BIDS PDF Page 4: BIDS PDF Page 3

Server PDF Page 3: Server PDF Page 3

Server PDF Page 4: Server PDF Page 4

Harry
  • 21
  • 6
  • That is odd, since same PDF rendering code is used by both BIDS designer and Report Server. Can you provide some screenshots? – user1578107 Jan 27 '13 at 06:48
  • That *is* odd. Is your server completely patched and up to date? Is the data for both reports the same? (PS. Have you triple-checked that you're running the same report on the server?) – Jeroen Jan 27 '13 at 14:46
  • @Jeroen The data is definitely exactly the same and it's definitely the same report (in the same version). As to the server I can't exactly tell, but I would think so, yes. – Harry Jan 28 '13 at 13:07
  • Then you probably have a problem on page 3 already: the screenshots you posted suggest the data (even before the headers problem) is different between P3 in BIDS (showing "Neue Aktiviteiten" at the bottom) and P3 on the Server (showing more rows, amongst others "Kunde/Land", "Zusammenfssung"). Perhaps that difference is causing the header problem as a side effect? – Jeroen Jan 28 '13 at 13:39
  • Well, the data is 100% the same. What you described is exactly my problem: The rendering there seems to be ever so slightly different, causing some fields to appear on different pages (I could live with that) and additionally not adding headers on some pages (unacceptable) – Harry Jan 28 '13 at 18:22
  • can you provide screenshots of pages 1 and 2? – user1578107 Jan 30 '13 at 05:39

1 Answers1

0

Ignore the results from BIDS - they are often different compared to the results from Report Server. I only preview in BIDS if Remote Errors are disabled on the server.

Test by Deploying to a test site/folder. Once you get in the swing of this it has other advantages e.g. remebering parameters, multiple windows/tabs.

Mike Honey
  • 14,523
  • 1
  • 24
  • 40