Repeat Table Group - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Repeat Table Group

Author

Topic

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-08-06 : 15:42:40

All,

I have a report that consist of table as below.All of these are table rows.No header & footer rows.

Row 1 / 1st column : Expression "User Info'
Row 2 / 1st column: " Name" & txtBoxname.value
Row 2 / 2nd column : Previous( txtBoxid.value)
Row 2 / 3rd column : IIF ( txtboxadd.value="Ave","",txtboxadd.value)
Row 3 / 1st column : Additional column being ref here [ salary , benefits ].

Each user info is being printed across an average of 3 pages.
At the begining of each new user,1st page ,the Row 1 & 2 is printed followed by the other rows of table.[about 60 rows in total].

My problem is I want the Row 1 & 2 to be printed on each page for the same user pages.Example page 1 - 3.
And when the record moves to next user page.Row 1 & 2 should be printed once again across all pages belonging to that user.

Since I have [Row 2/ 2nd Column] using Previous.Im not able to add Row 1 & 2 as a table header.

When I try to group Row 1 & 2 to the table Group,and pick "Include Group Header" & "Repeat Group Header'.No changes are applied.

Im out of ideas...to solve this.....Someone HELP Me Out !!!!!!!!

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-08-07 : 01:01:43

Sometimes it behaves a little differently when depolyed. Did you try deploying it to see how it looks on the report server. Did you also have page break at end of group set?

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-08-07 : 09:15:08

Could you confirm the below:
Inorder for me to have the first 2 rows repeat on each page,Do they need to be part of table header? On which I create a group,that has the expression of both row 1 & 2 in it.Then I go ahead and select include group header, Repeat Group Header.
On the table properties,I select "Repeat On Every Page" to True.

When I view my report in Report Mng.The entire reports fits on 1 page,but when I export it to pdf or Excel.It crosses more than 2 pages[varies for different user].

How Do I add a page break ?

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-08-08 : 11:08:38

All,

Read from below and currently am trying it.

http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx

1) Created a txt box on Report Header.That has a value of
=ReportItems!textbox1.Value [Refers to a textbox1 in Report Body]
2) TextBox1 value refers to the ID column from DataSet1.
3)I have set the Visibility of TextBox1 to hidden.

On execution in the browser the ID reflects different values based on the user info.Which is correct!

Problem is when I export the report to PDF or try to print.Report spans more than 1 page and only the first page of the report reflects the ID value.The other report header items [Image & Time] however repeat on every page.Why is the ID not repeated across multiple pages ?Any properties settings ?

What am I missing out on here?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-08 : 13:10:29

Are you putting it in page header portion? then i think it will automatically in all pages.

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-08-08 : 13:32:44

Visakh,
This is what I have done for now,

Page Header
I created a textbox1 in the page header.
The textbox1 has a value of =ReportItems!textboxID.value
** Page Header has other items,such as Image, Current Date Time

Page Body
I have a textboxID, that refers to DataSet1 column ID.
I have set the visibilty to "Hidden"
** Page Body also has few other table that refer to the same user information,based on same ID .[Table 1- Salary Info], [Table 2- Medical Info], [Table 3 - Personnel Ifo]

When I click on textbox1 property,I only see a "Repeat With" ,where you would need to specify the Data Region.

When I preview the report in the Preview tab of VS .I see the textbox1 value on all the pages change,as I move from 1 page to the other.

No Prob in VS as report fits in 1 page

Problem happens, once I deployed the report and export the report to pdf format.The report for each user spans across multiple pages and the contents of the page header does not repeat on the multiple pages,but only repeats on the 1st page belonging to the user

Currently deployed this is how it looks.
User 1
Page 1
Header Has : Image and DateTime and ID : 2231
Page 2
Header Has : Image and DateTime
Page 3
Header Has : Image and DateTime

Report should look like this,once exported
User 1
Page 1
Header Has : Image and DateTime and ID : 2231
Page 2
Header Has : Image and DateTime and ID : 2231
Page 3
Header Has : Image and DateTime and ID : 2231

Do let me know,where I can set it to behave as above .

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-08 : 13:38:27

Is this heppening only on exporting to pdf? have you tried viewing it in report viewer?

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-08-08 : 14:02:51

Once report is deployed,and I export it to pdf or even click on the print icon on Report Manager and Preview.

I get the same output.

Im not sure if the problem is with the length of page,as when I preview report in "Preview" tab of VS.It is 1 page per user.

Once Deployed it is 1-3 pages per user on Report Manager.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources