Post reply

Removing grouping leaves only one line of data in tablix

  • April 17, 2012 at 8:49 am

    #392045

    Hello Forum,

    I have a couple of reports that I am attempting to reduce in size due to the number of records being returned. One of the the things I am attempting (unsuccessfully) is to remove a grouping. When I remove the group all I get is a single row of data for the report content when there should be over a thousand.

    Any pointers would be appreciated 🙂

  • April 24, 2012 at 9:56 am

    #1478328

    Sounds like you're removing your detail group i.e. your lowest grouping level that tell the report what field to iterate over to display. Without this piece of info it's aggregating over your whole data set.

    If you're looking to return only some rows that are more relevant than I would modify your query or add filters on the dataset.

    If you're looking to just cut down on the number of rows then using a 'chunkier' group (e.g. state not town) or by filtering to show the top N rows.

    If none of this helps, holler 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply