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.
| Author |
Topic |
|
kslowey
Starting Member
10 Posts |
 Posted - 2008-04-23 : 06:55:08
|
| Hi,I have found "as have many others" that when adding dynamic visibility " tosub_reports and tables etc" to SSRS reports then pagebreaks are switched off. Has anyone found a workaround for this? Or am I doing something wrong My report has one page per record grouped on an id. Each record has possible additonal information in another table which if present I would like to show on a new page. I can get this to work ok by just appending a subreport to the report based on the value of a report parameter, however this does not meet the requirement. I need to have the subreport on a new page for each record.Any comments welcome. |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-04-23 : 10:05:34
|
| Are you using a List item?If you are then the List item might just need some property adjustments. More info required how you sent up your List item.You should be able to use a List item as a container to your other text items to display and set the property in "Grouping and Sorting Properties" window ~ "Page Break at end" checked. |
 |
|
|
kslowey
Starting Member
10 Posts |
Posted - 2008-04-23 : 10:58:51
|
| HI tm,Thanks for the response.No,Hopefully I can explain better,I am using a table control populated by an "Issues" datasourse grouped on the "IDIssue" field with "insert page break at the end of this table" set in "Table Propeties->General" tab. This gives me "number of Issues" pages in my report, one page "in Report Viewer" for each "Issue". The "Issues" datasource also contains derived field "ActionCount" which counts instances of any relevant actions for "Issue" from an "Actions" table. If any "Actions" exist "ActionsCount > 0" then I want to insert a page break then another table/list/sub_report containing the relevant actions imediately after the issue.I already have a subreport which returns the correct "Actions" and inserts at the end of each "Issue" when just appending or embedding into main table. Just cant work out how to put "Actions" on new page using this or any other method. Thanks in advance |
|
|
|
kslowey
Starting Member
10 Posts |
Posted - 2008-04-23 : 11:10:40
|
| Hi tm,Sorry, table lives in a list also. |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-04-23 : 11:38:23
|
Instead of having a table in your List/Sub_Report, you should have individual text boxes in your List item.You can then set the List properties to group by the column and set the property to page break at end.I think this should work.I did some screen shots but don't know how to include in the reply  |
|
|
|
kslowey
Starting Member
10 Posts |
Posted - 2008-04-24 : 11:47:13
|
| Hi tm,thanks again fo the replyDont think I quite understand what you mean. Dont think I can get list with separate text boxes to show potential multiple "Action" records? |
|
|
|
kslowey
Starting Member
10 Posts |
Posted - 2008-04-30 : 03:31:25
|
| Hi tm,Nearly got it working. I can get the actions to show on a separate page on after the other, however when e.g Issue 1's actions are shown on a new page. Issue 2 follows issue 1 actions on the saem page. If I put in page breaks where you suggest, each action has its own page, and blank pages are inserted when an issue has no actions.Can you help?Regards |
|
|
|
|
|
|
|
|
Dynamic visability and page breaks