I have a report where, among other things, I want to show a multi-page table
with some text on top of each page containing that table. So I placed a
textbox above the table and set the RepeatWith property of that textbox to
repeat with the table.
But when I run the report , the textbox is not there (except on the first
page).
However if I place the same textbox next to the table (on either side) then
the textbox shows up with each new page. Is this by design or is this a bug?
Does RepeatWith actually mean RepeatNextTo?Isaak,
I had a similar issue however I put both the textbox and the table inside
a list box to keep them together. Both were tied to the same dataset (since
I had read that could be an issue). and I had the box checked on the advanced
properties of the textbox to repeat item with data region on new page ==> and
the data region was the table just below it. It didnt work. I had to
abandon that idea and create a TABLE HEADER which contained the field that I
wanted to put in the textbox. I checked to repeat table header on each new
page ... and I have been able to see that work perfectly for my situation.
Hope this helps you ... I would *still* like to know why the Repeat Item is
NOT working ... as the table header solution wont be useful in all cases.
"isaak" wrote:
> I have a report where, among other things, I want to show a multi-page table
> with some text on top of each page containing that table. So I placed a
> textbox above the table and set the RepeatWith property of that textbox to
> repeat with the table.
> But when I run the report , the textbox is not there (except on the first
> page).
> However if I place the same textbox next to the table (on either side) then
> the textbox shows up with each new page. Is this by design or is this a bug?
> Does RepeatWith actually mean RepeatNextTo?
>|||I contacted Microsoftt about this problem and was able to confirm that
this is an outstanding issue with Reporting Services 2005. Microsoft has
scheduled a fix for the problem in the next release of SQL Server, which
should be available in 18-24 months.
"MJT" wrote:
> Isaak,
> I had a similar issue however I put both the textbox and the table inside
> a list box to keep them together. Both were tied to the same dataset (since
> I had read that could be an issue). and I had the box checked on the advanced
> properties of the textbox to repeat item with data region on new page ==> and
> the data region was the table just below it. It didnt work. I had to
> abandon that idea and create a TABLE HEADER which contained the field that I
> wanted to put in the textbox. I checked to repeat table header on each new
> page ... and I have been able to see that work perfectly for my situation.
> Hope this helps you ... I would *still* like to know why the Repeat Item is
> NOT working ... as the table header solution wont be useful in all cases.
> "isaak" wrote:
> > I have a report where, among other things, I want to show a multi-page table
> > with some text on top of each page containing that table. So I placed a
> > textbox above the table and set the RepeatWith property of that textbox to
> > repeat with the table.
> > But when I run the report , the textbox is not there (except on the first
> > page).
> > However if I place the same textbox next to the table (on either side) then
> > the textbox shows up with each new page. Is this by design or is this a bug?
> > Does RepeatWith actually mean RepeatNextTo?
> >
Tuesday, March 20, 2012
RepeatWith problem
Labels:
among,
containing,
database,
microsoft,
multi-page,
mysql,
oracle,
page,
placed,
repeatwith,
report,
server,
sql,
table,
text
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment