Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Reporting Services: Groups - keep together -> can't find it
I've got a little problem.
I'm deploying reports in RS. I also have to rebuild old CrystalReports-Rreports in RS. 90 % of them are using a "keep together" function.
I've read a lot in forums that there must be similar function in RS. I also found descriptions where this property should be, but there isn't.
For report-developing I used (RS2000 with VB.NET2003) and (RS2005 with VB.NET2005). Neither of them have this property for table/report.
Do I have to install a ServicePack?
Any other ideas?
DB Reporting Tools
8/22/2022 - Mon
What are you trying to 'keep together'? Tables? Sub reports?
There is a KeepTogether property on the table properties which will try and keep it on one page if possible, though it will depend on the amount of data being returned!
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
@simon_kirk: i want a "keep together"-property for a group in a table, not for the whole table. But I even have no Keep Together for the whole table like you told. Problem is i have in this group about four datarows and they should stay together. If I put a page brake after each group the report gets to long and there will be a lot of space on the page.
@dnsvh: in CR you can keep group areas together. I want to solve this in an RS table. I didn't work with ListView, tried it now for a short test... interesting. Tomorrow I'll try some more and tell you if its that what i wanted.
Now I tried a lot with the List-Control, but I'm not really positive to that. First output I did was really good, but depending on the data the page break isn't right. I put two textboxes in List and one of them gets data with a lot "NewLines", so the textbox.value has a lot of lines. If this textbox gets to big, it is printed on the next site. the other textbox stays on the site before.
In the properties-panel I see the keep together property. But it doesn't work correctly.
Is there a SP to solve that? Or another (free) control which handels that right?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
Sorry, but I don't think anything here answered this question. I found the following answer, which actually worked in my situation.
Hi. I found a workaround to this problem which may help you. As far as I can
tell, the table "keep together" property only applies to individual detail
rows i.e. if you have multiple detail lines, they can still span pages.
If you can use a single detail row with multiple lines, the keep together
will work on those lines.
To create a detail row with multile lines, you can use the
"environment.newline()" function in expressions within the detail row. (This
function does not appear to be documented in an obvious location).
e.g. an expression like . . .
=Fields!line_1.value & environment.newline() & Fields!line_2.value
will result in two lines, but using a single detail row.
Hope this helps. It won't help with keeping your whole table on one page.
Reporting Services seems to be deficient in this area.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent