Multiple details sections, possible?

Hot Topic

creating users in sql eypress
how is top % filter used?
Deploying Jet OleDb Provider
Database for workload analysis
Can not connect to SQL Express from a different computer
Problems Setting DTS Global Variables after Rebuild
Multi value string parameters
View with SELECT * doesn't pickup new columns in table
Can we create two servicess in a same database?
I've got the June CTP Sql 2005 but SSIS doesn't work

SQL Server

Chart Colours
Co-exist of SQL 2000 and 2005
Processing NULL values
AVG Function Overflow
Help on calculated member
How can you change the isolation level for SSIS transactions
Error on SQL cluster install
Troble copying data between SQL 2000 and SQL 2005
Debugging a script component task???
How Create SQL CLR Functions in Yukon June CTP

Multiple details sections, possible?

In a table the details section is called "table1_Details_Group". Is it possible to add a second details group so that I can have the two groups have different group properties

I'm trying to avoid creating a second table and using an expression to only show one at a time.

Again Thanks.

Answer this question

Multiple details sections, possible?

  • Jimmy Wu - MSFT

    Thanks but the details section of a table seems not to fit the general information you linked to. For instance I can change the name of any group except the details group and the details group is not grouped on any expression.

    I don't think I can create a separate details group, something crystal allows, but was hoping there was a trick or process I was missing.

    So to be brief, can one table have more than one details group If so how is the second detail group created


  • dgmyers

    See this tutorial on adding groupings to a report. It uses a table for an example.

    http://msdn2.microsoft.com/en-us/library/ms170623.aspx

  • Lynette Johnson

    thanks.

  • Kory

    FYI, you can insert more rows for the detail group. These have their own properties but they aren't the same as a group. I don't know what particular group properties you are looking for.

  • neolace

    I don't think I am clear on what you mean by details group. A table can have multiple groups and each group will have it's own set of detail rows based on the grouping expression. Can you give me a better idea of what you are trying to accomplish

  • mjh


    Create a brand new table. This table will have 3 sections; a header, a details section/group/ and a footer. Right click on the details section and choose edit group. This will bring up the group information for the details section. For example the name of this group will probably be "table1_Details_Group".

    I want to have a second details group in the same table which will have different properties from the first. Can I do this


  • LIMTL

    No it isn't possible. How do you want your data to be displayed Maybe there is another path to the end result you are looking for.
  • Multiple details sections, possible?
Answer this question