Showing posts with label placed. Show all posts
Showing posts with label placed. Show all posts

Tuesday, March 20, 2012

RepeatWith problem

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?
> >

Monday, March 12, 2012

repeating free form list item fields for each group

Hi, I have a nested report where i have some dept name and address fields placed in the free form list, below the address fields i have the related employee info in a table. i have grouped on the dept id for both the list and table. for a particular dept , when the related employee table information goes on to the next page i want to repeat the dept name and address fields on each page for the group.i cannot place the fields in the group header of the table, since there are a lot of fields at different positions .so i have kept in free form in the list region.It's basically the group header information, i wanted repeated on each page, but i have placed the fields above the table, in free form.Please help. Really apreciate it . Thanks.

You can nest rectangles and text boxes in group and table header cells. This means it is possible to create a free form layout in the table or group header.

For example, you can add a rectangle to the group header cell in your table and then add multiple text boxes or images to that rectangle at any position you desire.

|||Thanks a lot.