This is a migrated thread and some comments may be shown as answers.

Best practices for large strings in group

0 Answers 54 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Joel
Top achievements
Rank 2
Joel asked on 10 Jul 2010, 02:24 PM
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?

Thanks.

-Joel

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Joel
Top achievements
Rank 2
Share this question
or