ASP.net Detail CR Report

[dvannoy]

I am using the CR Built into asp.net.

I am running a UNION SP and trying to create multi detail section on my report.

I have 5 tables that I would like to put into seperate sections of the report so the report will Summarize each section.
I have a field in each table that will specify what type the field is.

Now, when I try and format the field using the Select Expert, the first time works great. As I add that same field to another section and use the Select Expert to specify the next section, the first section stays there and adds the second section as well. how can I break these up to create 5 seperat sections?

Thanks in advance

 

[IanWaterman]

I assume you mean section expert not select expert.

In the section expert conditionally suppress, your group section.

eg section 1 contains data from table 1, in the suppress formula add

{fieldname} <> table1ID

in section 2
{fieldname} <> table2ID

This will then suppress those sections when not in corresponding table ID. This will require you to group the report by tableID.

Ian

 

[lbass]

If you meant by "type" that the type specifies the particular table, then group on the type field, and then the corresponding details will be displayed.

-LB