Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to repeat data in grouped cells? Expand / Collapse
Author
Message
Posted Wednesday, July 3, 2013 3:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 8, 2013 11:06 AM
Points: 1, Visits: 3
When I add row groups with an expression in the last column (=CountRows()) I get a report that looks like this:

DATE       PRODUCT      COUNT
july 1 red shirt 3
white shirt 7
july 2 red shirt 12
white shirt 14


When I export to excel, the first column is not repeated. I want it to repeat like this instead while retaining the grouping in the exported file:

DATE       PRODUCT      COUNT
july 1 red shirt 3
july 1 white shirt 7
july 2 red shirt 12
july 2 white shirt 14


Is there a way to do that?
Post #1470254
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse