Calculated field crashes VS

I had a separate post where I was having trouble displaying the entire record in the group header that was that had the max value for the details. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=641646&SiteID=1

With some help, I used a nested table in the group header, which worked perfectly except when I export the report to Excel (end user requirement) those values are replaced with ''Data Regions within table/matrix cells are ignored.''

For a workaround, I tried adding the following expression to a text box in the detail row of the table.

=iif(Fields!MAX.Value = max(Fields!MAX.Value), Fields!ASA.Value * 100, Fields!ASA.Value)

This will check the max value against the max for the group. If the max value is truely the max, it will multiple the field I am trying to display in the group header by 100. I figured I could then do a max( ) on that field in my group header, but I had no way to reference it. So...I created a calculated field with the same formula - only problem is now VS crashes until I remove the calculate field.

Any ideas why? Or if there is a way to handle this?

It is a known problem that using aggregate functions in calculated field crashes VS. We are considering fixing it in a future release. However, this scenario is not allowed. You'd get an error message when the bug is fixed.|||Thank you! Any other ideas on how I can accomplish the desired results?

Business Object XI Variable Help

Hi All!

I am creating a report that lists every prescription a person is taking and the "Disease State" it is in. In the Group Header I need to list all the Disease States that this person is taking a prescription for. However, I cannot figure out how to do it.

In the details section, I have a formula for disease state. The person can be taking prescriptions for the same disease states. Therefore, the detail section could look like:
Diabetes
Diabetes
CHF
Diabetes

In the Group Header I need to output:
Diabetes, CHF

Does anyone know how to do this?
Thanks.
DanielleProbably the easiest way is to create a manual running total that will create a string containig unique disease states for each person. Then you can hide details and display person name and disease states in group footer.