Hi
Pulled all my hair out now, can someone please offer some help before I go totally mad...
I have no page header, this is all in the body. I have a List with account number and job number in it at the top, called list1. In list1 I have list2, with the job details, basically a list of people who attended the job. The fields in list2 are textboxes, they're not in a table.
EG:
Acc No: 12345
Job No: 54321
Name
Fred Bloggs
Joe Bloggs
Etc
When my list2 of names goes over 1 page, I want to repeat the account number and job number on each subsequent page. In my real report I actually have 10 fields I want to repeat.
I then want to be able to export this report to a PDF.
I can't put the header in the page header
and RepeatWith doesn't work when exporting to PDF, or at all depending on what mood it's in.
Does anyone have a workaround for this please?
Cheers
HiI don't want to ask the obvious but why can't you use a table? I initially used listboxes for most of my reports but have since found that I can use tables for almost anything once I start merging cells and things like that.
|||
Hello.
I can't use a table because I have all different spacing between the columns and rows. It's not a list of data as in my example, I've just made it simpler in that so it's easier to understand the problem.
For info, in the meantime, I've used an answer provided at the top of this page http://forums.microsoft.com/msdn/showpost.aspx?postid=638813&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 which I really didn't want to do because it's so damn messy. But it does mean I can have information in the page header and it appears on more than just the first page. Silly me for thinking I can use a Repeat property and it will actually work.
It's so funny reading posts, MSDN and websites about this problem when MS try to justify why this is so difficult to achieve and what the problems are behind it, as if it's something so out of the ordinary people will just accept it the reasoning behind it. I'd love to have been in that meeting where someone said we're releasing RS without the ability to put data in the page header/footer, surely they were sacked on the spot....weren't they?
No comments:
Post a Comment