Best practices for large strings in group

1 posts, 0 answers
  1. Joel
    Joel avatar
    165 posts
    Member since:
    Oct 2006

    Posted 10 Jul 2010 Link to this post

    Curious what the best practice would be for this situation.

    I have a report I am building with about 700 groups.  Each group has approx 75 detail rows.  I am passing a datatable to the report as the datasource.  The datatable has 21 columns and approx 50000 rows.  The report works great excluding the problem below.

    In the group header section there is a long string of text (varchar(max)) which serves as the description for the group.  It seems the "best way" is to return that description iteratively for each row as a column in the datatable.  This is of course quite inefficient on several levels.

    What would be the best practice to have the items that display only in the group header portion only sent once, not 75 times, in this instance?


Back to Top