SQL Server Performance

Keep Together Function

Discussion in 'SQL Server 2005 Reporting Services' started by Babin, Jan 15, 2007.

  1. Babin New Member

    My requirement is to keep the detailed row and the group total together. ie Group total has to be with at least one detail row. In Crystal report, this can be achieved by Keep Together Function.

    SQL reporting as far my knowledge has got a check box for the table which reads, "Fit table on one page if possible".

    I am using SQL 2000. In my report, this option is checked. Still, its not holding water sometimes. Is there any thing else we have to take care off like size of the row or something like? Has any body come across this similar issue, any work around?

    Thanks in Advance,
    Babin
  2. satya Moderator

    There is such setting about KeepTogether property where you can define in the report.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. Babin New Member

    Satya,
    Thankyou for your responce.

    I have already used the KeepTogether property checked for the report. My question was, still the problem persist and is there anything other than this we need to do to keep the header and atleast one detail row together.
  4. satya Moderator

    What version of Reporting services are used here?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. Babin New Member

    Satya,
    We are using Reporting Service 2000.
  6. satya Moderator

    Hm, I was under impression it is RS 2005. Apologies that I haven't got much experience with RS 2000 in this case. But if I find anything relevant I will post here.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. mcpints New Member

    Did anyone have any luck with this? I have the same issue (RS 2005) where I need to "keep together" a table group. This was very simple in Crystal Reports (just a simple checkbox). I've searched forum after forum and nobody's been able to do this.
  8. MichaelB Member

    It is a known aggrevation in RS. I am also originally a CR developer and find this very very frustrating. It is my understanding that you have a keep together property for a rectangle or a list box, but not in a table or matrix. That is my issue. You can keep them together in the same cell in a table but it will share the formatting of the cell (which is what is driving me crazy right now)

    sorry I couldnt be more help

    Michael
    MCDBA

    "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  9. MichaelB Member

    There is now one solution to my issue and that is keep it in the same row as the footer row in the table object. But then it needs to be formatted differently which it doesnt appear to be able to do since the cell in the table has the bold property and not the next and also since it wont render html. sigh...
    any suggestions?

    Michael
    MCDBA

    "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  10. MichaelB Member

    I had to create two "tables". One for the report and one for the totals line with a footer. This works since they are kept together per "table". Sigh...

    Michael
    MCDBA

    "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"

Share This Page